[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

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

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.
1 Solution
Raja Jegan RSQL Server DBA & ArchitectCommented:
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.

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now