February 2, 2010 at 11:57 am
i have a query that is doing about 50 million insertions on a table,the query has been running for 15 mins and i pressed the stop button but its still running, could you someone tell me how to stop it
February 2, 2010 at 12:02 pm
you could try and kill it but its likely it will take around 15 mins to rollback.
try doing the inserts in batches
February 2, 2010 at 12:02 pm
Wait.
It has to finish rolling back. There is no way to stop a rollback, what was done before you cancelled the query has to be undone.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2010 at 12:12 pm
KlineandKing,
Do as Gail said. You need to wait out the rollback.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 2, 2010 at 12:13 pm
ok thanks guys am still waiting i appreciate it
February 2, 2010 at 12:20 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply