Sql-server – SQL 2008 Server agent cant see perfmon counters

perfmonsql-server-2008

I am trying to create a new SQL server agent alert to capture "SQLServer:General Statistics|Processes Blocked||>|5' but it looks like alert creation GUI is not able to see any perfmon counters as in the following picture:
enter image description here

The drop downs for Object, counter and instance are empty.
I can't even create the alert using TSQL as follows:
enter image description here
I can see these counters collecting data in perfmon.

Any ideas?
Thanks in advance…

Best Answer

You'll have to work through this "SQL Server – Missing Performance Counters: A consolidated list of known issues" sorry.

I'm surprised this still happens: I last saw this with SQL Server 7/2000 years ago.