question

Hi @DevendraSahu-0306,

Welcome to Microsoft Q&A!
I want to know if your database is Azure SQL.
If so, I suggest you learn about Azure Monitor. Please see the following articles:
Understand how metric alerts work in Azure Monitor
Task: Creating an alert when CPU exceeds an average of 80 percent.
If not, please refer to the following article:
Create a SQL Server WMI Alert for the High CPU
SQL Server monitoring tool for CPU performance
Hope these articles could be helpful for you.

Best regards,
Seeya

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

You do NOT want to do that. It is completely normal and expected behavior for SQL Server to use 100% of the resources available for short periods of time. It is NOT a problem if CPU avg > 80%.

Hi @DevendraSahu-0306 ,

SQL Server Error 22022

It occurs due to the SQL Agent cannot connect to the SQL Server database engine.
Perhaps your sql server agent is started in manual mode. What you need to do is right click -> start it, then right click -> properties -> do the following operation:

WMI errors are more complicated. Can you try the above methods first and then show the errors to me?

Here is a similar thread:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/64a314c7-ce54-4bf3-86ad-ec7c8b140638/sql-server-alert-using-wmi-event?forum=sqldatabaseengine

Best regards,
Seeya

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Hi @DevendraSahu-0306 ,

Please refer to this link which is a similar thread, hope it can be useful for you:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/64a314c7-ce54-4bf3-86ad-ec7c8b140638/sql-server-alert-using-wmi-event?forum=sqldatabaseengine

Best regards,
Seeya