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 |
shaggy
Posting Yak Master
248 Posts |
Posted - 2013-03-18 : 02:13:47
|
I cancelled the query yesterday still it is running till now and my waitype is PREEMPTIVE_OS_PIPEOPS The command in that cancelled query has xp_cmdshell which i executed in ssms |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2013-03-18 : 04:44:31
|
Thanks jack command running is displayed as "EXECUTE" |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2013-03-18 : 08:11:22
|
Killed the process and the rollback is continuing 2nd day so i restarted the instanceI ran exec xp_cmdshell 'notepad' and stopped within a few seconds cancelled the query closed the machine i thought it will stop but the cancel still running for a day and i killed the process by the time the process is running,waitype is PREEMPTIVE_OS_PIPEOPS my CPU and I/0 is gowing and gowingTry this only in test server. |
|
|
|
|
|