May 7, 2003 at 10:46 pm
I have had problems for quite some time with SQL Server running slow. Users get the "Switch To, Retry screen) Only way to fix it is to stop Sql Server and restart. The problem may occur one or two times a week and then not reppear for weeks. Anyone seen this problem before? I believe it could have something to do with SQL Server not releasing locks???
May 8, 2003 at 3:33 am
I have not seen this but after the SP4 install I suggest make sure you DBCC DBREINDEX, sp_updatestats and DBCC UPDATEUSAGE to ensure the data is in line with any possible engine changes. If the problem still crops up the consider doing a trace and monitor odd events, long queries and deadlocks.
May 8, 2003 at 2:50 pm
though we did not have the same problem..we did have scheduler 2 hung messages and queries used to time out at certain times. The root cause is a bug with sql 7.0 which i found out after paying for the issue to MSFT.Another issue was traced when we ran the profiler. There was a query within the app that locked resources even after completing the work. just look for routine locks that happen when the server slows down by running sp_lock and sp_who2 active. Maybe you will come across similar processes.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply