>> Hi, I have a customer with FB 1.56 sitting on SBS 2008 std and mostly xp
>> clients. In certain areas of the program where activity is heaviest
>> (server side procedures are being run to calculate the data) it takes over
>> 5 minutes to complete the process. I have put their fdb on my system and
>> do not have the same issue. At first I thought this pointed to an issue on
>> their network but then they told me that if they run a backup and restore
>> there is no issue with delays and it runs fine; however, over the period
>> of a day the speed degrades back to the 5 minutes plus for the function to
>> complete. If they back up and restore all is initially well again - but
>> again things degrade over the period of the day. If anyone can tell me
>> what is occurring and how to fix it I would be most grateful.
>>
>
> Along with Svein's good advice, I would also consider looking at the actual
> indexes for high volume tables. I sometimes run a routine that will disable
> all indexes and then re-enable them to update their stats. I forgot to
> re-enable them once and my main client started experiencing the same
> symptoms of slow downs during the day. Make sure you have proper indexes
> created, not excessive, but necessary ones.

+1.

I have really seen over-indexed databases, at worst over-indexed with
bad indices (e.g. 100% of duplicates) over the last few years.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/