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 |
|
jimmycjen
Starting Member
15 Posts |
 Posted - 2009-01-15 : 09:25:49
|
| The night before I ran a DBCC CHECKDB job which does DBCC CHECKDB first and if no errors it will do the backup. Usually it takes about 4 hours (for several databases). But yesterday morning when I got to the work it is still running. I looked at Perfmom and I don't see any disk I/O. So I stopped the job thinking this must be a hiccup. Then, last night I before I leave the work, I reran that job. Again, it is still running this morning and Perfmom shows no disk I/O.Can someone help me why is CHECKDB hanging there doing nothing ?Thanks,Jimmy |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-15 : 10:20:42
|
| Check how much Tempdb space you needwith CheckDB with Estimate_only and donot run for all databases at one time. |
 |
|
|
jimmycjen
Starting Member
15 Posts |
Posted - 2009-01-15 : 11:30:32
|
| CHECKDB with Estimate_only needs 500MB for that database but we have 200GB available on the server.BTW, we just ran again but this time we ran manually from Query Analyzer against one database, but it still hangs. So we killed it.Any other suggestions ? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-15 : 11:35:37
|
| I think this is issue:http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic259.aspx |
|
|
|
jimmycjen
Starting Member
15 Posts |
Posted - 2009-01-15 : 12:08:51
|
| Thank you so much for the information. I'm running now table by table to see if there is any table with problems. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-15 : 12:16:04
|
You are Welcome  . |
|
|
|
|
|
|
DBCC CHECKDB not doing anything...