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…