You are developing SQL Server 2008 Analysis Services (SSAS) database sample for Company.com.
In order to write down the Analysis Services performance information, when the database is operated you should gather information connected with the temporary file usage.
Which is the correct answer?
A.
You should utilize MSAS 2008: store procedure
B.
You should utilize MSAS 2008: Transactions Log
C.
You should utilize MSAS 2008: Proc Aggregations
D.
You should utilize MSAS 2008: Memory
Explanation:
http://www.ssas-info.com/analysis-services-articles/58-ssas-2008/1113-analysis-services-2008-performance-counters
MSAS 2008:Proc Aggregations Current partitions Current number of partitions being processed.
MSAS 2008:Proc Aggregations Total partitions Total number of partitions processed (successfully or otherwise).
MSAS 2008:Proc Aggregations Memory size rows Size of current aggregations in memory. This count is an estimate.
MSAS 2008:Proc Aggregations Memory size bytes Size of current aggregations in memory. This count is an estimate.
MSAS 2008:Proc Aggregations Rows merged/sec Rate of rows merged or inserted into an aggregation.
MSAS 2008:Proc Aggregations Rows created/sec Rate of aggregation rows created.
MSAS 2008:Proc Aggregations Temp file rows written/sec Rate of writing rows to a temporary file. Temporary files are written when aggregations exceed memory limits.
MSAS 2008:Proc Aggregations Temp file bytes written/sec Rate of writing bytes to a temporary file. Temporary files are written when aggregations exceed memory limits.http://ms-olap.blogspot.com/2009/04/performance-counters-for-ssas-2008.html
Performance Counters for SSAS 2008
Aggregations
If your cubes rely on aggregations it might be interesting to know if they can be held in memory or if the are written to a temporary file. So you might also want to look at the following aggregation counters:Object Counter Description
MSAS 2008:Proc Aggregations Temp File Bytes Writes/sec Usage of temporary file
MSAS 2008:Proc Aggregations Current partitions Current number of partitions being processed.
MSAS 2008:Proc Aggregations Memory size bytes Size of current aggregations in memory. This count is an estimate.
MSAS 2008:Proc Aggregations Temp file bytes written/sec Rate of writing bytes to a temporary file. Temporary files are written when aggregations exceed memory limits.