SQL7/Access97 - Time Out issues

SQL7/Access97 - Something changed and now we have Time out issues

[FrogWatcher]

This database has been running for 4+ years. Backend moved to SQL7 2 years ago. 3 weeks ago we started experiencing time out errors (ODBC ERRORS). Have had to reboot the server 3 times. We have never had to do this before. We have 10 - 12 users. This is average.

We did add 3 new fields to the main table in the database, but I only have 40 fields in that table and the record count is only 320K.

The Time outs are not consistent, but once they start the only we to stop them is to reboot.

Any thoughts?

[mattur]

Have you checked the log on SQL Server for problems? Looking at things from SQL Server's perspective may give a clue as to what's happening and where the timeout is occurring.

Also if you changed your (presumably) asp code when you changed the db, you could re-check all connections and recordsets are closed properly.

Using OLEDB instead of ODBC will usually improve the app performance by cutting out the extra odbc->oledb layer in ADO. HTH

[markus007]

You have long running Queries in SQL 7 that block other users from making requests. Look into your largest tables and add index's on search clauses, that should clear it up.