In the latest SQL Solution center articles, we wrote about SQL Server performance problems alerting and operating system monitoring.
In How to be proactively alerted of SQL Server performance problems, we described how to be notified whenever a specific performance metric reaches its critical value. We showed how to accomplish this using SQL Server Alerts in SQL Server Management Studio and ApexSQL Monitor.
In Operating System (OS) performance monitoring, we presented and showed advantages and disadvantages for two native solutions for monitoring operating system performance metrics: Windows Task Manager and Windows Performance Monitor, and for ApexSQL Monitor.
August 1, 2014