[cisco-voip] Max CDR Records

[Erick Bergquist]

You may want to consider putting the CDR database on it's own server
in the cluster that just does CDR jobs if it's going to be big.  A few
other things I can think of with it being a bigger size are the
nightly CDR/CAR jobs may take longer to run, backups will be larger if
you backup CDR, CAR, etc.

On 8/24/07, Keith Klevenski <keith.klevenski at rig.net> wrote:
>
>
>
>
> Actually we are using Infortel.  Can't say I'm a big fan of it, but I
> suppose it works.  Actually I don't like it at all.  Actually I don't like
> dealing with phone bills at all.  Actually I hate dealing with phone bills.
>
>
>
> Anyway… we upgraded back in March to a version that has a redirected number
> report.  One problem is I can't go any further back than March.  I've been
> asked for a report of calls to the NOC that when to voicemail starting in
> December in Excel format (Infortel will only give you a PDF, HTML, or RTF
> for this particular report.. LAME).  Silly me, I thought I've been keeping
> CDRs for a year when actually I only had 6 weeks worth so I was just going
> to run a simple SQL query and give them exactly what they wanted.  Not.
>
>
>
> I guess 1.5 mil is the recommended setting for a reason.  20 mil CDRs on box
> is silly I guess.  It just forces me to lean more on Infortel which I do not
> like.  K
>
>
>
>
>
>
> Keith Klevenski
>  IP Telephony Engineer
>
> RigNet Inc.
>  1880 S. Dairy Ashford
>
> Suite 300
>  Houston, TX 77077
>
> Office:   +1 281.674.0702
>  Mobile:  +1 713.677.3925
>
> http://www.rig.net
>
>
>
> "Extending the power of your knowledge"
>
>
>
>
>
> From: Jason Aarons (US) [mailto:jason.aarons at us.didata.com]
>  Sent: Friday, August 24, 2007 2:33 PM
>  To: Keith Klevenski; cisco-voip at puck.nether.net
>  Subject: RE: [cisco-voip] Max CDR Records
>
>
>
>
> I would look at a third-party to archive your CDRs, ever try to upgrade
> CallManager versions with 13 mil records in the db ? Could take a day or
> more just to run the upgrade..
>
>
>
> InforTel for Windows has some good features, allows offbox archiving of cdrs
> -jason
>
>
>
>
>
>
>
> From: cisco-voip-bounces at puck.nether.net
> [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of
> Keith Klevenski
>  Sent: Friday, August 24, 2007 3:18 PM
>  To: cisco-voip at puck.nether.net
>  Subject: [cisco-voip] Max CDR Records
>
>
>
> Is there any problem with changing the max CDR records service parameter to
> a significantly higher number?  1.5 mil records is about 6 weeks for us
> which really isn't enough.  I was wondering why the records only went back 6
> weeks since I have automatic purging set to 365 days, but totally forgot
> about the max CDR records parameter.  :P  I'd like to keep a year if
> possible which would be about 13 mil records.  The call volume is only going
> up so I was thinking about setting it to 15 mil or even 20 and let the
> automatic purge handle anything over 365 days.
>
>
>
> Other than the size of the backup and disk space, is there any reason not to
> set this so much higher than the 1.5 mil 'recommended' setting?
>
>
>
> Thanks.
>
>
>
> Keith Klevenski
>  IP Telephony Engineer
>
> RigNet Inc.
>  1880 S. Dairy Ashford
>
> Suite 300
>  Houston, TX 77077
>
> Office:   +1 281.674.0702
>  Mobile:  +1 713.677.3925
>
> http://www.rig.net
>
>
>
> "Extending the power of your knowledge"
>
>
>  ________________________________
>
>
> Disclaimer: This e-mail communication and any attachments may contain
> confidential and privileged information and is for use by the designated
> addressee(s) named above only. If you are not the intended addressee, you
> are hereby notified that you have received this communication in error and
> that any use or reproduction of this email or its contents is strictly
> prohibited and may be unlawful. If you have received this communication in
> error, please notify us immediately by replying to this message and deleting
> it from your computer. Thank you.
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>