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