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 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 MetricMetric Display NameUnitAggregation Type
azure_qpu_metric

QPU. Range 0-100 for S1, 0-200 for S2 and 0-400 for S
QPUCountAverage
azure_memory_metric

Memory. Range 0-25 GB for S1, 0-50 GB for S2 and 0-100 GB for S4
MemoryBytesAverage
azure_total_connection_requests

Total connection requests. These are arrivals.
Total Connection RequestsCountAverage
azure_successfull_connections_per_sec

Number of workflow runs failed.
Successful Connections Per SecCountPerSecondAverage
azure_total_connection_failures

Number of workflow runs canceled.
Total Connection FailuresCountAverage
azure_current_user_sessions

Current number of user sessions established.
Current User SessionsCountAverage
azure_query_pool_busy_threads

Number of busy threads in the query thread pool.
Query Pool Busy ThreadsSecondsAverage
azure_command_pool_job_queue_length

Number of workflow action or trigger throttled events.
Command Pool Job Queue LengthCountAverage
azure_processing_pool_job_queue_length

Number of non-I\O jobs in the queue of the processing thread pool.
Processing Pool Job Queue LengthCountAverage
azure_current_connections

Current number of client connections established.
Connection: Current connectionsCountAverage
azure_cleaner_current_price

Current price of memory, $/byte/time, normalized to 1000.
Memory: Cleaner Current PriceCountAverage
azure_cleaner_memory_shrinkable

Amount of memory, in bytes, subject to purging by the background
Memory: Cleaner Memory shrinkableBytesAverage
azure_cleaner_memory_nonshrinkable

Amount of memory, in bytes, not subject to purging by the background cleaner.
Memory: Cleaner Memory nonshrinkableBytesAverage
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 UsageBytesAverage
azure_memory_limit_hard

Hard memory limit, from configuration file.
Memory: Memory Limit HardBytesAverage
azure_memory_limit_high

High memory limit, from configuration file.
Memory: Memory Limit HighBytesAverage
azure_memory_limit_low

Low memory limit, from configuration file.
Memory: Memory Limit LowBytesAverage
azure_memory_limit_verti_paq

In-memory limit, from configuration file.
Memory: Memory Limit VertiPaqBytesAverage
azure_quota

Current memory quota, in bytes. Memory quota is also known as a memory grant or memory reservation.
Memory: QuotaBytesAverage
azure_quota_blocked

Current number of quota requests that are blocked until other memory quotas are freed.
Memory: Quota BlockedCountAverage
azure_verti_paq_nonpaged

Bytes of memory locked in the working set for use by the in-memory engine.
Memory: VertiPaq NonpagedBytesAverage
azure_verti_paq_paged

Bytes of paged memory in use for in-memory data.
Memory: VertiPaq PagedBytesAverage
azure_rows_read_per_sec

Rate of rows read from all relational databases.
Processing: Rows read per secCountPerSecondAverage
azure_rows_converted_per_sec

Rate of rows converted during processing.
Processing: Rows converted per secCountPerSecondAverage
azure_rows_written_per_sec

Rate of rows written during processing.
Processing: Rows written per secCountPerSecondAverage
azure_command_pool_busy_threads

Number of busy threads in the command thread pool.
Threads: Command pool busy threadsCountAverage
azure_command_pool_idle_threads

Number of idle threads in the command thread pool.
Threads: Command pool idle threadsCountAverage
azure_long_parsing_busy_threads

Number of busy threads in the long parsing thread pool.
Threads: Long parsing busy threadsCountAverage
azure_long_parsing_idle_threads

Number of idle threads in the long parsing thread pool.
Threads: Long parsing idle threadsCountAverage
azure_long_parsing_job_queue_length

Number of jobs in the queue of the long parsing thread pool.
Threads: Long parsing job queue lengthCountAverage
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 threadsCountAverage
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 threadsCountAverage
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 threadsCountAverage
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 lengthCountAverage
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 threadsCountAverage
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 threadsCountAverage
azure_query_pool_idle_threads

Number of idle threads for I/O jobs in the processing thread pool.
Threads: Query pool idle threadsCountAverage
azure_query_pool_job_queue_length

Number of jobs in the queue of the query thread pool.
Threads: Query pool job queue lengthCountAverage
azure_short_parsing_busy_threads

Number of busy threads in the short parsing thread pool.
Threads: Short parsing busy threadsCountAverage
azure_short_parsing_idle_threads

Number of idle threads in the short parsing thread pool.
Threads: Short parsing idle threadsCountAverage
azure_short_parsing_job_queue_length

Number of jobs in the queue of the short parsing thread pool.
Threads: Short parsing job queue lengthCountAverage
azure_mashup_engine_QPU_metric

QPU usage by mashup engine processes.
M Engine QPUCountAverage
azure_mashup_engine_memory_metric

Memory usage by mashup engine processes.
M Engine MemoryCountAverage
azure_memory_thrashing_metric

Average memory thrashing.
Memory ThrashingPercentAverage
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 BytesBytesAverage
azure_virtual_bytes_metric

Current size of the virtual address space that Analysis Services engine process and Mashup container processes are using.
Virtual BytesBytesAverage
cloud_instance_state

Analysis Service state metric.
Status/Staten/an/a

Event support

  • Supported
  • Configurable in OpsRamp Azure Integration Discovery Profile.

External reference