Show 13 – SQL Server Monitoring

Download Episode (mp3)
On this show, we talk about monitoring in SQL Server. But actually, monitoring is not only monitoring: It's also baselining, data collection, data analysis, reporting and alerting, and we cover all of those in the show. Among other topics, we talk about:

The different levels of monitoring
Why it's important to have a baseline
Trend analysis
What should you monitor in SQL Server
The set of tools for monitoring, baselining, data collection, reporting and alerting
What should you do when you get an alert about a certain problem
And more..

Items mentioned in the show:

Conor Cunningham - Managing 1 Million+ DBs-How Big Data is used to run SQL Azure
Maria Zakourdaev - Alert Visualization Recipe

Happy 2015, everybody!