Urgent help needed

  • Hi,

    I got this problem

    I wanted to create alerts for percent log used > 80 on one of my databases. on this server I have 13 databases all in full recovery mode. when I select "sqlserver performance condition", "sqlserver databases" and "percent log used" options in EM, the Instances drop down box shows only one database (let us say it is abcd).

    I checked in BOL and found a note under the topic "SP_ADDALERT" which states that

    " the performance counters should have a reference to the databases in the SYSPERFINFO table and the maximum number of databases than can be referenced is 99".

    when I checked the sysperfinfo table, it has all the 99 rows referencing to the same database ("abcd").

    I need to create alerts for all databases. I could not get much information on MS.

    somebody please help

  • This was removed by the editor as SPAM

  • Well logically, after looking at my sysperfinfo table, I'd say that your sysperfinfo table is ok. You might not have enough permissions to insert new counters, alerts, etc.

    My master.dbo.sysperfinfo table contains over 900 rows.

    You could always run the Installation of SQL Server and using the option below

    deinstall the performance counters and then install them again.

    Regards

     


    __________________________________
    Searching the KB articles is like
    picking your nose. You never know
    what you'll find.

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

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