Azure Analysis Services monitoring data reference

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.

• All columns might not be present in every table.
• Some columns might be beyond the viewing area of the page. Select Expand table to view all available columns.

Table headings

• Category - The metrics group or classification.
• Metric - The metric display name as it appears in the Azure portal.
• Name in REST API - The metric name as referred to in the REST API.
• Unit - Unit of measure.
• Aggregation - The default aggregation type. Valid values: Average (Avg), Minimum (Min), Maximum (Max), Total (Sum), 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 lists the Azure Monitor Logs tables relevant to this service, which are available for query by Log Analytics using Kusto queries. The tables contain resource log data and possibly more depending on what is collected and routed to them.

Analysis Services

microsoft.analysisservices/servers

• AzureActivity
• AzureMetrics
• AzureDiagnostics

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 can be recorded in the activity log for this service. These operations are 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.

• Microsoft.AnalysisServices resource provider operations

Related content

• See Monitor Analysis Services for a description of monitoring Analysis Services.
• See Monitor Azure resources with Azure Monitor for details on monitoring Azure resources.