Problems collecting SSAS 2005 perfmon counters

  • I am trying to collect a bunch of perfmon counters on my Analysis Services box.

    The perfmon counters include both SSAS-instance specific counters and other counters targetting a database-engine instance on the same box. However, only the non-SSAS counters appear in my output log file, and the SSAS counters are ignored.

    Anyone seen this before?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • I found the problem. The startup account for the Performance Logs and Alerts service has to be Local System. After doing that, the problem is gone!

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply