Server Crashing on DBCC CHECKDB

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

SQL Server 2005 Forums

SQL Server Administration (2005)

Server Crashing on DBCC CHECKDB

Author

Topic

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2010-01-19 : 12:28:28

folks
I have 50GB database 49 GB of which is PDF Documents.
When we run Database Integrity check on the database, the server crashes completely. We ahve to hard boot it everytime.
The server is a HP 380 with internal hard drives only.
SQL 2005 SP3. Windows 2003 SP2.

Any ideas?

Regards
Paresh Motiwala
Boston, USA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-01-19 : 12:53:21

Sounds like you've got some bad hardware issues. Run system diagnostics.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2010-01-19 : 13:20:20

sorry, I should have cleared one more thing. This first started on one server. It wouldn't always crash.
but the frequency of crashes started to go up.

So i picked up the databae and put it on a different box. here too, it crashed at the third run.
I have a strong feeling we are looking at SQL's inability to deal with large volume of PDF Documents in a database.

Regards
Paresh Motiwala
Boston, USA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-01-19 : 13:22:44

You've got a corrupted database which needs to be addressed. Since DBCC CHECKDB is bombing out, which makes it hard to work on the corruption, you probably should open up a Severity A or B case with Microsoft PSS to get it resolved. I wouldn't waste another minute, get help on this.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2010-01-19 : 13:30:35

wow.
Thanks Tara
Just raised one right away.

Regards
Paresh Motiwala
Boston, USA

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-01-19 : 14:35:41

Lots of pdfs in a database is not going to cause checkDB failures. My guess is major hardware problems. I second the recommendation for CSS, they have the tools to analyse crash dumps, we don't.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources