DBCC CheckDB Runs forever...

[Anthony M. Perugini]

Hi All,

Here's another puzzle. Windows NT 4.0, SP3, Sybase SQL Server 11.0.2.1.

We run DBCC CheckDB on all of our databases each Sunday morning. Up until
recently, DBCC ran fine. Now, when we run DBCC CheckDB, it runs forever and
very slowly.

For example, we've kicked off DBCC CheckDB on one database Monday morning
at 5:00am, it is still running today, and is 50% complete?!?!? This same
database would take only a few minutes. Why?!?!

There are NO other processes running, no errors, no messages, but CPU
utilization and I/O are extremely high. This happens in both our QA and
production servers. Some tables in the database have 12 -15 million rows.
But, why does DBCC run so slowly when it was running fine for months on the
same databases?!?!

Any help would be appreciated.
Thanks,
--
Tony Perugini
President
Forte Information Systems, Inc.
www.ConsultForte.com

[Tony Imbierski]

Hi Anthony

Have you added any indexes recently?

tonyi

--
===============================================================
Tony Imbierski
Sybase Adaptive Server Engineering
Kernel & Platform Sustaining
---------------------------------------------------------------

===============================================================

[AnaMaria Stirbet]

Hi Tony,

If the problem reoccurs, upgrade your server to at least 11.0.3.
And of course, let me know if you still have the problem.

AnaMaria Stirbet
Sybase TS

[Anthony M. Perugini]

AnaMaria,

Thanks for the reply, however we cannot upgrade to 11.0.3 at this time.
Can you explain why I need to upgrade to 11.0.3? Is there an EBF that
fixes this particular problem? Or, is this just a shot in the dark?

The problem reoccurs every time we run it. BTW, DBCC is still running on a
database which we kicked off Monday morning at 5:00am. The question
remains, WHY?

--
Tony Perugini
President
Forte Information Systems, Inc.
www.ConsultForte.com

AnaMaria Stirbet <AnaMaria...@sybase.com.no.spam> wrote in article
<36557E...@sybase.com.no.spam>...

[AnaMaria Stirbet]

Hi Tony,

I've seen this and other similar things happening a number of times in
pre-11.0.3 releases and they were fixed by a number of bug fixes in
11.0.3.
So yes, this is a guess, but based on some experience.

AnaMaria Stirbet
CSP-DBA

[Anthony M. Perugini]

AnaMaria,

Thanks. I ask this because I've searched the EBF's for this particular
problem, but did not find any matches. I did find other issues with DBCC.
We're going to kill this DBCC process and try the latest EBF 8090 on our
test box and see if this fixes the problem.

We can't immediately upgrade to 11.0.3.3 in production until we thoroughly
test the EBF. We've had many problems with EBF's breaking things in SQL
Server. I'll let you know what we find.

Thanks,
--
Tony Perugini
President
Forte Information Systems, Inc.
www.ConsultForte.com

AnaMaria Stirbet <AnaMaria...@sybase.com.no.spam> wrote in article
<3655A3...@sybase.com.no.spam>...