Query Plan read using T-SQL
If plan from a saved file
If plan from a saved file
Get CPU Utilization History for the last 256 minutes dm_os_ring_buffers
Scalar UDF Inlining, sql_modules
dm_os_memory_clerks
Possible System Memory State values:* Available physical memory is high* Physical memory usage is steady* Available physical memory is low* Available physical memory is running low* Physical memory state is transitioning sys.dm_os_sys_memory
dm_io_virtual_file_stats
Helps determine which database is using the most CPU resources on the instance Depends on the currently caught query plan dm_exec_query_stats dm_exec_plan_attributes
Get input buffer information from all non-system sessions for the current database Related dm_exec_input_buffer,New DMF for retrieving input buffer