How to create a SQL Server perfomance condition alert for all databases and call a job?

Posted on 2009-02-12
Last Modified: 2012-05-06
When I create a SQL Server  perfomance condition alert, the wizard asks for a database to apply. But I want create an alert not for one, but for all databases wich logs sizes excceeds 80% of  it´s maximum size. The SQL Server event alert wizard has the option to choose all databases, but the SQL Server  perfomance condition alert wizard doesn´t have. After, I´d like that this alert calls a job that receives the name of the database and execute it´s full log backup.
Question by:RIVAGHI
    1 Comment
    LVL 57

    Accepted Solution

    Ideally, Each and every databases varies in nature and hence their performance counters have to be calculated Database wise only and not at the Server level.

    Server level configurations can be identified using the SQL Server Event alerts
    And database level alerts can be identified using SQL Server Performance Condition alerts.

    Hence the answer is you cant create a single SQL Server Performance condition alert for all databases. You have to create individual alerts for each and every database in your server.

    And for the next question, yes you can for each and every alert, you can configure some job to be done for that particular alert. To accomplish that, Create a job in SQL Server agent and then assign it over here.

    Hope I have answered your question.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now