Live Event Notes
Thanks for attending our virtual training event on SQL Server Dynamic Management Views (DMVs). Here’s the notes, slides, and links from each session.
Order a free copy of the event on CD to be shipped to you. Restrictions apply. Order CD
Troubleshooting for Beginners with Kevin Kline
- View the slides vConference – Troubleshooting for Beginners
- Quest webcast archive on blocking & locking
- Jimmy May’s blog on partition alignment
Troubleshooting with DMVs with Kevin Kline
- View the slides vConference – Troubleshooting for Intermediates (2)
- Perfmon tutorial at BrentOzar.com
- Quest Backstage promotions – for posters
- Virtualization Virtual Chapter of PASS with webcasts and archives
- Webcast archive on consolidation vs virtualization with Brent Ozar and Kevin Kline
Troubleshooting for Experts with Kevin Kline
- View the slides vConference – Troubleshooting for Experts (2)
- Toad for SQL Server (free and beta versions available)
- Webcast on Toad and SQL Server Management Studio Tools Pack
- SSMS Tools Pack
- Glenn Berry’s blog with DMV queries
- SQLCAT – Customer Advisory Team
- Wait Statistics best practices at Microsoft
Ari Weil Explains Foglight Performance Analysis & Spotlight
- More Information on Foglight Performance Analysis – including a free 30-day trial download
- More Information on Spotlight for SQL Server Enterprise – including a free 30-day trial download
- QuestKB tutorial videos & articles about Foglight Performance Analysis, Spotlight on SQL Server Enterprise, and Foglight for SQL Server
Performance Tuning for Beginners:
Reading SQL Server’s Signs with Brent Ozar
- Download the Slides
- SP_WHO replacement – DMV query to show current activity with wait statistics
- Wait Types list at SQLServerPedia
- SP_WhoIsActive by Adam Machanic – slick replacement for sp_who2 that includes filtering and much more.
- DMV query to show procedure cache
- Book Review – SQL Server 2008 Query Performance Tuning Distilled – helps explain execution plans. Highly recommended by Brent Ozar.
- Execution Plans – article at SQLServerPedia edited by Grant Fritchey, author of the above book.
- SSMS Performance Dashboard Reports – free download for SQL Server Management Studio 2005.
- Professional SQL Server 2008 Internals and Troubleshooting – Brent’s book, which includes a chapter on the Performance Dashboard Reports.
Performance Tuning for Mid-Level DBAs:
Adding and Removing Indexes with Brent Ozar
- Download the Slides
- DMV query to find unused indexes – indexes that are just slowing us down every time we do an insert/update/delete
- DMV query to find missing indexes – indexes we could add to get more performance
- Index maintenance script at SQLServerPedia – defragment or rebuild your indexes for a free performance gain
- Michelle Ufford’s articles on index maintenance
Dr. Ozar MDF, Database Shrink
Performance Tuning for Experts:
Playing Doctor with Brent Ozar
- Download the Slides
- DMV query to check file activity – which files are most heavily accessed
- DMV query to find heaps – tables without a clustered index
- Central Management Server – article at SQLServerPedia with a video tutorial on how to set it up.
Ari Weil Demos Foglight Performance Analysis & Spotlight
- More Information on Foglight Performance Analysis – including a free 30-day trial download
- More Information on Spotlight for SQL Server Enterprise – including a free 30-day trial download
- QuestKB tutorial videos & articles about Foglight Performance Analysis, Spotlight on SQL Server Enterprise, and Foglight for SQL Server
Want to know when new ones are announced? Subscribe to our free SQL Server training RSS feed.
