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.

Setup and configuration
Supported metrics
Threshold configuration
IT Automation
Configuration Rules

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

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

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

Monitor-level configuration

In the Site24x7 web client, go to Cloud > Azure and select Azure Analysis Service from the drop-down menu.
Choose a resource you would like to set a threshold for, then click the hamburger icon .
Select Edit, which directs you to the Edit Azure Analysis Service Monitor page.
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