We help IT Professionals succeed at work.

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

RIVAGHI
RIVAGHI asked
on
Medium Priority
332 Views
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.
Comment
Watch Question

SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.