Friday, March 9, 2012

Monitoring a SSAS Server

When monitoring a SQL Server, the perfomanceindicators is something like:

Memory — Pages/Sec, Network Interface — Bytes Total/sec, PhysicalDisk — % Disk Time — _Total and so on.

Is there something else specific to monitor when looking at a Analysis Services Server ?

Yes, of course you can add a lot of counters about MDX, memory, locks, proactive caching and so on.

Try to have a look!

|||Ok, but you have a link or whitepaper telling a little more in detail ?|||

I don't remember a specific whitepaper.

You can find something more detailed in "AS2005 Performance Guide" that is available for download here:

http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc

No comments:

Post a Comment