Azure Analysis Services

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	Azure Metric	Metric Display Name	Unit	Aggregation Type	Description
azure_analysisservices_servers_CleanerCurrentPrice	CleanerCurrentPrice	Memory: Cleaner Current Price	Count	Average	Current price of memory, $/byte/time, normalized to 1000.
azure_analysisservices_servers_CleanerMemoryNonshrinkable	CleanerMemoryNonshrinkable	Memory: Cleaner Memory nonshrinkable	Bytes	Average	Amount of memory, in bytes, not subject to purging by the background cleaner.
azure_analysisservices_servers_CleanerMemoryShrinkable	CleanerMemoryShrinkable	Memory: Cleaner Memory shrinkable	Bytes	Average	Amount of memory, in bytes, subject to purging by the background cleaner.
azure_analysisservices_servers_CommandPoolBusyThreads	CommandPoolBusyThreads	Threads: Command pool busy threads	Count	Average	Number of busy threads in the command thread pool.
azure_analysisservices_servers_CommandPoolIdleThreads	CommandPoolIdleThreads	Threads: Command pool idle threads	Count	Average	Number of idle threads in the command thread pool.
azure_analysisservices_servers_CommandPoolJobQueueLength	CommandPoolJobQueueLength	Command Pool Job Queue Length	Count	Average	Number of jobs in the queue of the command thread pool.
azure_analysisservices_servers_CurrentConnections	CurrentConnections	Connection: Current connections	Count	Average	Current number of client connections established.
azure_analysisservices_servers_CurrentUserSessions	CurrentUserSessions	Current User Sessions	Count	Average	Current number of user sessions established.
azure_analysisservices_servers_LongParsingBusyThreads	LongParsingBusyThreads	Threads: Long parsing busy threads	Count	Average	Number of busy threads in the long parsing thread pool.
azure_analysisservices_servers_LongParsingIdleThreads	LongParsingIdleThreads	Threads: Long parsing idle threads	Count	Average	Number of idle threads in the long parsing thread pool.
azure_analysisservices_servers_LongParsingJobQueueLength	LongParsingJobQueueLength	Threads: Long parsing job queue length	Count	Average	Number of jobs in the queue of the long parsing thread pool.
azure_analysisservices_servers_mashup_engine_memory_metric	mashup_engine_memory_metric	M Engine Memory	Bytes	Average	Memory usage by mashup engine processes
azure_analysisservices_servers_mashup_engine_private_bytes_metric	mashup_engine_private_bytes_metric	M Engine Private Bytes	Bytes	Average	Private bytes usage by mashup engine processes.
azure_analysisservices_servers_mashup_engine_qpu_metric	mashup_engine_qpu_metric	M Engine QPU	Count	Average	QPU usage by mashup engine processes
azure_analysisservices_servers_mashup_engine_virtual_bytes_metric	mashup_engine_virtual_bytes_metric	M Engine Virtual Bytes	Bytes	Average	Virtual bytes usage by mashup engine processes.
azure_analysisservices_servers_memory_metric	memory_metric	Memory	Bytes	Average	Memory. Range 0-25 GB for S1, 0-50 GB for S2 and 0-100 GB for S4
azure_analysisservices_servers_memory_thrashing_metric	memory_thrashing_metric	Memory Thrashing	Percent	Average	Average memory thrashing.
azure_analysisservices_servers_MemoryLimitHard	MemoryLimitHard	Memory: Memory Limit Hard	Bytes	Average	Hard memory limit, from configuration file.
azure_analysisservices_servers_MemoryLimitHigh	MemoryLimitHigh	Memory: Memory Limit High	Bytes	Average	High memory limit, from configuration file.
azure_analysisservices_servers_MemoryLimitLow	MemoryLimitLow	Memory: Memory Limit Low	Bytes	Average	Low memory limit, from configuration file.
azure_analysisservices_servers_MemoryLimitVertiPaq	MemoryLimitVertiPaq	Memory: Memory Limit VertiPaq	Bytes	Average	In-memory limit, from configuration file.
azure_analysisservices_servers_MemoryUsage	MemoryUsage	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_analysisservices_servers_private_bytes_metric	private_bytes_metric	Private Bytes	Bytes	Average	Private bytes.
azure_analysisservices_servers_ProcessingPoolBusyIOJobThreads	ProcessingPoolBusyIOJobThreads	Threads: Processing pool busy I/O job threads	Count	Average	Number of threads running I/O jobs in the processing thread pool.
azure_analysisservices_servers_ProcessingPoolBusyNonIOThreads	ProcessingPoolBusyNonIOThreads	Threads: Processing pool busy non-I/O threads	Count	Average	Number of threads running non-I/O jobs in the processing thread pool.
azure_analysisservices_servers_ProcessingPoolIdleIOJobThreads	ProcessingPoolIdleIOJobThreads	Threads: Processing pool idle I/O job threads	Count	Average	Number of idle threads for I/O jobs in the processing thread pool.
azure_analysisservices_servers_ProcessingPoolIdleNonIOThreads	ProcessingPoolIdleNonIOThreads	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_analysisservices_servers_ProcessingPoolIOJobQueueLength	ProcessingPoolIOJobQueueLength	Threads: Processing pool I/O job queue length	Count	Average	Number of I/O jobs in the queue of the processing thread pool.
azure_analysisservices_servers_ProcessingPoolJobQueueLength	ProcessingPoolJobQueueLength	Processing Pool Job Queue Length	Count	Average	Number of non-I/O jobs in the queue of the processing thread pool.
azure_analysisservices_servers_qpu_metric	qpu_metric	QPU	Count	Average	QPU. Range 0-100 for S1, 0-200 for S2 and 0-400 for S4
azure_analysisservices_servers_QueryPoolBusyThreads	QueryPoolBusyThreads	Query Pool Busy Threads	Count	Average	Number of busy threads in the query thread pool.
azure_analysisservices_servers_QueryPoolIdleThreads	QueryPoolIdleThreads	Threads: Query pool idle threads	Count	Average	Number of idle threads for I/O jobs in the processing thread pool.
azure_analysisservices_servers_QueryPoolJobQueueLength	QueryPoolJobQueueLength	Threads: Query pool job queue lengt	Count	Average	Number of jobs in the queue of the query thread pool.
azure_analysisservices_servers_Quota	Quota	Memory: Quota	Bytes	Average	Current memory quota, in bytes. Memory quota is also known as a memory grant or memory reservation.
azure_analysisservices_servers_QuotaBlocked	QuotaBlocked	Memory: Quota Blocked	Count	Average	Current number of quota requests that are blocked until other memory quotas are freed.
azure_analysisservices_servers_RowsConvertedPerSec	RowsConvertedPerSec	Processing: Rows converted per sec	CountPerSecond	Average	Rate of rows converted during processing.
azure_analysisservices_servers_RowsReadPerSec	RowsReadPerSec	Processing: Rows read per sec	CountPerSecond	Average	Rate of rows read from all relational databases.
azure_analysisservices_servers_RowsWrittenPerSec	RowsWrittenPerSec	Processing: Rows written per sec	CountPerSecond	Average	Rate of rows written during processing.
azure_analysisservices_servers_ShortParsingBusyThreads	ShortParsingBusyThreads	Threads: Short parsing busy threads	Count	Average	Number of busy threads in the short parsing thread pool.
azure_analysisservices_servers_ShortParsingIdleThreads	ShortParsingIdleThreads	Threads: Short parsing idle threads	Count	Average	Number of idle threads in the short parsing thread pool.
azure_analysisservices_servers_ShortParsingJobQueueLength	ShortParsingJobQueueLength	Threads: Short parsing job queue length	Count	Average	Number of jobs in the queue of the short parsing thread pool.
azure_analysisservices_servers_SuccessfullConnectionsPerSec	SuccessfullConnectionsPerSec	Successful Connections Per Sec	CountPerSecond	Average	Rate of successful connection completions.
azure_analysisservices_servers_TotalConnectionFailures	TotalConnectionFailures	Total Connection Failures	Count	Average	Total failed connection attempts.
azure_analysisservices_servers_TotalConnectionRequests	TotalConnectionRequests	Total Connection Requests	Count	Average	Total connection requests. These are arrivals.
azure_analysisservices_servers_VertiPaqNonpaged	VertiPaqNonpaged	Memory: VertiPaq Nonpaged	Bytes	Average	Bytes of memory locked in the working set for use by the in-memory engine.
azure_analysisservices_servers_VertiPaqPaged	VertiPaqPaged	Memory: VertiPaq Paged	Bytes	Average	Bytes of paged memory in use for in-memory data.
azure_analysisservices_servers_virtual_bytes_metric	virtual_bytes_metric	Virtual Bytes	Bytes	Average	Virtual bytes.