Hi guys,

Just a quick query regarding performance counters for Analysis Services
2005. I can't seem to find an article with decent descriptions of the
AS2005 counters (other than the single sentence explanations within
Perfmon).

I am especially interested in the time it takes for the last request,
rather than an average. I found a SQL Server 2000 Analysis Services
Performance Tuning document, which described a Last Query performance
object with a "total elapsed time for a query request" counter. But I
can only seem to find an average request time with 2005.

Any suggestions or AS2005 reference material that you may know of that
may help?

Cheers,
Jonathon

jonathonm (AT) intergen (DOT) co.nz wrote:

You can use Profiler to find out query response time , store it in
table and query it .

Regards
Amish Shah
http://shahamishm.tripod.com

Hey,

Thanks for the idea, didn't think of that ...

Cheers,
Jonathon