Kristin Ferrier's Microsoft BI Beginner's Blog. Denis Gobo : A year in review, The 31 best blog posts on SQLBlog for 2008. SQL in the Wild. SP_Who Replacements. Need to know what’s happening on your SQL Server? SP_Who and SP_Who2 work, but there are even better ways – and they’re free. SQL Server 2005 and newer have Dynamic Management Views (DMVs) that help us see what’s going on inside the database engine. In this one-hour webcast, I teach you how to read the signs with DMVs, sp_WhoIsActive, and more.
Here’s the links referenced in the presentation: SP_WhoIsActive by Adam Machanic – slick replacement for sp_who2 that includes filtering and much more.Book Review – SQL Server 2008 Query Performance Tuning Distilled – helps explain execution plans. And check out our other free SQL Server training videos. sp_Blitz®: Free SQL Server Health Check – You’ve inherited a SQL Server from somebody, and you have no idea why it’s slow. sp_Blitz® gives you a prioritized list of health and performance issues, plus gives you URLs for more details about each issue. SQL Critical Care® - Don’t have time to learn the hard way? Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, & Productivity.
Data Otaku.