December 7, 2009 at 2:00 pm
I have a database in Simple Model Recovery. We only use this DB to load data from flat files. The full backup runs every Saturday and the differential runs every night (except Saturday).
This weekend it performed the full backup with no problem at all. Sunday and Monday got an error in that specific database. The Job Process stayed in KILLED/ROLLBACK Status. I Killed the process and it took like 1 hour. My IT guy detected some use memory running. Probably this process, we are not sure.
Since then, the DB takes awhile to run a simple select statement, even if its only one row set of result.
I’m running a DBCC CHECKDB to verify that my database is not corrupted or any page damage. The DBCC has been running for 3 hours now. Not process are blocked, nothing else is running except this DBCC, I can do select in the database, but not inserts.
The database has partition in 2 main tables and contains 25 files/filegroups.
Is normal for the DBCC to take that long? This is my database sizes;
database_namedatabase_sizeunallocated space
Database723242.56 MB667442.68 MB
reserved data index_sizeunused
48320328 KB24344824 KB23971160 KB4344 KB
Any advice?
December 7, 2009 at 2:23 pm
How long will depend on the hardware, but a 700 Gig database will take a while to check. Hours doesn't sound outrageous to me.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 7, 2009 at 2:27 pm
If DBCC CHECKDB is taking longer than usual, there must be something wrong.
Please wait for CHECKDB to complete.
Meanwhile check below link.
http://www.microsoft.com/emea/teched2008/itpro/tv/default.aspx?vid=78
December 7, 2009 at 2:38 pm
should I stop it?
It has 3:23hours already
December 7, 2009 at 2:40 pm
I would let it run to completion if at all possible.
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
December 8, 2009 at 1:21 am
MTY-1082557 (12/7/2009)
should I stop it?It has 3:23hours already
No. Let it run to completion. Stopping it won't cause any problems, but you also won't get any results, essentially wasting the hours that it's been running
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
December 8, 2009 at 12:02 pm
Any update, did you resolve the issue. Please post output of CHECKDB
December 8, 2009 at 12:09 pm
Hi all,
I didnt have any chance to post the results 'cause we are with another issue.
The CHECKDB never end. It was still a KILL/ROLLBACK process "running". So when we killed the process the CHECKDB stopped.
We reboot out server and re run the CHECKDB again and only took 5 minutes with no error at all.
Seems like the KIL/ROLLBACK process was blocking everything else.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply