Subject Re: Firebird speed degrades during the day
Author peter_65@rocketmail.com
--- In firebird-support@yahoogroups.com, Mark Rotteveel wrote:
>
> On Wed, 06 Feb 2013 16:04:45 -0000, "peter_65@..."
> wrote:
> > 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.
>
> Windows SBS 2008 is 64 bit, so maybe you are being bitten by the
> filesystem cache consuming all memory (also discussed in another thread
> this week).
>
> Mark
>

Thanks Mark, I have done a bit og googling and been reading http://support.microsoft.com/kb/976618 and it does seem to fit the symptoms