Wednesday, March 21, 2012

Query Performance

How to monitor the Query performance for the AS2005? I am use the Performance Monitor to monitor it, but there have too much counters for the AS2005, such as MSAS 2005 MDX, MSAS 2005 Thread, MSAS Store Engine Query.... Which counters are the best to use for monitor the query performance.

For getting some ideas on how to increase query performace you should definitely take a look at the recently released Performance Guide.

You have several ways to investigate query and overall server performance:

1. Run SQL Server profiler and capture all MDX-related and progress report events that happen during query execution. For that you should only have a single query running on your server so that other queries wouldnt influence the results.

2. Use perfmon counters as you have been doing alreday. It requires a little bit of understanding of Analysis Services architecture. I suggest you start from performance guide.

3 If you cannot just monitor a single query and would like to get an idea on what is going on on the live server, use Activity Viewer sample application. That shows you current state of server, you can see all the sessions/connections opened and what queries are currently executing.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment