Database Reference
In-Depth Information
Counter
group:
counter
Explanation
OLEDB / .NET provider efficiency. Generally OLEDB providers are
more efficient than .NET providers.
When processing many partitions in parallel, it's not uncommon to
see SSAS read hundreds of thousands of rows per second on highly
tuned systems. If this counter is in hundreds or low thousands, you
should check your relational database for tuning opportunities.
Processing:
total rows /
read
Total number of rows read since the SSAS instance was started.
This counter isn't particularly useful for monitoring current perform-
ance, but rather for gauging the level of processing activity since the
last restart.
Processing:
rows conver-
ted / second
Number of rows converted from relational source into a multidimen-
sional format.
Processing:
total rows
converted
Total number of rows converted from relational source into a multidi-
mensional format.
Processing:
rows written /
sec
Number of rows written to the disk in a multidimensional format.
Again, it is unfair to stipulate the number that constitutes excellent
performance, but if this number is much lower than number of rows
read per second you need to check the logical / physical disk coun-
ters.
Search WWH ::
Custom Search