Wednesday, March 21, 2012

Log file not growing

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...
>> 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.
>
>.
>sql

No comments:

Post a Comment