deepvhr's blog

Useful Dynamic Management Views in SQL Server 2008

Here is a list of some DMVs that are important in troubleshooting server performance and can be useful in identifying poorly performing queries:


sys.dm_exec_requests and sys.dm_exec_sessions
These DMVs can be used to view active sessions and requests running on a server, to identify long running sessions.

How to find information about blocked requests: