Database Reference
In-Depth Information
Counter
group:
counter
Explanation
Processing:
total rows
written
Total number of rows written to the disk as part of processing since
the instance was last started.
Threads: Pro-
cessing Pool
Job Queue
Length
A nonzero value indicates that some processing threads had to be
queued up; this is because not enough worker threads were made
available for all active processing requests. Keep in mind that pro-
cessing threads are used for processing as well as querying. Check
CPU utilization on the server. If CPU is already busy (>=80 percent),
additional worker threads will not help. If the CPU usage is below 80
percent, you could increase the number of available processing
threads to improve the processing performance.
Proc Indexes:
Current Parti-
tions
Number of partitions for which SSAS is currently building indexes.
Proc Indexes:
Total Parti-
tions
Total number of partitions for which SSAS has built indexes since
the instance was last started.
Proc Indexes:
rows / sec
Number of rows already converted into a multidimensional format,
which SSAS reads to build indexes. If this number is low, your SSAS
could be short on memory resource.
Search WWH ::
Custom Search