BI performance counters This collection of content will describe BI performance monitor counters (OS, SSAS, SSIS, SSRS) that can be encountered more or less commonly, which includes the description, steps that should be taken and additional resources that could be used for more serious troubleshooting Operating System (OS) % A C D P % % free space % processor time A Available MBytes Avg. disk bytes/read Avg. disk bytes/write Avg. disk queue length Avg. disk sec/read Avg. disk sec/write C Current disk queue length D Disk read bytes/sec Disk write bytes/sec P Page file % usage Page/sec Pages input/sec Processor queue length SQL Server Analysis Services (SSAS) A C D L M N P Q S T A AggCacheKB C Cleaner memory KB Concurrent DM queries Current connections Current entries Current KB Current latch waits Current lock waits Current locks Current models processing Current number of cached evaluation nodes Current user sessions D Dimension property files L Long parsing job queue length M Memory limit hard KB Memory size bytes Memory size rows Memory usage KB N Notifications/sec P Processing pool IO job queue length Processing pool job rate Q Query pool job queue length Query pool job rate Quota KB S Short parsing job queue T Total bytes sent Total calculation cache registered Total cells calculated Total deadlocks detected Total dimension queries Total direct hits Total evictions Total EXISTING Total failures Total inserts Total lookups Total measure group queries Total misses Total network round trips Total NON EMPTY for calculated members Total NON EMPTY Total partitions – indexes Total partitions Total predictions Total queries answered Total queries from cache direct Total queries from file Total queries Total requests Total rows – indexes Total rows converted Total rows read Total rows sent Total rows written Total rows Total successes SQL Server Integration Services (SSIS) B F P R S W B BLOB bytes read BLOB bytes written BLOB files in use Buffer memory Buffers in use Buffers spooled F Flat buffer memory Flat buffers in use P Private buffer memory Private buffers in use Private bytes R Rows read Rows written S SSIS package instances W Working set SQL Server Reporting Services (SSRS) A B L M R T A Active connections Active sessions – Web service Active sessions – Windows service B Bytes received total Bytes sent total L Logon successes total M Memory pressure state R Report requests – Web service Report requests – Windows service Requests executing Requests total T Tasks queued Total cache hits- Web service Total cache hits – Windows service Total cache misses – Web service Total cache misses – Windows service Total deliveries Total events Total memory cache hits – Web service Total memory cache hits – Windows service Total processing failures – Web service Total processing failures – Windows service Total reports executed – Web service Total reports executed – Windows service Total requests – Web service Total requests – Windows service Back to top
