I have a SQL 6.5 database 23.9 gigs. The log is shared with the data, and set to 4 gigs.
There are about 30 users hitting the database.
It is sitting on a server with 4 400 mhz processors and 2 gigs of memory.
At certain times it will just seem to take forever to retrieve data, while other times it runs fine. Most of the time the same number of users are using the database.
I can do simple DB admin tasks, but I'm not familiar with maintenance tasks. I am looking for a list of maintenace tasks that can be performed routinely to keep the database in good working condition. No slow downs. It doesn't seem like it should be a hardware issue, but please let me know if you think it may be.
Thank you for the help.