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