SQL Server Performance Forum – Threads Archive

Check Database Integrity Task

Newbie DBA is back: D, life was much easier as developer. For a week ago I started to have problem with Check Database Integrity Task in my SSIS pack took more than 10h to finish. Before it took around 15min to complete.
If I run simple script loops all databases and make a DBCC CHECKDB(NAME) its take no more than 15 min with no errors. Does not Check Database Integrity Task make CHECKDB in the background.
And CPU I also strange the Check Database Integrity Task take lot of resources but the check db loop much more non cpu intensive.

[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] I don’t trust you have had peaceful life as a Developer, DBA is much better. If that DBCC integrity job is taking more than 10 hours then you should see what other jobs & processes are running parallely. IN general the integrity job is resource intensive and better to run during off-peak hours on the server. Also refer to this KBA<a target="_blank" href=http://support.microsoft.com/kb/934459>http://support.microsoft.com/kb/934459</a> and see the criteria matches and if so download the relevant patch. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</center>

Big Thanks, You made my dayâ€¦ <img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ />. We have Microsoft SQL Server 2005 – 9.00.3054.00 (Intel IA-64) Mar 23 2007 18:42:19 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

Is the problem solved?

Yes this path apply to the server with the problem.

[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] glad to know that, when you said there is an issue with integrity check then this KBA came to my mind. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</center>

]]>