May 2, 2020

Wait types in SQL Server...



We can get wait type in from sys.dm_os_wait_stats;


Common wait types are...

--CXPACKET
--SOS_SCHEDULER_YIELD
--Async_Network_IO
--OLEDB
--PageIOLatch_Ex
--WriteLog

No comments:

Post a Comment

If you have any doubt or question, please contact us.