checking log space usage

I have a database where the log fills up and has to be truncated. I am
trying to create a jo that would run every ten minutes check the log and
write the results into another database to see at what time at night the log
fills up. Anyone have experience with this or advice greatly appreciated.Tom,
Here is a way to get all of the log space usage very quickly. After that
you can keep what you need and follow any other process that is necessary.
CREATE TABLE #LogUse
(DatabaseName nvarchar(100),
LogSize real,
PercentUsed real,
StatusValue INT,
MeasureTime datetime DEFAULT GETDATE())
INSERT INTO #LogUse (DatabaseName, LogSize, PercentUsed,StatusValue)
EXEC ('dbcc sqlperf(logspace)')
SELECT * FROM #LogUse
RLF
"Tom Reis" <reistom@.cdnet.cod.edu> wrote in message
news:e97JDYkpIHA.3900@.TK2MSFTNGP05.phx.gbl...
>I have a database where the log fills up and has to be truncated. I am
>trying to create a jo that would run every ten minutes check the log and
>write the results into another database to see at what time at night the
>log fills up. Anyone have experience with this or advice greatly
>appreciated.
>|||On Apr 25, 3:05=A0am, "Russell Fields" <russellfie...@.nomail.com> wrote:
> Tom,
> Here is a way to get all of the log space usage very quickly. =A0After tha=t
> you can keep what you need and follow any other process that is necessary.=
> CREATE TABLE #LogUse
> (DatabaseName nvarchar(100),
> LogSize real,
> PercentUsed real,
> StatusValue INT,
> MeasureTime datetime DEFAULT GETDATE())
> INSERT INTO #LogUse (DatabaseName, LogSize, PercentUsed,StatusValue)
> EXEC ('dbcc sqlperf(logspace)')
> SELECT * FROM #LogUse
> RLF
> "Tom Reis" <reis...@.cdnet.cod.edu> wrote in message
> news:e97JDYkpIHA.3900@.TK2MSFTNGP05.phx.gbl...
>
> >I have a database where the log fills up and has to be truncated. I am
> >trying to create a jo that would run every ten minutes check the log and
> >write the results into another database to see at what time at night the
> >log fills up. Anyone have experience with this or advice greatly
> >appreciated.- Hide quoted text -
> - Show quoted text -
Hi,
You should also find out the reasons why the log fills so quickly ,
probably the below link should be useful to you.
http://support.microsoft.com/kb/110139/en-us
Thanks
Ajay Rengunthwar
MCTS,MCDBA,MCAD