[cisco-voip] CDR_log.LDF huge size

[Ruben Montes (Europe)]

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 at cisco.com]
Enviado el: mié 31/01/2007 15:40
Para: Ruben Montes (Europe)
CC: Joe Pollere (US); cisco-voip at 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 at cisco.com]
Enviado el: mié 31/01/2007 15:32
Para: Ruben Montes (Europe)
CC: Joe Pollere (US); cisco-voip at 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 at us.didata.com]
Enviado el: mié 31/01/2007 13:59
Para: Ruben Montes (Europe); cisco-voip at 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 at puck.nether.net [mailto:cisco-voip-
bounces at puck.nether.net] On Behalf Of Ruben Montes (Europe)
Sent: Wednesday, January 31, 2007 4:54 AM
To: cisco-voip at 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 at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip



-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20070131/842cfa50/attachment.html