I have this Access front end application that sits on SQL Server 7.0 platform. My problem is that once in a while the application will goes to almost a standstill until you probably shut down the server for sometime and restart again. It performs reasonable well after that until say 3 months again. Your suggestion on improving this is appreciated.

Thanks for your help.

-- Anonymous, May 31, 2000

Answers

Jennifer,

On the SQL side you can reindex and update statistics. If you can isolate the query or stored procedure that is being run you can debug and optimize it on SQL server. The index tuning wizard can help with this. It may also be that every 3 months or so you are passing an improper argument to the query or stored procedure.

Good luck,

Eric

-- Anonymous, June 01, 2000