Sql server became unresponsive or crashed due to high CPU utilization (almost 100% ) Once the server is down, the counters are usually gone. Of course, we could set up Performance Counters to export their data overtime, but that means you are going to have to wait for another crash to be able to troubleshoot. so do we create alert or generate reports for instant for high CPU usage ? Thanks jjjosef
Welcome to the forums!. http://sqlknowledge.com/2010/12/how-to-monitor-sql-server-cpu-usage-and-get-auto-alerts/