My canceling query running for 1 day

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

My canceling query running for 1 day

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

Posted - 2013-03-18 : 02:54:20

Is it in ROLLBACK mode? Use this query to monitor the rollback: http://www.sqlserver-dba.com/2011/11/monitoring-a-rollback-and-sysdm_exec_requests.html.
Can you generate a dump file?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

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 instance

I 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 gowing

Try this only in test server.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources