'Re: [cisco-voip] CDR_log.LDF huge size'

[prev in list] [next in list] [prev in thread] [next in thread] 

List: cisco-voip
Subject: Re: [cisco-voip] CDR_log.LDF huge size
From: "Ruben Montes \(Europe\)" <Ruben.Montes () eu ! didata ! com>
Date: 2007-01-31 16:38:16
Message-ID: FA233791F398B848B978464507739E8F3E41C3 () EUBEBRUSVEX1 ! eu ! didata ! local
[Download RAW message or body]

Hi,

I have just shrink the database with the previous commands and it has reduced the \
size of the file from 31Gb to 500Kb without any problem!  We have noticed that the \
CCM's CPU in the server has increased to about 50% usage during 4 to 5 minutes (RTM \
is great!) but it hasn't produced any effect in the call handling or any other \
application...  
Thanks to everybody for the help,

Ruben

________________________________

De: Ryan Ratliff [mailto:rratliff@cisco.com]
Enviado el: mié 31/01/2007 15:40
Para: Ruben Montes (Europe)
CC: Joe Pollere (US); cisco-voip@puck.nether.net
Asunto: Re: [cisco-voip] CDR_log.LDF huge size

Yup, that looks like it's directly taken from Wes' old bug :)

Note that the db shrink will take a while to execute on a 32Gb 
transaction log.

-Ryan

On Jan 31, 2007, at 9:36 AM, Ruben Montes ((Europe)) wrote:

Hi,

if I execute the following commands will I reduce the size of this file?

osql -E
1> use cdr
2> go
1> backup log cdr with no_log
2> go
1> dbcc shrinkdatabase(cdr)
2> go
1>exit

Thanks,

Ruben

De: Ryan Ratliff [mailto:rratliff@cisco.com]
Enviado el: mié 31/01/2007 15:32
Para: Ruben Montes (Europe)
CC: Joe Pollere (US); cisco-voip@puck.nether.net
Asunto: Re: [cisco-voip] CDR_log.LDF huge size

It may take a while but you can still enable BARS to back up your
CDRs.   If your transaction log is filling up that quickly then it
sounds like you have a pretty hefty call volume and you have hit he
max amount of CDR records so Aupair is having to delete a lot of them
to bring you back down.   The max records by default is 1.5 million
and is set via a service parameter for Database Layer Monitor (aka
Aupair).

There is a SQL job that will truncate the logs as well but it only
triggers if the c: drive gets below 500Mb free space.

-Ryan

On Jan 31, 2007, at 8:54 AM, Ruben Montes ((Europe)) wrote:

Hi,

BARS is actually not backing up the CDR. Can I still configure it now
or it's too late due to the size of the file?

Thanks,

Ruben

De: Joe Pollere (US) [mailto:Joe.Pollere@us.didata.com]
Enviado el: mié 31/01/2007 13:59
Para: Ruben Montes (Europe); cisco-voip@puck.nether.net
Asunto: RE: [cisco-voip] CDR_log.LDF huge size

Ruben,

You need to truncate the log file. There is a sql command to do it.
Alternatively if you back up with BARS select CDR and BARS will
truncate for you as part of the backup process.

Joe

From: cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-
bounces@puck.nether.net] On Behalf Of Ruben Montes (Europe)
Sent: Wednesday, January 31, 2007 4:54 AM
To: cisco-voip@puck.nether.net
Subject: [cisco-voip] CDR_log.LDF huge size

Hi,

I have noticed that my CDR_log.LDF file, that is located in C:
\Program Files\Microsoft SQL Server\MSSQL\Data has a size of 32GB and
is growing 5GB per week. I suppose there should be a bug behind, but
the for the moment I want to stop this growing...

Do you know if it is enough with putting the service parameter CDR
Enabled flag to false to stop collecting CDR information? Later on
I'll see how we will purge this because I assume it will be a CPU
intensive process...

I have a TAC case opened, but for the moment the engineer it is not
helping me very much...

Regards,

Ruben

_______________________________________________
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

[Attachment #3 (text/html)]

<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>

<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7650.5">
<TITLE>Re: [cisco-voip] CDR_log.LDF huge size</TITLE>
</HEAD>
<BODY>
<DIV id=idOWAReplyText236 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Hi,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV dir=ltr><FONT face=Arial size=2>I have just shrink the database with the 
previous commands and it has reduced the size of the file from 31Gb to 500Kb 
without any problem! </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>We have noticed that the CCM's CPU in the 
server has increased to about 50% usage during 4 to 5 minutes (RTM is great!) 
but it hasn't produced any effect in the call handling or any other 
application...</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV dir=ltr><FONT face=Arial size=2>Thanks to everybody for&nbsp;the 
help,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV dir=ltr><FONT face=Arial size=2>Ruben</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>De:</B> Ryan Ratliff 
[mailto:rratliff@cisco.com]<BR><B>Enviado el:</B> mié 31/01/2007 
15:40<BR><B>Para:</B> Ruben Montes (Europe)<BR><B>CC:</B> Joe Pollere (US); 
cisco-voip@puck.nether.net<BR><B>Asunto:</B> Re: [cisco-voip] CDR_log.LDF huge 
size<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Yup, that looks like it's directly taken from Wes' old bug 
> )<BR><BR>Note that the db shrink will take a while to execute on a 
32Gb&nbsp;<BR>transaction log.<BR><BR>-Ryan<BR><BR>On Jan 31, 2007, at 9:36 AM, 
Ruben Montes ((Europe)) wrote:<BR><BR>Hi,<BR><BR>if I execute the following 
commands will I reduce the size of this file?<BR><BR>osql -E<BR>1&gt; use 
cdr<BR>2&gt; go<BR>1&gt; backup log cdr with no_log<BR>2&gt; go<BR>1&gt; dbcc 
shrinkdatabase(cdr)<BR>2&gt; 
go<BR>1&gt;exit<BR><BR>Thanks,<BR><BR>Ruben<BR><BR>De: Ryan Ratliff [<A 
href="mailto:rratliff@cisco.com">mailto:rratliff@cisco.com</A>]<BR>Enviado el: 
mié 31/01/2007 15:32<BR>Para: Ruben Montes (Europe)<BR>CC: Joe Pollere (US); 
cisco-voip@puck.nether.net<BR>Asunto: Re: [cisco-voip] CDR_log.LDF huge 
size<BR><BR>It may take a while but you can still enable BARS to back up 
your<BR>CDRs.&nbsp;&nbsp; If your transaction log is filling up that quickly 
then it<BR>sounds like you have a pretty hefty call volume and you have hit 
he<BR>max amount of CDR records so Aupair is having to delete a lot of 
them<BR>to bring you back down.&nbsp;&nbsp; The max records by default is 1.5 
million<BR>and is set via a service parameter for Database Layer Monitor 
(aka<BR>Aupair).<BR><BR>There is a SQL job that will truncate the logs as well 
but it only<BR>triggers if the c: drive gets below 500Mb free 
space.<BR><BR>-Ryan<BR><BR>On Jan 31, 2007, at 8:54 AM, Ruben Montes ((Europe)) 
wrote:<BR><BR>Hi,<BR><BR>BARS is actually not backing up the CDR. Can I still 
configure it now<BR>or it's too late due to the size of the 
file?<BR><BR>Thanks,<BR><BR>Ruben<BR><BR>De: Joe Pollere (US) [<A 
href="mailto:Joe.Pollere@us.didata.com">mailto:Joe.Pollere@us.didata.com</A>]<BR>Enviado \

el: mié 31/01/2007 13:59 Para: Ruben Montes (Europe); 
cisco-voip@puck.nether.net Asunto: RE: [cisco-voip] CDR_log.LDF huge 
size Ruben, You need to truncate the log file. There is a sql 
command to do it. Alternatively if you back up with BARS select CDR and BARS 
will truncate for you as part of the backup 
process. Joe From: cisco-voip-bounces@puck.nether.net [<A 
href="mailto:cisco-voip-">mailto:cisco-voip-</A> bounces@puck.nether.net] On 
Behalf Of Ruben Montes (Europe) Sent: Wednesday, January 31, 2007 4:54 
AM To: cisco-voip@puck.nether.net Subject: [cisco-voip] CDR_log.LDF huge 
size Hi, I have noticed that my CDR_log.LDF file, that is 
located in C: \Program Files\Microsoft SQL Server\MSSQL\Data has a size of 
32GB and is growing 5GB per week. I suppose there should be a bug behind, 
but the for the moment I want to stop this growing... Do you know if 
it is enough with putting the service parameter CDR Enabled flag to false to 
stop collecting CDR information? Later on I'll see how we will purge this 
because I assume it will be a CPU intensive process... I have a TAC 
case opened, but for the moment the engineer it is not helping me very 
much... Regards, Ruben _______________________________________________ cisco-voip \
 mailing list cisco-voip@puck.nether.net <A 
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A> </DIV>

</BODY>
</HTML>

[prev in list] [next in list] [prev in thread] [next in thread] 