Azure Analysis Services

Introduction

Azure Analysis Services is a fully managed platform as a service (PaaS) that provides enterprise-grade data models in the cloud.

Use advanced mashup and modeling features to combine data from multiple data sources, define metrics, and secure your data in a single, trusted tabular semantic data model. The data model provides an easier and faster way for users to browse massive amounts of data for ad hoc data analysis.

Note

Use the OpsRamp Azure public cloud integration to discover and collect metrics against the Azure service.

Setup

To set up the OpsRamp Azure integration and discover the Azure service, go to Azure Integration Discovery Profile and select Analysis Service.

Metrics


OpsRamp Metric	Metric Display Name	Unit	Aggregation Type	Description
azure_qpu_metric	QPU	Count	Average	QPU. Range 0-100 for S1, 0-200 for S2 and 0-400 for S
azure_memory_metric	Memory	Bytes	Average	Memory. Range 0-25 GB for S1, 0-50 GB for S2 and 0-100 GB for S4
azure_total_connection_requests	Total Connection Requests	Count	Average	Total connection requests. These are arrivals.
azure_successfull_connections_per_sec	Successful Connections Per Sec	CountPerSecond	Average	Number of workflow runs failed.
azure_total_connection_failures	Total Connection Failures	Count	Average	Number of workflow runs canceled.
azure_current_user_sessions	Current User Sessions	Count	Average	Current number of user sessions established.
azure_query_pool_busy_threads	Query Pool Busy Threads	Seconds	Average	Number of busy threads in the query thread pool.
azure_command_pool_job_queue_length	Command Pool Job Queue Length	Count	Average	Number of workflow action or trigger throttled events.
azure_processing_pool_job_queue_length	Processing Pool Job Queue Length	Count	Average	Number of non-I\O jobs in the queue of the processing thread pool.
azure_current_connections	Connection: Current connections	Count	Average	Current number of client connections established.
azure_cleaner_current_price	Memory: Cleaner Current Price	Count	Average	Current price of memory, $/byte/time, normalized to 1000.
azure_cleaner_memory_shrinkable	Memory: Cleaner Memory shrinkable	Bytes	Average	Amount of memory, in bytes, subject to purging by the background
azure_cleaner_memory_nonshrinkable	Memory: Cleaner Memory nonshrinkable	Bytes	Average	Amount of memory, in bytes, not subject to purging by the background cleaner.
azure_memory_usage	Memory: Memory Usage	Bytes	Average	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.
azure_memory_limit_hard	Memory: Memory Limit Hard	Bytes	Average	Hard memory limit, from configuration file.
azure_memory_limit_high	Memory: Memory Limit High	Bytes	Average	High memory limit, from configuration file.
azure_memory_limit_low	Memory: Memory Limit Low	Bytes	Average	Low memory limit, from configuration file.
azure_memory_limit_verti_paq	Memory: Memory Limit VertiPaq	Bytes	Average	In-memory limit, from configuration file.
azure_quota	Memory: Quota	Bytes	Average	Current memory quota, in bytes. Memory quota is also known as a memory grant or memory reservation.
azure_quota_blocked	Memory: Quota Blocked	Count	Average	Current number of quota requests that are blocked until other memory quotas are freed.
azure_verti_paq_nonpaged	Memory: VertiPaq Nonpaged	Bytes	Average	Bytes of memory locked in the working set for use by the in-memory engine.
azure_verti_paq_paged	Memory: VertiPaq Paged	Bytes	Average	Bytes of paged memory in use for in-memory data.
azure_rows_read_per_sec	Processing: Rows read per sec	CountPerSecond	Average	Rate of rows read from all relational databases.
azure_rows_converted_per_sec	Processing: Rows converted per sec	CountPerSecond	Average	Rate of rows converted during processing.
azure_rows_written_per_sec	Processing: Rows written per sec	CountPerSecond	Average	Rate of rows written during processing.
azure_command_pool_busy_threads	Threads: Command pool busy threads	Count	Average	Number of busy threads in the command thread pool.
azure_command_pool_idle_threads	Threads: Command pool idle threads	Count	Average	Number of idle threads in the command thread pool.
azure_long_parsing_busy_threads	Threads: Long parsing busy threads	Count	Average	Number of busy threads in the long parsing thread pool.
azure_long_parsing_idle_threads	Threads: Long parsing idle threads	Count	Average	Number of idle threads in the long parsing thread pool.
azure_long_parsing_job_queue_length	Threads: Long parsing job queue length	Count	Average	Number of jobs in the queue of the long parsing thread pool.
azure_long_parsing_job_queue_length	Threads: Processing pool busy I/O job threads	Count	Average	Number of jobs in the queue of the long parsing thread pool.
azure_processing_pool_busy_io_job_threads	Threads: Processing pool busy I/O job threads	Count	Average	Number of threads running I/O jobs in the processing thread pool.
azure_processing_pool_busy_non_io_job_threads	Threads: Processing pool busy non-I/O threads	Count	Average	Number of threads running non-I/O jobs in the processing thread pool.
azure_processing_pool_io_job_queue_length	Threads: Processing pool I/O job queue length	Count	Average	Number of I/O jobs in the queue of the processing thread pool.
azure_processing_pool_idle_io_job_threads	Threads: Processing pool idle I/O job threads	Count	Average	Number of idle threads for I/O jobs in the processing thread pool.
azure_processing_pool_idle_non_io_threads	Threads: Processing pool idle non-I/O threads	Count	Average	Number of idle threads in the processing thread pool dedicated to non-I/O jobs.
azure_query_pool_idle_threads	Threads: Query pool idle threads	Count	Average	Number of idle threads for I/O jobs in the processing thread pool.
azure_query_pool_job_queue_length	Threads: Query pool job queue length	Count	Average	Number of jobs in the queue of the query thread pool.
azure_short_parsing_busy_threads	Threads: Short parsing busy threads	Count	Average	Number of busy threads in the short parsing thread pool.
azure_short_parsing_idle_threads	Threads: Short parsing idle threads	Count	Average	Number of idle threads in the short parsing thread pool.
azure_short_parsing_job_queue_length	Threads: Short parsing job queue length	Count	Average	Number of jobs in the queue of the short parsing thread pool.
azure_mashup_engine_QPU_metric	M Engine QPU	Count	Average	QPU usage by mashup engine processes.
azure_mashup_engine_memory_metric	M Engine Memory	Count	Average	Memory usage by mashup engine processes.
azure_memory_thrashing_metric	Memory Thrashing	Percent	Average	Average memory thrashing.
azure_private_bytes_metric	Private Bytes	Bytes	Average	Total amount of memory the Analysis Services engine process and Mashup container processes have allocated, not including memory shared with other processes.
azure_virtual_bytes_metric	Virtual Bytes	Bytes	Average	Current size of the virtual address space that Analysis Services engine process and Mashup container processes are using.
cloud_instance_state	Status/State	n/a	n/a	Analysis Service state metric.

Event support

Supported
Configurable in OpsRamp Azure Integration Discovery Profile.

External reference

Azure Monitor - Platform metrics