Optimizing Dimension and Cube Processing - SQL Server Analysis Services 2012 Cube Development - page 193

Counter
group:
counter Explanation

Physical
Disk: Current
Disk Queue
Length

A nonzero value of this counter indicates that you could have a disk
bottleneck; some disk requests cannot be served right away and
have to wait in a queue. If you have a single local disk on your serv-
er, the logical and physical disk are the same. Many production im-
plementations use high performance Storage Area Network ( SAN )
or Solid State Disk ( SSD ) data volumes. You could be using SAN
with RAID features, when a single volume consists of multiple
striped or mirrored disks. In this case, it might be beneficial to monit-
or each physical disk to determine which one is busy causing SSAS
requests to queue up.

AND / OR Lo-
gical Disk:
Current Disk
Queue
Length

Memory:
Memory
Usage KB

The total amount of memory in KB used by SSAS instance. You will
learn more about SSAS memory management in Chapter 8 , Admin-
istering and Monitoring Analysis Services . On older operating sys-
tems it might be beneficial to reserve some memory at SSAS in-
stance start-up.

How to do it...

To collect PerfMon counters, perform the following steps:

1. Launch PerfMon prior to kicking off the processing jobs, expand the Data
Collector Sets folder, and choose User Defined .
2. In the right-hand pane, navigate to New | Data Collector Set .
3. Name the collector set SSAS Processing , and choose the Create Manu-
ally (Advanced) option.
4. On the next screen, choose Create Data Logs and check the Performance
Counter checkbox.