Statistics

Question 1

How do you get execute queries stats in T-SQL?

Answer 1

SELECT * FROM sys.dm_exec_query_stats

Question 2

How do you get execute queries TSQL text?

Answer 2

SELECT * FROM sys.dm_exec_sql_text (sql_handle)

Question 3

How do you get executed queries query plans?

Answer 3

SELECT * FROM sys.dm_exec_query_plan (plan_handle)