Azure Analysis Service Monitoring Integration

Azure Analysis Services combines and analyzes data from multiple sources, sets metrics, and safeguards the data gathered, allowing you to sift through enormous amounts of data more quickly.

With Site24x7's integration, you can now monitor your Azure Analysis Services, configure thresholds, and receive alerts about critical issues.

Table of contents

Setup and configuration

You can add Azure Analysis Services while adding a new monitor or you can add it to an existing Azure monitor. Follow these steps to add the service.

Supported metrics

Metric name Description Statistic Unit
Memory: Cleaner Current Price The average current price of the memory Average Count
Memory: Cleaner Memory Non-shrinkable The amount of memory not subjected to purging by the background cleaner Average Bytes
Memory: Cleaner Memory Shrinkable The amount of memory subject to purging by the background cleaner Average Bytes
Threads: Command Pool Busy Threads The number of busy threads in the command thread pool Average Count
Threads: Command Pool Idle Threads The number of idle threads in the command thread pool Average Count
Command Pool Job Queue Length The number of jobs in the command thread pool's queue Average Count
Connection: Current Connections The number of client connections established currently Average Count
Current User Sessions The number of user sessions established currently Average Count
Threads: Long Parsing Busy Threads The number of busy threads in the long parsing thread pool Average Count
Threads: Long Parsing Idle Threads The number of idle threads in the long parsing thread pool Average Count
Threads: Long Parsing Job Queue Length The number of jobs in the long parsing thread pool's queue Average Count
M Engine Memory The memory usage by mashup engine processes Average Bytes
M Engine QPU The quantum processing unit (QPU) usage by mashup engine processes Average Count
Memory The amount of memory ranging from 0-25GB for S1, 0-50GB for S2, and 0-100GB for S4 Average Bytes
Memory Thrashing The average memory thrashing Average Percent
Memory: Memory Limit Hard The hard memory limit from the configuration file Average Bytes
Memory: Memory Limit High The high memory limit from the configuration file Average Bytes
Memory: Memory Limit Low The low memory limit from the configuration file Average Bytes
Memory: Memory Limit VertiPaq The in-memory limit from the configuration file Average Bytes
Memory: Memory Usage The memory usage of the server process as used in calculating the cleaner memory price Average Bytes
Threads: Processing Pool Busy I/O Job Threads The number of threads running  input-output (I/O) jobs in the processing thread pool Average Count
Threads: Processing Pool Busy Non-I/O Threads The number of threads running non-I/O jobs in the processing thread pool Average Count
Threads: Processing Pool Idle I/O Job Threads The number of idle threads for  the I/O jobs in the processing thread pool Average Count
Threads: Processing Pool Idle Non-I/O Threads The number of idle threads in the processing thread pool dedicated to non-I/O jobs Average Count
Threads: Processing Pool I/O Job Queue Length The number of I/O jobs in the processing thread pool's queue Average Count
Processing Pool Job Queue Length The number of non-I/O jobs in the processing thread pool's queue Average Count
QPU The amount of QPU ranging from 0-100 for S1, 0-200 for S2, and 0-400 for S4 Average Count
Query Pool Busy Threads The number of busy threads in the query thread pool Average Count
Threads: Query Pool Idle Threads The number of idle threads for the I/O jobs in the processing thread pool Average Count
Threads: Query Pool Job Queue Length The number of jobs in the query thread pool's queue Average Count
Memory: Quota The current memory quota Average Bytes
Memory: Quota Blocked The current number of quota requests that are blocked until other memory quotas are freed Average Count
Processing: Rows Converted per Sec The rate of rows converted during processing Average Count per Second
Processing: Rows Read per Sec The rate of rows read from all relational databases Average Count per Second
Processing: Rows Written per Sec The rate of rows written during processing Average Count per Second
Threads: Short Parsing Busy Threads The number of busy threads in the short parsing thread pool Average Count
Threads: Short Parsing Idle Threads The number of idle threads in the short parsing thread pool Average Count
Threads: Short Parsing Job Queue Length The number of jobs in the the short parsing thread pool's queue Average Count
Successful Connections per Sec The rate of successful connection completions Average Count per Second
Total Connection Failures The average of total failed connection attempts Average Count
Total Connection Requests The average of total connection requests Average Count
Memory: VertiPaq Non-paged The average amount of memory locked in the working set for use by the in-memory engine Average Bytes
Memory: VertiPaq Paged The average amount of the paged memory in use Average Bytes

Threshold configuration

Global configuration

  1. In the Site24x7 web client, go to the Admin section on the left navigation pane.
  2. Select Configuration Profiles from the left pane and select the Threshold and Availability (+) tab from the drop-down menu.
  3. Click Add Threshold Profile in the top-right corner.
  4. For Monitor Type, select Azure Analysis Service.

You can now set the threshold values for all the metrics listed above.

Monitor-level configuration

  1. In the Site24x7 web client, go to Cloud > Azure and select Azure Analysis Service from the drop-down menu.
  2. Choose a resource you would like to set a threshold for, then click the hamburger icon .
  3. Select Edit, which directs you to the Edit Azure Analysis Service Monitor page.
  4. You can set the threshold values for the metrics by selecting Threshold and Availability.

You can also configure IT Automation at the attribute level.

IT Automation

Site24x7 offers a set of exclusive IT Automation tools that automatically resolve performance degradation issues. These tools react to events proactively rather than waiting for manual intervention.

How to configure IT Automation for a monitor

Configuration Rules

With Site24x7's Configuration Rules, you can set parameters like Threshold Profile, Notification Profile, Tags, and Monitor Group for multiple monitors.

How to add a Configuration Rule

Related links:

How to add an Azure monitor
How to integrate an Azure App Service monitor
How to integrate Azure Virtual Machine monitor
How to configure IT Automations for a monitor
View the list of monitor reports

Was this document helpful?
Thanks for taking the time to share your feedback. We’ll use your feedback to improve our online help resources.