question

DevendraSahu-0306 avatar image
0 Votes"
DevendraSahu-0306 asked DevendraSahu-0306 commented

how to create an alert when a CPU exceeds an average of 80 percentage in SQL server

how to create an alert when a CPU exceeds an average of 80 percentage in SQL server.
we configured Mail

sql-server-general
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DevendraSahu-0306 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

0 Votes 0 ·

Hello @SeeyaXi-msft

Give me 1-2 Day i reply you
sorry to delay reply
and i have no database is Azure SQL.

0 Votes 0 ·

i try to multiple time but every time showing this error

140901-image.png


0 Votes 0 ·
image.png (116.5 KiB)

Hi @DevendraSahu-0306,

Is there any process related information? If you find my reply useful, please accept the answer, if it is not useful, please feel free to let me know.
And have a nice day!

Best regards,
Seeya

0 Votes 0 ·
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
1 Vote"
TomPhillips-1744 answered

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%.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered DevendraSahu-0306 edited

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:
141199-1.png

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.


1.png (46.3 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

it already Automatic All Services

142417-image.png




0 Votes 0 ·
image.png (59.5 KiB)
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered DevendraSahu-0306 commented
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Okay i try and update you

0 Votes 0 ·

Hi DevendraSahu-0306,

Good luck for you!

Best regards,
Seeya

0 Votes 0 ·

Hello
may be i some mistakes to Configuration that's reason i am unable to properly configure

0 Votes 0 ·