July 26, 2004 at 2:17 pm
I am using MSSQL8.0-SP2 for background production data logging. On one database after about a month all queries and stored procedures fall into timeout. This is true for my logging application (VB6 with ADO) as also for QA. Queries on a similiar smaller database (that contains only a subset of the data) on same server are working fine. Logfiles don't indicate any problems. I am using the Bulk-Logged recovery model with periodic backups. The queries don't give any error - they just fall into a timeout.
There is also one table that should be cleaned up as it has already 2 million small records. When I tried delete this not so important table in Enterprise Manager this failes also.
Queries to other databases are successfull. Any ideas ?
July 26, 2004 at 7:32 pm
Two things. Check statistics on the database and make sure they are up to date. Check possible fragmentation at the file level. If you're writing a bit each each it's possible the files are getting interleaved. These aren't the only two possibilities but they are ones easily checked.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply