Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AustraliaDBA
Starting Member
38 Posts |
 Posted - 2011-07-13 : 01:27:32
|
| Hi All,i need urgent help..... vendor start their extrct job and in activity monitor there is a sql job which has wait type preemptive_os_pipeops... it is in millions of ms.... i think because of this wait their extract job doesn't finish.... please advice what should i do to fix it.... i have no idea what exactly they r doing in their data extract job... i have been asked to check what is going on the server and i found this... please advicethanksThanks |
|
|
vaari
Starting Member
15 Posts |
Posted - 2011-07-13 : 05:22:09
|
| If you need to fix this - you first need to figure out what the job is doing and how it is doing whatever it is doing. Without knowing this it would pretty much impossible to suggest any fixes.From what I remember reading somewhere - a wait type of PREEMPTIVE_OS_PIPEOPS implies a wait on xp_cmdshell (I cannot find the source I got this info from so I could also be wrong). If they're using xp_cmdshell in their job then this could be the reason for the wait. Other options: You can download the excellent sp_whoisactive SP and use that to check on details of what is happening while the job is executing - this can be a starting point in figuring out how to approach the issue. |
 |
|
|
AustraliaDBA
Starting Member
38 Posts |
Posted - 2011-07-13 : 18:40:10
|
| yes they r using xp_cmdshellThanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
preemptive_os_pipeops