Analysis Services 2005 Perfmon Counters

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

.

Relevant Pages

  • Re: Analysis Services 2005 Perfmon Counters
    ... Just a quick query regarding performance counters for Analysis Services ... I am especially interested in the time it takes for the last request, ...
    (microsoft.public.sqlserver.olap)
  • Re: killing queries
    ... Look in the Analysis Services Operations Guide: ... To kill a query, all you need to do is to disconnect the underlying TCP/IP ...
    (microsoft.public.sqlserver.olap)
  • Re: SQL server performance degrades
    ... bad statistics information result in bad query plan. ... So while doing the cube processing Analysis services has used ... >> If you use the schema one partition - one fact table, ... I would recommend you using of SQL ...
    (microsoft.public.sqlserver.olap)
  • Adding RAM above 3 GB with 64bit platform to improve performance
    ... RAM accessible to Analysis Services beyond the 3GB limit with respect to ... server cache and deliver better query response? ...
    (microsoft.public.sqlserver.olap)
  • Re: Data Usage Auditing
    ... The query log is NOT what you are looking for. ... SQL BI Product Unit (Analysis Services) ... > tracking of the queries ran against the data warehouse. ... > I guess the easy thing is to generate reports from the Access database ...
    (microsoft.public.sqlserver.olap)