How To Monitor Deadlocks in SQL Server

Written by Mohit Gupta, Microsoft Premier Field Engineer. Every now and then we have deadlocks taking place in SQL Server.  Most go unnoticed, either because the frontend application handles it gracefully.  Or no error is not reported out to the user. What is a Deadlock? Deadlocks happen when conflicting locks are taken by two or…


A Microsoft SQL Server DMV/DMF Cheat-Sheet (Part 2)

Written by Mohit Gupta, Microsoft Premier Field Engineer. In my last post I talked about how to get the list connections (e.g. who is connected and requests are they running on SQL Server).  I talked about how to use dm_exec_connections, dm_exec_sessions and dm_exec_requests, we saw how powerful these DMVs where.  Now to expand on where…


A Microsoft SQL Server DMV/DMF Cheat-Sheet

  Written by Mohit Gupta, Microsoft Premier Field Engineer. I am asked this question by Microsoft SQL Server customers again and again: “What dynamic management views (DMV) or dynamic management functions (DMF) should I use?” The short answer is, as many as you need. The detailed answer is, well, it depends. There are well over…


Adventures in Installing the SQL Server AdventureWorks Sample Database

Written by Mohit Gupta, Microsoft Premier Field Engineer. I was thinking of writing an article about Microsoft SQL Server T-SQL Basics; however, in order to do the examples and demos I wanted to use a database that’s readily available on the Internet, so I decided to use the common AdventureWorks sample database available on Codeplex, …