I have a Db that is 3.8Gb and a log file that is 1mb the
log file does not grow. The db is setup with simple
recovery and the log file is configured to autogrow by
10%. Users are complaining that the DB is slow. My
hardware on this server is: 2 pentium xeon's with 4Gb of
ram 2 raid controllers 1 running raid 1 for the OS and
the other Raid 5 for the DB.
In simple recovery mode the log is automatically truncated every time a
checkpoint occurs ( default every minute)... So the log will never get
larger than the longest running transaction..
"Carlos Santos" <anonymous@.discussions.microsoft.com> wrote in message
news:1b96f01c4209d$7352d860$a101280a@.phx.gbl...
> I have a Db that is 3.8Gb and a log file that is 1mb the
> log file does not grow. The db is setup with simple
> recovery and the log file is configured to autogrow by
> 10%. Users are complaining that the DB is slow. My
> hardware on this server is: 2 pentium xeon's with 4Gb of
> ram 2 raid controllers 1 running raid 1 for the OS and
> the other Raid 5 for the DB.
|||Thanks,
>--Original Message--
>In simple recovery mode the log is automatically
truncated every time a
>checkpoint occurs ( default every minute)... So the log
will never get
>larger than the longest running transaction..
>"Carlos Santos" <anonymous@.discussions.microsoft.com>
wrote in message
>news:1b96f01c4209d$7352d860$a101280a@.phx.gbl...
the
of
>
>.
>
No comments:
Post a Comment