MSSQL 2000 performance dropping ('Timeout expired')
Posted on 2006-06-26
I have a weird problem with MSSQL 2000. We moved to MSSQL from Sybase. Everything worked fine for about 3 weeks and then it started. The queries took longer and longer to execute until I started to receive 'Timeout expired'. I already reindexed the DB, checked for invalid columns (first I thought that something got mixed up during the conversion), but nothing helped. Then I restarded the entire server and that helped. But the problem returned in about 3 days. I found out, that after restarting the DB service, the problem disapears for 2-3 days, then it returns. I start receiving timeouts (set for 30s) on queries that should take only miliseconds to execute!
Any ideas on this one???