No objects listed for "SQL Server performance condition alert"

  • 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.

  • 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

  • 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.

  • This was removed by the editor as SPAM

  • 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.

  • This was removed by the editor as SPAM

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

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