October 31, 2008 at 3:53 am
Hi
I am working on an SQL server where one of the databases shows dbcheck to be running every couple of minutes. I have checked maintenance plans and there is nothing scheduled.
This is a simple database which no-one is currently using however another database has an ongoing problem where every second or third query made on it via the application software takes an inordinate amount of time - up to 25 seconds whereas the normal query is instantaneous.
Thus I would like to establish why the dbcheck is always running on the simple database before I tackle the larger problem of sluggish performance.
TIA
Regards
Peter V.
October 31, 2008 at 4:02 am
There's no way to tell SQL Server to automatically run DBCC CHECKDB - so there *has* to be an Agent job or other connection that's running it.
Your other problem sounds something like statistics being out-of-date and affecting some of the queries.
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply