No objects listed for "SQL Server performance condition alert"

Question

No objects listed for "SQL Server performance condition alert"

Joy Smith San

SSC-Insane

Points: 24877
More actions
January 25, 2015 at 11:28 pm

#397928

Hi All,
Facing a weird issue. We are trying to create some alerts in our SQL Server 2014 BI edition.
Issue is that, after I chose "Type" as "SQL Server performance condition alert" nothing is listed in the "Object" list box.
SQL Server event alerts are working. Issue is only with "SQL Server performance condition alert".
Screenshot attached. Can someone please guide on this. ? Thanks in advance.
San.
January 26, 2015 at 1:26 am

This was removed by the editor as SPAM
June 30, 2021 at 7:17 am

This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

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

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 1

You might need to verify the SQL Server Performance counters are installed properly on the server itself. You can query sys.dm_os_performance_counters to more or less confirm if they are installed and enabled properly. You can check the remarks of the BOL link to the DMV for the query to use.

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 2

Thanks !.

select * from sys.dm_os_performance_counters

doesn't return anything. No records. How to go about it now ?

Note :- As soon we installed SQL Server, wintel had upgraded OS from Windows 2008 to Windows 2008 R2 on this machine.

Thanks again.

K Shaw Newbie Points: 1 More actions · Answer 3

If you have the SQL Installation disk available, go to Maintenance > Repair. This worked for me, it restored the missing performance counters. Also the recommended PFE blog post contains a lot of helpful information - but it seems the PFE blog post is now missing the original screen shots since a few years have passed.