Show 13 – SQL Server Monitoring




SQL Server Radio show

Summary: <a href="http://traffic.libsyn.com/madeirasqlserverradio/SQLServerRadio_Show013.mp3" target="_blank">Download Episode (mp3)</a> 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: * <a href="https://www.youtube.com/watch?v=mjAp-A_9YNI&amp;list=PLoGAcXKPcRvanix7u9eqg_qt1tp849rX3" target="_blank">Conor Cunningham - Managing 1 Million+ DBs-How Big Data is used to run SQL Azure</a> * <a href="http://sqlblog.com/blogs/maria_zakourdaev/archive/2013/06/26/alert-visualization-recipe-get-out-your-blender-drop-in-some-sp-send-dbmail-google-charts-api-add-your-favorite-colors-and-sprinkle-with-html-blend-till-it-s-smooth-and-looks-pretty-enough-to-taste.aspx" target="_blank">Maria Zakourdaev - Alert Visualization Recipe</a> Happy 2015, everybody!