Azure Analysis Services monitoring data reference

  • Article

This article contains all the monitoring reference information for this service.

See Monitor Azure Analysis Services for details on the data you can collect for Azure Analysis Services and how to use it.

Metrics

This section lists all the automatically collected platform metrics for this service. These metrics are also part of the global list of all platform metrics supported in Azure Monitor.

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

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 Create diagnostic settings in Azure Monitor.
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

Metric dimensions

For information about what metric dimensions are, see Multi-dimensional metrics.

This service has the following dimensions associated with its metrics.

Analysis Services metrics have the dimension ServerResourceType.

Resource logs

This section lists the types of resource logs you can collect for this service. The section pulls from the list of all resource logs category types supported in Azure Monitor.

Supported resource logs for Microsoft.AnalysisServices/servers

Category Category display name Log table Supports basic log plan Supports ingestion-time transformation Example queries Costs to export
Engine Engine AzureDiagnostics

Logs from multiple Azure resources.

 No No No
Service Service AzureDiagnostics

Logs from multiple Azure resources.

 No No No

When you set up logging for Analysis Services, you can select Engine or Service events to log.

Engine

The Engine category logs all xEvents. You can't select individual events.

XEvent categories Event name
Security Audit Audit Login
Security Audit Audit Logout
Security Audit Audit Server Starts And Stops
Progress Reports Progress Report Begin
Progress Reports Progress Report End
Progress Reports Progress Report Current
Queries Query Begin
Queries Query End
Commands Command Begin
Commands Command End
Errors & Warnings Error
Discover Discover End
Notification Notification
Session Session Initialize
Locks Deadlock
Query Processing VertiPaq SE Query Begin
Query Processing VertiPaq SE Query End
Query Processing VertiPaq SE Query Cache Match
Query Processing Direct Query Begin
Query Processing Direct Query End

Service

The Service category logs the following events:

Operation name Occurs when
ResumeServer Resume a server
SuspendServer Pause a server
DeleteServer Delete a server
RestartServer User restarts a server through SSMS or PowerShell
GetServerLogFiles User exports server log through PowerShell
ExportModel User exports a model in the portal by using Open in Visual Studio

Azure Monitor Logs tables

This section refers to all of the Azure Monitor Logs tables relevant to this service, which are available for query by Log Analytics using Kusto queries.

This service uses the listed tables to store resource log data. The following columns are relevant.

Analysis Services

microsoft.analysisservices/servers

When you set up logging, selecting AllMetrics logs the server metrics to the AzureMetrics table. If you're using query scale-out and need to separate metrics for each read replica, use the AzureDiagnostics table instead, where OperationName is equal to LogMetric.

Activity log

The linked table lists the operations that may be recorded in the activity log for this service. This is a subset of all the possible resource provider operations in the activity log.

For more information on the schema of activity log entries, see Activity Log schema.

Related content