Server 2012 R2: Sql

-- Top 10 missing indexes SELECT TOP 10 * FROM sys.dm_db_missing_index_details;

SELECT wait_type, wait_time_ms, signal_wait_time_ms FROM sys.dm_os_wait_stats WHERE wait_type NOT LIKE '%SLEEP%' ORDER BY wait_time_ms DESC; sql server 2012 r2

Extended support ended July 11, 2017. No security updates. Do not use in production unless isolated/legacy. -- Top 10 missing indexes SELECT TOP 10 * FROM sys

This guide gives you everything needed to operate SQL Server 2012 in a legacy environment while preparing to leave it. Extended support ended July 11

-- Most expensive queries by total worker time SELECT TOP 10 query_hash, SUM(total_worker_time) AS total_cpu FROM sys.dm_exec_query_stats GROUP BY query_hash ORDER BY total_cpu DESC;