Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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,
PT1Mindicates that the metric is sampled every minute,PT30Mevery 30 minutes,PT1Hevery 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 | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Memory: Cleaner Current Price Current price of memory, $/byte/time, normalized to 1000. |
CleanerCurrentPrice |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Memory: Cleaner Memory nonshrinkable Amount of memory, in bytes, not subject to purging by the background cleaner. |
CleanerMemoryNonshrinkable |
No | Bytes | Average | ServerResourceType |
PT1M | Yes |
| Memory: Cleaner Memory shrinkable Amount of memory, in bytes, subject to purging by the background cleaner. |
CleanerMemoryShrinkable |
No | Bytes | Average | ServerResourceType |
PT1M | Yes |
| Threads: Command pool busy threads Number of busy threads in the command thread pool. |
CommandPoolBusyThreads |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Threads: Command pool idle threads Number of idle threads in the command thread pool. |
CommandPoolIdleThreads |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Command Pool Job Queue Length Number of jobs in the queue of the command thread pool. |
CommandPoolJobQueueLength |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Connection: Current connections Current number of client connections established. |
CurrentConnections |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Current User Sessions Current number of user sessions established. |
CurrentUserSessions |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Threads: Long parsing busy threads Number of busy threads in the long parsing thread pool. |
LongParsingBusyThreads |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Threads: Long parsing idle threads Number of idle threads in the long parsing thread pool. |
LongParsingIdleThreads |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Threads: Long parsing job queue length Number of jobs in the queue of the long parsing thread pool. |
LongParsingJobQueueLength |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| M Engine Memory Memory usage by mashup engine processes |
mashup_engine_memory_metric |
No | Bytes | Average | ServerResourceType |
PT1M | Yes |
| M Engine Private Bytes Private bytes usage by mashup engine processes. |
mashup_engine_private_bytes_metric |
No | Bytes | Average | ServerResourceType |
PT1M | Yes |
| M Engine QPU QPU usage by mashup engine processes |
mashup_engine_qpu_metric |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| M Engine Virtual Bytes Virtual bytes usage by mashup engine processes. |
mashup_engine_virtual_bytes_metric |
No | 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 |
No | Bytes | Average | ServerResourceType |
PT1M | Yes |
| Memory Thrashing Average memory thrashing. |
memory_thrashing_metric |
No | Percent | Average | ServerResourceType |
PT1M | Yes |
| Memory: Memory Limit Hard Hard memory limit, from configuration file. |
MemoryLimitHard |
No | Bytes | Average | ServerResourceType |
PT1M | Yes |
| Memory: Memory Limit High High memory limit, from configuration file. |
MemoryLimitHigh |
No | Bytes | Average | ServerResourceType |
PT1M | Yes |
| Memory: Memory Limit Low Low memory limit, from configuration file. |
MemoryLimitLow |
No | Bytes | Average | ServerResourceType |
PT1M | Yes |
| Memory: Memory Limit VertiPaq In-memory limit, from configuration file. |
MemoryLimitVertiPaq |
No | 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 |
No | Bytes | Average | ServerResourceType |
PT1M | Yes |
| Private Bytes Private bytes. |
private_bytes_metric |
No | 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 |
No | 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 |
No | 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 |
No | 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 |
No | 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 |
No | 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 |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| QPU QPU. Range 0-100 for S1, 0-200 for S2 and 0-400 for S4 |
qpu_metric |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Query Pool Busy Threads Number of busy threads in the query thread pool. |
QueryPoolBusyThreads |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Threads: Query pool idle threads Number of idle threads for I/O jobs in the processing thread pool. |
QueryPoolIdleThreads |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Threads: Query pool job queue lengt Number of jobs in the queue of the query thread pool. |
QueryPoolJobQueueLength |
No | 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 |
No | Bytes | Average | ServerResourceType |
PT1M | Yes |
| Memory: Quota Blocked Current number of quota requests that are blocked until other memory quotas are freed. |
QuotaBlocked |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Processing: Rows converted per sec Rate of rows converted during processing. |
RowsConvertedPerSec |
No | CountPerSecond | Average | ServerResourceType |
PT1M | Yes |
| Processing: Rows read per sec Rate of rows read from all relational databases. |
RowsReadPerSec |
No | CountPerSecond | Average | ServerResourceType |
PT1M | Yes |
| Processing: Rows written per sec Rate of rows written during processing. |
RowsWrittenPerSec |
No | CountPerSecond | Average | ServerResourceType |
PT1M | Yes |
| Threads: Short parsing busy threads Number of busy threads in the short parsing thread pool. |
ShortParsingBusyThreads |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Threads: Short parsing idle threads Number of idle threads in the short parsing thread pool. |
ShortParsingIdleThreads |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Threads: Short parsing job queue length Number of jobs in the queue of the short parsing thread pool. |
ShortParsingJobQueueLength |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Successful Connections Per Sec Rate of successful connection completions. |
SuccessfullConnectionsPerSec |
No | CountPerSecond | Average | ServerResourceType |
PT1M | Yes |
| Total Connection Failures Total failed connection attempts. |
TotalConnectionFailures |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Total Connection Requests Total connection requests. These are arrivals. |
TotalConnectionRequests |
No | Count | Average | ServerResourceType |
PT1M | Yes |
| Memory: VertiPaq Nonpaged Bytes of memory locked in the working set for use by the in-memory engine. |
VertiPaqNonpaged |
No | Bytes | Average | ServerResourceType |
PT1M | Yes |
| Memory: VertiPaq Paged Bytes of paged memory in use for in-memory data. |
VertiPaqPaged |
No | Bytes | Average | ServerResourceType |
PT1M | Yes |
| Virtual Bytes Virtual bytes. |
virtual_bytes_metric |
No | 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 | Costs to export | Log table | Supports basic log plan | Supports ingestion-time transformation | Example queries |
|---|---|---|---|---|---|
| Engine | No | AzureDiagnostics Logs from multiple Azure resources. |
No | No | |
| Service | No | AzureDiagnostics Logs from multiple Azure resources. |
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
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.
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.