Documentation is now available for the Fall 2020 Update release!

Azure Analysis Services

Leave Feedback

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.

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 TypeDescription
azure.qpu.metricQPUCountAverageQPU. Range 0-100 for S1, 0-200 for S2 and 0-400 for S
azure.memory.metricMemoryBytesAverageMemory. Range 0-25 GB for S1, 0-50 GB for S2 and 0-100 GB for S4
azure.total.connection.requestsTotal Connection RequestsCountAverageTotal connection requests. These are arrivals.
azure.successfull.connections.per.secSuccessful Connections Per SecCountPerSecondAverageNumber of workflow runs failed.
azure.total.connection.failuresTotal Connection FailuresCountAverageNumber of workflow runs canceled.
azure.current.user.sessionsCurrent User SessionsCountAverageCurrent number of user sessions established.
azure.query.pool.busy.threadsQuery Pool Busy ThreadsSecondsAverageNumber of busy threads in the query thread pool.
azure.command.pool.job.queue.lengthCommand Pool Job Queue LengthCountAverageNumber of workflow action or trigger throttled events.
azure.processing.pool.job.queue.lengthProcessing Pool Job Queue LengthCountAverageNumber of non-I\O jobs in the queue of the processing thread pool.
azure.current.connectionsConnection: Current connectionsCountAverageCurrent number of client connections established.
azure.cleaner.current.priceMemory: Cleaner Current PriceCountAverageCurrent price of memory, $/byte/time, normalized to 1000.
azure.cleaner.memory.shrinkableMemory: Cleaner Memory shrinkableBytesAverageAmount of memory, in bytes, subject to purging by the background
azure.cleaner.memory.nonshrinkableMemory: Cleaner Memory nonshrinkableBytesAverageAmount of memory, in bytes, not subject to purging by the background cleaner.
azure.memory.usageMemory: Memory UsageBytesAverageMemory 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.hardMemory: Memory Limit HardBytesAverageHard memory limit, from configuration file.
azure.memory.limit.highMemory: Memory Limit HighBytesAverageHigh memory limit, from configuration file.
azure.memory.limit.lowMemory: Memory Limit LowBytesAverageLow memory limit, from configuration file.
azure.memory.limit.verti.paqMemory: Memory Limit VertiPaqBytesAverageIn-memory limit, from configuration file.
azure.quotaMemory: QuotaBytesAverageCurrent memory quota, in bytes. Memory quota is also known as a memory grant or memory reservation.
azure.quota.blockedMemory: Quota BlockedCountAverageCurrent number of quota requests that are blocked until other memory quotas are freed.
azure.verti.paq.nonpagedMemory: VertiPaq NonpagedBytesAverageBytes of memory locked in the working set for use by the in-memory engine.
azure.verti.paq.pagedMemory: VertiPaq PagedBytesAverageBytes of paged memory in use for in-memory data.
azure.rows.read.per.secProcessing: Rows read per secCountPerSecondAverageRate of rows read from all relational databases.
azure.rows.converted.per.secProcessing: Rows converted per secCountPerSecondAverageRate of rows converted during processing.
azure.rows.written.per.secProcessing: Rows written per secCountPerSecondAverageRate of rows written during processing.
azure.command.pool.busy.threadsThreads: Command pool busy threadsCountAverageNumber of busy threads in the command thread pool.
azure.command.pool.idle.threadsThreads: Command pool idle threadsCountAverageNumber of idle threads in the command thread pool.
azure.long.parsing.busy.threadsThreads: Long parsing busy threadsCountAverageNumber of busy threads in the long parsing thread pool.
azure.long.parsing.idle.threadsThreads: Long parsing idle threadsCountAverageNumber of idle threads in the long parsing thread pool.
azure.long.parsing.job.queue.lengthThreads: Long parsing job queue lengthCountAverageNumber of jobs in the queue of the long parsing thread pool.
azure.long.parsing.job.queue.lengthThreads: Processing pool busy I/O job threadsCountAverageNumber of jobs in the queue of the long parsing thread pool.
azure.processing.pool.busy.io.job.threadsThreads: Processing pool busy I/O job threadsCountAverageNumber of threads running I/O jobs in the processing thread pool.
azure.processing.pool.busy.non.io.job.threadsThreads: Processing pool busy non-I/O threadsCountAverageNumber of threads running non-I/O jobs in the processing thread pool.
azure.processing.pool.io.job.queue.lengthThreads: Processing pool I/O job queue lengthCountAverageNumber of I/O jobs in the queue of the processing thread pool.
azure.processing.pool.idle.io.job.threadsThreads: Processing pool idle I/O job threadsCountAverageNumber of idle threads for I/O jobs in the processing thread pool.
azure.processing.pool.idle.non.io.threadsThreads: Processing pool idle non-I/O threadsCountAverageNumber of idle threads in the processing thread pool dedicated to non-I/O jobs.
azure.query.pool.idle.threadsThreads: Query pool idle threadsCountAverageNumber of idle threads for I/O jobs in the processing thread pool.
azure.query.pool.job.queue.lengthThreads: Query pool job queue lengthCountAverageNumber of jobs in the queue of the query thread pool.
azure.short.parsing.busy.threadsThreads: Short parsing busy threadsCountAverageNumber of busy threads in the short parsing thread pool.
azure.short.parsing.idle.threadsThreads: Short parsing idle threadsCountAverageNumber of idle threads in the short parsing thread pool.
azure.short.parsing.job.queue.lengthThreads: Short parsing job queue lengthCountAverageNumber of jobs in the queue of the short parsing thread pool.
azure.mashup.engine.qpu.metricM Engine QPUCountAverageQPU usage by mashup engine processes.
azure.mashup.engine.memory.metricM Engine MemoryCountAverageMemory usage by mashup engine processes.
azure.memory.thrashing.metricMemory ThrashingPercentAverageAverage memory thrashing.
azure.private.bytes.metricPrivate BytesBytesAverageTotal amount of memory the Analysis Services engine process and Mashup container processes have allocated, not including memory shared with other processes.
azure.virtual.bytes.metricVirtual BytesBytesAverageCurrent size of the virtual address space that Analysis Services engine process and Mashup container processes are using.
cloud.instance.stateStatus/Staten/an/aAnalysis Service state metric.

Event support

  • Supported
  • Configurable in OpsRamp Azure Integration Discovery Profile.

External reference