SQL SERVER DBA, Linux and Azure: WAITING TYPES

WAITING TYPES

 > 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.

No comments:

Post a Comment