Using Dynamic Management Views (DMVs) to Monitor Blocking and Transactions - Video Series Video Category: Monitoring and Performance Tuning SQL Server Skill Level: 400 (Intermediate - Advanced) Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008 Want to know a few cool scripts you can use to quicky isolate locking, blocking, and deadlocking trouble? Here you go!

Videos in this Series:

Title Skill Length Download Part1 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions   400 9 mins. Download Part2 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions   400 13 mins. Download Part3 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions   400 11 mins. Download Part4 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions   400 6 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

What query would return the first day of this month? SELECT DATENAME(dw, DATEADD(dd, - DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay Tips and Tricks: Create your own customized MMCs (Microsoft Management Console) for easier administration. Go to the command-line and run the command "MMC" to launch the MMC window. All that's left is for you to add in the various snap-ins you want to work with and then save the file NTFS file and folder compression is not compatible with EFS - Encrypting File System. You can either compress or encrypt but not both