SQLBenchmarkPro - FAQs

SQL Server performance counters are unavailable.

To verify that the SQL Server performance counters are missing or unavailable run the following TSQL statement with a login which has sysadmin rights.

select * from master.dbo.sysperfinfo

This command would normally return the list of SQL performance counter.

http://www.travisgan.com/2013/05/missing-sql-performance-counters.html

http://blogs.msdn.com/b/varund/archive/2010/06/25/sql-server-missing-performance-counters-a-consolidated-list-of-known-issues.aspx