Microsoft Azure Analysis Service Monitoring
Microsoft Azure Analysis Service - An Overview
Azure Analysis Service is a fully managed platform-as-a-service (PaaS) that provides enterprise-grade data modeling and analytics capabilities in the cloud. Applications Manager's Azure Analysis Service monitoring tracks QPU consumption, memory utilization and limits, cleaner metrics, connection activity, row processing rates, thread pool activity, and job queue lengths.
Creating a new Microsoft Azure Analysis Service Monitor
To learn how to create a new Microsoft Azure Analysis Service monitor, click here.
Monitored Parameters
Navigate to the Category View by clicking the Monitors tab. Hover over 'Child Monitors' under Microsoft Azure in the Cloud Apps table, and then select the Analysis Services monitor from the displayed tooltip. This action will display the bulk configuration view for Microsoft Azure Analysis Service in three tabs:
- Availability tab gives the availability history for the past 24 hours or 30 days.
- Performance tab gives the health status and events for the past 24 hours or 30 days.
- List view tab enables you to perform bulk admin configurations.
Following are the list of metrics monitored in Microsoft Azure Analysis Service Monitoring in their corresponding tabs:
Performance Overview
| Parameter | Description |
|---|
| MEMORY THRASHING |
| Memory Thrashing | The average amount of memory thrashing in the Azure Analysis Service between the poll intervals (in %). |
| MASHUP ENGINE QPU |
| Mashup Engine QPU | The average amount of QPU usage by mashup engine processes in the Azure Analysis Service between the poll intervals. |
| QUERY PROCESSING UNITS |
| Query Processing Units | The average of Query Processing Units of the Azure Analysis Service between the poll intervals. |
| MEMORY QUOTA |
| Quota Blocked | The average number of current quota requests that are blocked until other memory quotas are freed in the Azure Analysis Service between the poll intervals. |
| CLEANER CURRENT PRICE |
| Cleaner Current Price | The average current price of memory, $/byte/time, normalized to 1000 in the Azure Analysis Service between the poll intervals. |
| CONNECTIONS |
| Total Connection Requests | The average number of total connection requests of the Azure Analysis Service between the poll intervals. |
| Total Connection Failures | The average number of failed connection attempts in the Azure Analysis Service between the poll intervals. |
| Current Connections | The average number of current client connections established in the Azure Analysis Service at the time of polling. |
| CURRENT USER SESSIONS |
| Current User Sessions | The average number of current user sessions established in the Azure Analysis Service at the time of polling. |
| SUCCESSFUL CONNECTIONS |
| Successful Connections | The average number of successful connection completions per second in the Azure Analysis Service between the poll intervals (in connections/s). |
| ROWS PROCESSING |
| Rows Read | The average number of rows read per second from all relational databases by the Azure Analysis Service between the poll intervals (in rows/s). |
| Rows Converted | The average number of rows converted per second during processing by the Azure Analysis Service between the poll intervals (in rows/s). |
| Rows Written | The average number of rows written per second during processing by the Azure Analysis Service between the poll intervals (in rows/s). |
Memory Usage
| Parameter | Description |
|---|
| MEMORY USAGE |
| Memory | The average amount of memory usage in the Azure Analysis Service between the poll intervals (in MB). |
| Private Data | The average amount of private memory usage in the Azure Analysis Service between the poll intervals (in MB). |
| Virtual Data | The average amount of virtual memory usage in the Azure Analysis Service between the poll intervals (in MB). |
| CLEANER MEMORY |
| Cleaner Memory Shrinkable | The average amount of memory, subject to purging by the background cleaner in the Azure Analysis Service between the poll intervals (in MB). |
| Cleaner Memory Nonshrinkable | The average amount of memory, not subject to purging by the background cleaner on the Azure Analysis Service between the poll intervals (in MB). |
| MEMORY LIMITS |
| Memory Usage | The average amount of memory usage of the server process as used in calculating cleaner memory price in the Azure Analysis Service at the time of polling (in MB). |
| Hard Memory Limit | The average amount of hard memory limit from configuration file in the Azure Analysis Service between the poll intervals (in MB). |
| High Memory Limit | The average amount of high memory limit from configuration file in the Azure Analysis Service between the poll intervals (in MB). |
| Low Memory Limit | The average amount of low memory limit from configuration file in the Azure Analysis Service between the poll intervals (in MB). |
| VertiPaq Memory Limit | The average amount of In-memory limit from configuration file of the Azure Analysis Service between the poll intervals (in MB). |
| VERTIPAQ MEMORY |
| Nonpaged VertiPaq | The average amount of memory data locked in the working set for use by the in-memory engine in the Azure Analysis Service between the poll intervals (in MB). |
| Paged VertiPaq | The average amount of paged memory data in use for in-memory data in the Azure Analysis Service between the poll intervals (in MB). |
| MASHUP ENGINE MEMORY |
| Mashup Engine Memory | The average amount of memory usage by mashup engine processes in the Azure Analysis Service between the poll intervals (in MB). |
| Mashup Engine Private Data | The average amount of private data usage by mashup engine processes in the Azure Analysis Service between the poll intervals (in MB). |
| Mashup Engine Virtual Data | The average amount of virtual data usage by mashup engine processes in the Azure Analysis Service between the poll intervals (in MB). |
| QUOTA |
| Quota | The average of current memory quota in the Azure Analysis Service between the poll intervals (in MB). |
Note: Memory Usage metrics are mapped under Performance Polling. To adjust the polling interval, navigate to Settings → Performance Polling. In the Optimize Data Collection tab, select Azure Analysis Service as the Monitor Type and Memory Usage as the Metric Name. Then set Default Polling Status as required, by default opted as Never collect data.
Queue Length
| Parameter | Description |
|---|
| COMMAND POOL JOB QUEUE LENGTH |
| Command Pool Job Queue Length | The average number of jobs in the command thread pool queue in the Azure Analysis Service between the poll intervals. |
| PROCESSING POOL QUEUE LENGTH |
| Processing Pool Job Queue Length | The average number of non-I/O jobs in the processing thread pool queue in the Azure Analysis Service between the poll intervals. |
| Processing Pool I/O Job Queue Length | The average number of I/O jobs in the processing thread pool queue of the Azure Analysis Service between the poll intervals. |
| PARSING POOL QUEUE LENGTH |
| Long Parsing Job Queue Length | The average number of jobs in the long parsing thread pool queue of the Azure Analysis Service between the poll intervals. |
| Short Parsing Job Queue Length | The average number of jobs in the short parsing thread pool queue of the Azure Analysis Service between the poll intervals. |
| QUERY POOL QUEUE LENGTH |
| Query Pool Job Queue Length | The average number of jobs in the query thread pool queue of the Azure Analysis Service between the poll intervals. |
Note: Queue Length metrics are mapped under Performance Polling. To adjust the polling interval, navigate to Settings → Performance Polling. In the Optimize Data Collection tab, select Azure Analysis Service as the Monitor Type and Queue Length as the Metric Name. Then set Default Polling Status as required, by default opted as Never collect data.
Thread Statistics
| Parameter | Description |
|---|
| COMMAND POOL THREADS |
| Command Pool Busy Threads | The average number of busy threads in the command thread pool of the Azure Analysis Service between the poll intervals. |
| Command Pool Idle Threads | The average number of idle threads in the command thread pool of the Azure Analysis Service between the poll intervals. |
| QUERY POOL THREADS |
| Query Pool Busy Threads | The average number of busy threads in the query thread pool of the Azure Analysis Service between the poll intervals. |
| Query Pool Idle Threads | The average number of idle threads for I/O jobs in the processing thread pool of the Azure Analysis Service between the poll intervals. |
| PROCESSING POOL THREADS |
| Processing Pool Busy I/O Job Threads | The average number of threads running I/O jobs in the processing thread pool of the Azure Analysis Service between the poll intervals. |
| Processing Pool Busy Non I/O Threads | The average number of threads running non-I/O jobs in the processing thread pool of the Azure Analysis Service between the poll intervals. |
| Processing Pool Idle I/O Job Threads | The average number of idle threads for I/O jobs in the processing thread pool of the Azure Analysis Service between the poll intervals. |
| Processing Pool Idle Non I/O Threads | The average number of idle threads in the processing thread pool dedicated to non-I/O jobs of the Azure Analysis Service between the poll intervals. |
| PARSING POOL THREADS |
| Long Parsing Busy Threads | The average number of busy threads in the long parsing thread pool of the Azure Analysis Service between the poll intervals. |
| Long Parsing Idle Threads | The average number of idle threads in the long parsing thread pool of the Azure Analysis Service between the poll intervals. |
| Short Parsing Busy Threads | The average number of busy threads in the short parsing thread pool of the Azure Analysis Service between the poll intervals. |
| Short Parsing Idle Threads | The average number of idle threads in the short parsing thread pool of the Azure Analysis Service between the poll intervals. |
Note: Thread Statistics metrics are mapped under Performance Polling. To adjust the polling interval, navigate to Settings → Performance Polling. In the Optimize Data Collection tab, select Azure Analysis Service as the Monitor Type and Thread Statistics as the Metric Name. Then set Default Polling Status as required, by default opted as Never collect data.
Configuration
| Parameter | Description |
|---|
| CONFIGURATION |
| Resource Group Name | The name of the Azure resource group that contains the Analysis Services server. |
| Location | The Azure region where the Analysis Services server is deployed. |
| State | The current state of the Analysis Services resource. Possible values: Deleting, Succeeded, Failed, Paused, Suspended, Provisioning, Updating, Suspending, Pausing, Resuming, Preparing, Scaling. |
| Provisioning State | The current deployment state of the Analysis Services resource. Possible values: Deleting, Succeeded, Failed, Paused, Suspended, Provisioning, Updating, Suspending, Pausing, Resuming, Preparing, Scaling. |
| SKU Name | The name of the SKU level for the Analysis Services server. |
| SKU Tier | The Azure pricing tier associated with the SKU. Possible values: Development, Basic, Standard. |
| SKU Capacity | The number of instances in the read-only query pool. Valid range: 1—8. |
| Server Full Name | The full name of the Analysis Services resource used to connect to the server. |
