Muokkaa

Jaa


Supported metrics for Microsoft.AnalysisServices/servers

The following table lists the metrics available for the Microsoft.AnalysisServices/servers resource type.

Table headings

Metric - The metric display name as it appears in the Azure portal.
Name in Rest API - Metric name as referred to in the REST API.
Unit - Unit of measure.
Aggregation - The default aggregation type. Valid values: Average, Minimum, Maximum, Total, Count.
Dimensions - Dimensions available for the metric.
Time Grains - Intervals at which the metric is sampled. For example, PT1M indicates that the metric is sampled every minute, PT30M every 30 minutes, PT1H every hour, and so on.
DS Export- Whether the metric is exportable to Azure Monitor Logs via Diagnostic Settings.

For information on exporting metrics, see - Metrics export using data collection rules and Create diagnostic settings in Azure Monitor.

For information on metric retention, see Azure Monitor Metrics overview.

For a list of supported logs, see Supported log categories - Microsoft.AnalysisServices/servers

Metric Name in REST API Unit Aggregation Dimensions Time Grains DS Export
Memory: Cleaner Current Price

Current price of memory, $/byte/time, normalized to 1000.
CleanerCurrentPrice Count Average ServerResourceType PT1M Yes
Memory: Cleaner Memory nonshrinkable

Amount of memory, in bytes, not subject to purging by the background cleaner.
CleanerMemoryNonshrinkable Bytes Average ServerResourceType PT1M Yes
Memory: Cleaner Memory shrinkable

Amount of memory, in bytes, subject to purging by the background cleaner.
CleanerMemoryShrinkable Bytes Average ServerResourceType PT1M Yes
Threads: Command pool busy threads

Number of busy threads in the command thread pool.
CommandPoolBusyThreads Count Average ServerResourceType PT1M Yes
Threads: Command pool idle threads

Number of idle threads in the command thread pool.
CommandPoolIdleThreads Count Average ServerResourceType PT1M Yes
Command Pool Job Queue Length

Number of jobs in the queue of the command thread pool.
CommandPoolJobQueueLength Count Average ServerResourceType PT1M Yes
Connection: Current connections

Current number of client connections established.
CurrentConnections Count Average ServerResourceType PT1M Yes
Current User Sessions

Current number of user sessions established.
CurrentUserSessions Count Average ServerResourceType PT1M Yes
Threads: Long parsing busy threads

Number of busy threads in the long parsing thread pool.
LongParsingBusyThreads Count Average ServerResourceType PT1M Yes
Threads: Long parsing idle threads

Number of idle threads in the long parsing thread pool.
LongParsingIdleThreads Count Average ServerResourceType PT1M Yes
Threads: Long parsing job queue length

Number of jobs in the queue of the long parsing thread pool.
LongParsingJobQueueLength Count Average ServerResourceType PT1M Yes
M Engine Memory

Memory usage by mashup engine processes
mashup_engine_memory_metric Bytes Average ServerResourceType PT1M Yes
M Engine Private Bytes

Private bytes usage by mashup engine processes.
mashup_engine_private_bytes_metric Bytes Average ServerResourceType PT1M Yes
M Engine QPU

QPU usage by mashup engine processes
mashup_engine_qpu_metric Count Average ServerResourceType PT1M Yes
M Engine Virtual Bytes

Virtual bytes usage by mashup engine processes.
mashup_engine_virtual_bytes_metric Bytes Average ServerResourceType PT1M Yes
Memory

Memory. Range 0-25 GB for S1, 0-50 GB for S2 and 0-100 GB for S4
memory_metric Bytes Average ServerResourceType PT1M Yes
Memory Thrashing

Average memory thrashing.
memory_thrashing_metric Percent Average ServerResourceType PT1M Yes
Memory: Memory Limit Hard

Hard memory limit, from configuration file.
MemoryLimitHard Bytes Average ServerResourceType PT1M Yes
Memory: Memory Limit High

High memory limit, from configuration file.
MemoryLimitHigh Bytes Average ServerResourceType PT1M Yes
Memory: Memory Limit Low

Low memory limit, from configuration file.
MemoryLimitLow Bytes Average ServerResourceType PT1M Yes
Memory: Memory Limit VertiPaq

In-memory limit, from configuration file.
MemoryLimitVertiPaq Bytes Average ServerResourceType PT1M Yes
Memory: Memory Usage

Memory usage of the server process as used in calculating cleaner memory price. Equal to counter Process\PrivateBytes plus the size of memory-mapped data, ignoring any memory which was mapped or allocated by the xVelocity in-memory analytics engine (VertiPaq) in excess of the xVelocity engine Memory Limit.
MemoryUsage Bytes Average ServerResourceType PT1M Yes
Private Bytes

Private bytes.
private_bytes_metric Bytes Average ServerResourceType PT1M Yes
Threads: Processing pool busy I/O job threads

Number of threads running I/O jobs in the processing thread pool.
ProcessingPoolBusyIOJobThreads Count Average ServerResourceType PT1M Yes
Threads: Processing pool busy non-I/O threads

Number of threads running non-I/O jobs in the processing thread pool.
ProcessingPoolBusyNonIOThreads Count Average ServerResourceType PT1M Yes
Threads: Processing pool idle I/O job threads

Number of idle threads for I/O jobs in the processing thread pool.
ProcessingPoolIdleIOJobThreads Count Average ServerResourceType PT1M Yes
Threads: Processing pool idle non-I/O threads

Number of idle threads in the processing thread pool dedicated to non-I/O jobs.
ProcessingPoolIdleNonIOThreads Count Average ServerResourceType PT1M Yes
Threads: Processing pool I/O job queue length

Number of I/O jobs in the queue of the processing thread pool.
ProcessingPoolIOJobQueueLength Count Average ServerResourceType PT1M Yes
Processing Pool Job Queue Length

Number of non-I/O jobs in the queue of the processing thread pool.
ProcessingPoolJobQueueLength Count Average ServerResourceType PT1M Yes
QPU

QPU. Range 0-100 for S1, 0-200 for S2 and 0-400 for S4
qpu_metric Count Average ServerResourceType PT1M Yes
Query Pool Busy Threads

Number of busy threads in the query thread pool.
QueryPoolBusyThreads Count Average ServerResourceType PT1M Yes
Threads: Query pool idle threads

Number of idle threads for I/O jobs in the processing thread pool.
QueryPoolIdleThreads Count Average ServerResourceType PT1M Yes
Threads: Query pool job queue lengt

Number of jobs in the queue of the query thread pool.
QueryPoolJobQueueLength Count Average ServerResourceType PT1M Yes
Memory: Quota

Current memory quota, in bytes. Memory quota is also known as a memory grant or memory reservation.
Quota Bytes Average ServerResourceType PT1M Yes
Memory: Quota Blocked

Current number of quota requests that are blocked until other memory quotas are freed.
QuotaBlocked Count Average ServerResourceType PT1M Yes
Processing: Rows converted per sec

Rate of rows converted during processing.
RowsConvertedPerSec CountPerSecond Average ServerResourceType PT1M Yes
Processing: Rows read per sec

Rate of rows read from all relational databases.
RowsReadPerSec CountPerSecond Average ServerResourceType PT1M Yes
Processing: Rows written per sec

Rate of rows written during processing.
RowsWrittenPerSec CountPerSecond Average ServerResourceType PT1M Yes
Threads: Short parsing busy threads

Number of busy threads in the short parsing thread pool.
ShortParsingBusyThreads Count Average ServerResourceType PT1M Yes
Threads: Short parsing idle threads

Number of idle threads in the short parsing thread pool.
ShortParsingIdleThreads Count Average ServerResourceType PT1M Yes
Threads: Short parsing job queue length

Number of jobs in the queue of the short parsing thread pool.
ShortParsingJobQueueLength Count Average ServerResourceType PT1M Yes
Successful Connections Per Sec

Rate of successful connection completions.
SuccessfullConnectionsPerSec CountPerSecond Average ServerResourceType PT1M Yes
Total Connection Failures

Total failed connection attempts.
TotalConnectionFailures Count Average ServerResourceType PT1M Yes
Total Connection Requests

Total connection requests. These are arrivals.
TotalConnectionRequests Count Average ServerResourceType PT1M Yes
Memory: VertiPaq Nonpaged

Bytes of memory locked in the working set for use by the in-memory engine.
VertiPaqNonpaged Bytes Average ServerResourceType PT1M Yes
Memory: VertiPaq Paged

Bytes of paged memory in use for in-memory data.
VertiPaqPaged Bytes Average ServerResourceType PT1M Yes
Virtual Bytes

Virtual bytes.
virtual_bytes_metric Bytes Average ServerResourceType PT1M Yes

Next steps