Hi,

I've got a database with a client, it's not a big database around 2228 MB. They hav about 65 users entering data 5 days aweek, 8 hours a day. There are times during the day that the application using this database seems to slow down only for a few minutes and then returns to normal speed.

I was wondering if the cause of this was the filegrowth, it is currently set at 10%, unrestricted growth.

The question is what should this be set at, I seem to think that this should be at least 40%. This would allow the database to grow once maybe every couple of weeks rather than most days. Should I also apply the this to the transaction log as that is also set at 10%.

Thanks inadvance

Duncan

__________________
Duncan

The appearance of slowing down happening at the same time everyday?
Check for automated jobs or automated process. Also check your database option for auto shrink. I could be that it goes off based on its internal schedule. If this is the case you may want schedule it when your system is not as active.

One of the best method is to profile your database to find out when and where performance is degrading.

Jaime E. Maccou
Applications Analyst

Also, check for what time of day it slows. Where I work at lunch time and 4:00 the network connection slows to a crawl.

Hi

There are no scheduled jobs running, it happens at various times, but usaully in the morning when most of the data entry work is done. Auto shrink is on, but as far as I know not sheduled to run at all.





Duncan

Hi Duncan,

It is better to profile your database as Jemmac suggested, during when its performance is slow, to find which operation causes the slowness. That should put you on the right track.

Cheers!

_________________________
- Vijay G
Strive for Perfection