sys.dm_os_ring_buffers vs wmi query for cpu...

get connection with connection_id...

How to get index name from sys.dm_tran_locks...

SQL Server DMV - sys.dm_db_missing_index_group_stats - What do these columns mean?...

Join multiple Dynamic Management View tables...

can you use dynamic management views to find out how many times a query is called in a time period...

Retrieving the Name of Running Stored Procedures Across Multiple Databases...

SQL Server - sys.dm_exec_requests Issue...

DMV in SQL 2008 to replace dm_os_exec_requests...