PREEMPTIVE_OS_PIPEOPS

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

  1. Look for any TSQL or Agent jobs that call xp_cmdshell. Examine the contents and optimize
  2. Check the SQL Server error log for more information
  3. 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

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index