SQL Server Wait Types

--Find the waittypes

select * from sys.dm_os_wait_stats order by wait_time_ms desc

--Clear the counter

DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR);

--Find CXPACKET Wait type.

select * from sysprocesses where lastwaittype ='CXPACKET'

Recent Posts

SELECT SUM (qrs.count_executions) * AVG (qrs.avg_logical_io_reads) as est_logical_reads, SUM (qrs.count_executions) AS...

--Query to find missing index from query store, from last 30days usage SELECT TOP 20 qsq.query_id, SUM(qrs.count_executions) *...

--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...