> When if any query waiting for resources then relevant wait type comes into picture. Which cause high performance impact.
How to find wait type:
Select * from sys.sysprocesses
Column “last wait type”
Types of wait types:
1. LCK_M_S: Occurs when a task is waiting to acquire a shared lock. [Occurs mostly in blockings]
2. ASYNC_IO_COMPLETION: Occurs when a task is waiting for I/Os to finish.
3. ASYNC_NETWORK_IO: Occurs on network writes when the task is blocked behind the network. Verify that the client is processing data from the server.