SqlServerPerformanceAnalyse

http://rusanu.com/2014/02/24/how-to-analyse-sql-server-performance/

White Papers:
Waits and Queues White-Paper (2005) http://technet.microsoft.com/en-us/library/cc966413.aspx
Waits and Queues after 2005 - http://msdn.microsoft.com/en-us/library/ms179984.aspx

sys.dm_exec_requests	What is executing right now
sys.dm_os_waiting_tasks	Currently waiting tasks
sys.dm_os_wait_stats	Aggregated statistics about all wait types
sys.dm_exec_query_stats	runtime execution statistics for most queries
sys.dm_exec_sql_text	get the text of the query
sys.dm_exec_query_plan	get the query execution plan