The below script rebuild all the indexes that are fragmented higher than 30%. Reorg indexes that are fragmented between 10%-30% -- Ensure...

--Buffer Pool Extension Alter server configuration set buffer pool extension on (filename ='D:\extrabuffer.bpe', size = 32GB) GO

SELECT TOP (50) sp.database_id, dbname= DB_NAME (qt.dbid), so.name AS StoredProcName, sp.total_worker_time, sp.execution_count AS...

SELECT TOP (10) sp.database_id, so.name AS StoredProcName, sp.total_worker_time, sp.execution_count, sp.total_logical_reads,...

SELECT TOP (5) a.database_id, so.object_id, so.name AS TableName, a.page_latch_wait_count , a.page_latch_wait_in_ms,...

SELECT TOP (5) b.name AS TableName, a.database_id, a.singleton_lookup_count, a.range_scan_count FROM sys.dm_db_index_operational_stats(...

SELECT [ReadLatency] = CASE WHEN [num_of_reads] = 0 THEN 0 ELSE ([io_stall_read_ms] / [num_of_reads]) END, [WriteLatency] = CASE WHEN...

--Page Split/Sec using DMV SELECT ms_ticks FROM sys.dm_os_sys_info; Select * from sys.dm_os_performance_counters where object_name =...

---Find who uses the most query memory grant: SELECT mg.granted_memory_kb, mg.session_id, t.text, qp.query_plan FROM...

-- Calculates average stalls per read, per write, and per total input/output for each database file. SELECT DB_NAME(fs.database_id) AS...

SELECT @@servername AS INSTANCE ,[object_name] ,[counter_name] , UPTIME_MIN = CASE WHEN[counter_name]= 'Page life expectancy' THEN...