BufferPin
Waiting to acquire a pin on a buffer
The server process is waiting for an exclusive lock on a shared memory buffer.
This wait can be seen when another process is using the buffer in an open cursor.
Look for:
- Long running transactions
- Orphaned sessions
- Analyze sessions