Database Reference
In-Depth Information
Counter
group:
counter
Explanation
Proc Indexes:
total rows
Total number of rows SSAS has read to build indexes since the in-
stance was last restarted.
Proc Aggreg-
ations: Cur-
rent Partitions
Number of partitions for which SSAS is currently building aggrega-
tions.
Proc Aggreg-
ations: Total
Partitions
Total number of partitions for which SSAS has built aggregations
since the instance was last restarted.
Proc Aggreg-
ations: Temp
file rows writ-
ten / sec
If SSAS does not have sufficient space to create the aggregations in
memory, some of the rows will be written to temporary files on the
disk. A nonzero value for this counter indicates that SSAS could use
additional memory.
Proc Aggreg-
ations: Temp
file bytes writ-
ten / sec
Number of temporary file bytes written on disk per second. Much like
the previous counter, a nonzero value indicates memory shortage.
Processor: %
processor
time
CPU utilization on the host. This counter isn't specific to SSAS, but
rather indicates the total CPU usage. If the counter is at or above 80
percent, you may have a CPU bottleneck. Try to isolate SSAS to its
own host if possible.
Search WWH ::
Custom Search