Description
This wait accumulates while SQL Server is performing operating system pipe operations. This wait type is not documented by Microsoft so not much is known about it. This wait is commonly seen when executing xp_cmdshell. Pre-emptive waits are different from regular (emptive) waits as their execution is controlled by an external processes such as the operating system. This wait is common and moderate values do not appear to cause any issues. If values are excessive see the suggested solutions below
Resolved by
DBAs
Suggested solutions
- Look for any TSQL or Agent jobs that call xp_cmdshell. Examine the contents and optimize
- Check the SQL Server error log for more information
- Check the Windows Event Viewer for any suspicious events
Additional research
Killing Sessions with External Wait Types
Hung connection wait type PREEMPTIVE_OS_PIPEOPS
PREEMPTIVE and Non-PREEMPTIVE