This question is related to monitoring of SQL Server.
I want to send an email alert with all open transactions on SQL Server in HTML report whenever there is sustained 50-60% CPU usage for more than 3 minutes. How to achieve this using TSQL or stored procedure so that I can schedule as a job and keep polling on regular basis.
Similar as above, I wanted to get notified whenever there is sustained 70-80% memory usage on the server for more than 3 minutes. The reason for this, even though I have set the max server memory setting for sql server, there could some component eating up memory which can cause external memory pressure. In such situations, DBA team should get an email alert notification even before users calls in and open a ticket.
I have anyone can provide sample code that will be great help. Based on that I can extend the functionality of monitoring like collecting trace etc...