Finding out what statements causing grief on SQL Server has become significantly easier with SQL Server 2005+. I am using some of the DMV/DMF to
Category: Dynamic Management Views/Functions
Listing blocking chain by tasks
References: #20
Getting file usage stats
You can use this DMV to see what SQL Server thinks about the I/O stall times. I don’t rely on it 100% but it helpful
Execution Related Dynamic Management Views and Functions Differences
sys.dm_exec_query_stats SQL 2008: Added two new fields the the DMV (query_hash and query_plan_hash); designed to help performance tune queries with similar logic, you can read
DMV/DMF
I have used many different queries of DMV/DMF over the past years to get various information for SQL Server OS. So I am going to
SQL Canada (SQLCAN) 