October 6, 2015 at 11:31 am
DBCC CHECKDB was affecting performance. Screens were hanging, timeouts, etc.
So I made the unfortunate decision of Killing the 2 processes.
I keep checking the percent complete and they are stuck at 33% and 17%.
Will I have to restart the SQL Server Service?
Are they any other options?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 6, 2015 at 11:34 am
It finished while I was writing my post.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 6, 2015 at 12:06 pm
If you had restarted SQL, the rollback would have started again from the beginning, with the database offline and inaccessible until the rollback had completed. It's a good way to make a situation far, far worse.
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
October 6, 2015 at 2:10 pm
That is what I thought.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply