Hi all
Is any one using analysis services's system counters?
Would be happy to see examples for scenarios where these counters are
usefull.
I don't understand which ones to use and when..
I am trying to asses whether i have a memory bottle neck while aggregations
are computed.
I have created a log with the 'Analysis services:Proc Aggs\Temp file
bytes/rows written/sec' and the 'msmdsrv process\virtual bytes'.
I want to see if temporary files are used while aggregations are calculated
(meening the process memory buffer isn't large enough)
and if the overall memory consumption of AS acceeds its upper limit.
This log shows that 'msmdsrv process\virtual bytes' are at value '100'
constantly but i don't know exactly what this value meens?
Also the Proc Aggs\Temp file bytes/rows written/sec' value is constantly 0
(i noticed temporary files
were created during aggregations creation but with 0 kb size).

Thnks alot for your attention
Rea

Best discussion of perfmon counters is in the SQL Server 2000 Resource Kit
available at your local bookstore or online at:
http://search.barnesandnoble.com/boo...sbn=0735612668
See Chapter 26 Performance Tunining Analysis Services
(the Resource Kit is also available on the TechNet Resource Kit CD/DVD if
you can find someone in your company with a TechNet subscription -- I don't
believe that it is included in MSDN).

Temp files are always created when processing. The question is only if they
are actually written/read. They are always 0 bytes because they are never
closed until the end when they are deleted. An end-of-file marker is written
to the file but never flushed to the directory. There are two techniques you
can use to monitor them: 1) using perfmon as outlined above; or 2) using the
filemon utility from http://www.sysinternals.com -- this is talked a bit in
the SSAS Operations Guide:
http://www.microsoft.com/technet/pro.../anservog.mspx
and in the SSAS Performance Guide:
http://www.microsoft.com/technet/pro.../ansvcspg.mspx

Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Rea Peleg" <rea_p (AT) afek (DOT) co.il> wrote