|
Home > Archive > Voice over IP Cisco > August 2007 > Max CDR Records
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Keith Klevenski 2007-08-24, 7:12 pm |
| 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 <http://www.rig.net/>
"Extending the power of your knowledge"
| |
| Lelio Fulgenzi 2007-08-24, 7:12 pm |
| I heard bad things can happen, but am eager to hear what others say. For us, I think it's only about 2 weeks.
----- Original Message -----
From: Keith Klevenski
To: cisco-voip@puck.nether.net
Sent: Friday, August 24, 2007 3:18 PM
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"
------------------------------------------------------------------------------
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
| |
| Jason Aarons \(US\) 2007-08-24, 7:12 pm |
| 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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Keith Klevenski
Sent: Friday, August 24, 2007 3:18 PM
To: cisco-voip@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 muchhigher 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 <http://www.rig.net/>
"Extending the power of your knowledge"
-----------------------------------------
Disclaimer:
This e-mail communication and any attachments may contain
confidential and privileged information andis 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. Ifyou have received this communication in error, please
notify us immediately by replying to this message and deleting it
from your computer. Thank you.
| |
| Keith Klevenski 2007-08-24, 7:12 pm |
| 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 <http://www.rig.net/>
"Extending the power of your knowledge"
From: Jason Aarons (US) [mailto:jason.aarons@us.didata.com]
Sent: Friday, August 24, 2007 2:33 PM
To: Keith Klevenski; cisco-voip@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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Keith Klevenski
Sent: Friday, August 24, 2007 3:18 PM
To: cisco-voip@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 <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.
| |
| Erick Bergquist 2007-08-27, 1:11 am |
| 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@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 bill=
s.
>
>
>
> Anyway=85 we upgraded back in March to a version that has a redirected nu=
mber
> 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@us.didata.com]
> Sent: Friday, August 24, 2007 2:33 PM
> To: Keith Klevenski; cisco-voip@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 c=
drs
> -jason
>
>
>
>
>
>
>
> From: cisco-voip-bounces@puck.nether.net
> [mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of
> Keith Klevenski
> Sent: Friday, August 24, 2007 3:18 PM
> To: cisco-voip@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 bac=
k 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 go=
ing
> 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 delet=
ing
> it from your computer. Thank you.
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
| |
| Robert Singleton 2007-08-27, 1:12 pm |
| T24gRnJpLCAyMDA3LTA4LTI0IGF0IDE1OjE2IC0w
NTAwLCBLZWl0aCBLbGV2ZW5za2kgd3JvdGU6
Cgo+ICBTaWxseSBtZSwgSSB0aG91Z2h0IEnigJl2
ZSBiZWVuIGtlZXBpbmcgQ0RScyBmb3IgYSB5
ZWFyIHdoZW4gYWN0dWFsbHkgSQo+IG9ubHkgaGFk
IDYgd2Vla3Mgd29ydGggc28gSSB3YXMganVz
dCBnb2luZyB0byBydW4gYSBzaW1wbGUgU1FMIHF1
ZXJ5Cj4gYW5kIGdpdmUgdGhlbSBleGFjdGx5
IHdoYXQgdGhleSB3YW50ZWQuICBOb3QuCj4gCj4g
IAo+IAo+IEkgZ3Vlc3MgMS41IG1pbCBpcyB0
aGUgcmVjb21tZW5kZWQgc2V0dGluZyBmb3IgYSBy
ZWFzb24uICAyMCBtaWwgQ0RScwo+IG9uIGJv
eCBpcyBzaWxseSBJIGd1ZXNzLiAgSXQganVzdCBm
b3JjZXMgbWUgdG8gbGVhbiBtb3JlIG9uIElu
Zm9ydGVsCj4gd2hpY2ggSSBkbyBub3QgbGlrZS4g
IEsKCkkgZmFjZWQgYSBzaW1pbGFyIHByb2Js
ZW0gYW5kIG9ubHkgcmVjZW50bHkgc3RhcnRlZCBk
b2luZyBzb21ldGhpbmcgSQpzaG91bGQgaGF2
ZSBiZWVuIGRvaW5nIGFsbCBhbG9uZywgYXJjaGl2
aW5nIG15IENEUnMgb24gYW5vdGhlciBzZXJ2
ZXIuCgpJIGhhdmUgbm90IGFzIHlldCB3cml0dGVu
IGEgc2NyaXB0IHRvIHB1dCB0aGVtIG9uIGFu
b3RoZXIgU1FMLCBidXQgd2hhdApJJ20gYXJjaGl2
aW5nIGlzIHRoZSByZXN1bHRzIG9mIGEgInNl
bGVjdCAqIGZyb20gQ2FsbERldGFpbFJlY29yZCIg
YW5kCiJzZWxlY3QgKiBmcm9tIENhbGxEZXRh
aWxSZWNvcmREaWFnbm9zdGljIiBkYWlseS4gVGhl
IGNyb24gam9iIHJ1bnMgYXQKMDQ6MDAgZWFj
aCBkYXkgYW5kIG1vc3QgZGF5cyBhcmUgYWJvdXQg
My41TUIgY29tcHJlc3NlZC4gSSBzdGFydGVk
IHRoZQphdXRvbWF0aWMgcHJvY2VzcyBvbiBKdW4g
MSBhbmQgbWFudWFsbHkgYXJjaGl2ZWQgd2hh
dCB3YXMgZXhpc3RpbmcgYXQKdGhhdCB0aW1lLCBz
byBJIGhhdmUgZGFpbHkgY2FwdHVyZXMgYmFj
ayB0byBBcHJpbCAxOC4KCkkgYWxzbyBmb3VuZCBp
dCBoYW5keSB0byBrbm93IHdoYXQgcmFuZ2Ug
b2YgQ0RScyBhcmUgYXZhaWxhYmxlIGFuZCB3cm90
ZQphIHF1aWNrIHNjcmlwdCB0aGF0IGdldHMg
bWluKGRhdGVUaW1lT3JpZ2luYXRpb24pIGFuZApt
YXgoZGF0ZVRpbWVPcmlnaW5hdGlvbikgYW5k
IHJldHVybnMgdGhlbSBpbiBodW1hbiByZWFkYWJs
ZSBmb3JtYXQuCgpSb2JlcnQKCgpfX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fXwpjaXNjby12b2lwIG1haWxp
bmcgbGlzdApjaXNjby12b2lwQHB1Y2submV0aGVy
Lm5ldApodHRwczovL3B1Y2submV0aGVyLm5l
dC9tYWlsbWFuL2xpc3RpbmZvL2Npc2NvLXZvaXA=
| |
| Keith Klevenski 2007-08-27, 1:12 pm |
| WWVhLCB0aGF0IHNvdW5kcyBsaWtlIGEgZ29vZCBp
ZGVhLiAgSSBtYXkgY29uc2lkZXIgZG9pbmcg
c29tZXRoaW5nIGxpa2UgdGhhdCBhcyBpdCBpcyBh
d2Z1bCBuaWNlIHRvIGhhdmUgdGhlIGFjdHVh
bCBDRFJzIGF2YWlsYWJsZSBpZiB5b3UgbmVlZCB0
aGVtIHJhdGhlciB0aGFuIGEgM3JkIHBhcnR5
J3MgdmVyc2lvbiBvZiB0aGVtLg0KDQpLZWl0aCBL
bGV2ZW5za2kNCklQIFRlbGVwaG9ueSBFbmdp
bmVlcg0KUmlnTmV0IEluYy4NCjE4ODAgUy4gRGFp
cnkgQXNoZm9yZA0KU3VpdGUgMzAwDQpIb3Vz
dG9uLCBUWCA3NzA3N8KgwqDCoMKgwqDCoMKgwqAg
DQpPZmZpY2U6IMKgICsxIDI4MS42NzQuMDcw
Mg0KTW9iaWxlOsKgICsxIDcxMy42NzcuMzkyNQ0K
aHR0cDovL3d3dy5yaWcubmV0DQoNCiJFeHRl
bmRpbmcgdGhlIHBvd2VyIG9mIHlvdXIga25vd2xl
ZGdlIg0KDQoNCi0tLS0tT3JpZ2luYWwgTWVz
c2FnZS0tLS0tDQpGcm9tOiBjaXNjby12b2lwLWJv
dW5jZXNAcHVjay5uZXRoZXIubmV0IFttYWls
dG86Y2lzY28tdm9pcC1ib3VuY2VzQHB1Y2submV0
aGVyLm5ldF0gT24gQmVoYWxmIE9mIFJvYmVy
dCBTaW5nbGV0b24NClNlbnQ6IE1vbmRheSwgQXVn
dXN0IDI3LCAyMDA3IDk6MDYgQU0NClRvOiBj
aXNjby12b2lwQHB1Y2submV0aGVyLm5ldA0KU3Vi
amVjdDogUmU6IFtjaXNjby12b2lwXSBNYXgg
Q0RSIFJlY29yZHMNCg0KT24gRnJpLCAyMDA3LTA4
LTI0IGF0IDE1OjE2IC0wNTAwLCBLZWl0aCBL
bGV2ZW5za2kgd3JvdGU6DQoNCj4gIFNpbGx5IG1l
LCBJIHRob3VnaHQgSeKAmXZlIGJlZW4ga2Vl
cGluZyBDRFJzIGZvciBhIHllYXIgd2hlbiBhY3R1
YWxseSBJDQo+IG9ubHkgaGFkIDYgd2Vla3Mg
d29ydGggc28gSSB3YXMganVzdCBnb2luZyB0byBy
dW4gYSBzaW1wbGUgU1FMIHF1ZXJ5DQo+IGFu
ZCBnaXZlIHRoZW0gZXhhY3RseSB3aGF0IHRoZXkg
d2FudGVkLiAgTm90Lg0KPiANCj4gIA0KPiAN
Cj4gSSBndWVzcyAxLjUgbWlsIGlzIHRoZSByZWNv
bW1lbmRlZCBzZXR0aW5nIGZvciBhIHJlYXNv
bi4gIDIwIG1pbCBDRFJzDQo+IG9uIGJveCBpcyBz
aWxseSBJIGd1ZXNzLiAgSXQganVzdCBmb3Jj
ZXMgbWUgdG8gbGVhbiBtb3JlIG9uIEluZm9ydGVs
DQo+IHdoaWNoIEkgZG8gbm90IGxpa2UuICBL
DQoNCkkgZmFjZWQgYSBzaW1pbGFyIHByb2JsZW0g
YW5kIG9ubHkgcmVjZW50bHkgc3RhcnRlZCBk
b2luZyBzb21ldGhpbmcgSQ0Kc2hvdWxkIGhhdmUg
YmVlbiBkb2luZyBhbGwgYWxvbmcsIGFyY2hp
dmluZyBteSBDRFJzIG9uIGFub3RoZXIgc2VydmVy
Lg0KDQpJIGhhdmUgbm90IGFzIHlldCB3cml0
dGVuIGEgc2NyaXB0IHRvIHB1dCB0aGVtIG9uIGFu
b3RoZXIgU1FMLCBidXQgd2hhdA0KSSdtIGFy
Y2hpdmluZyBpcyB0aGUgcmVzdWx0cyBvZiBhICJz
ZWxlY3QgKiBmcm9tIENhbGxEZXRhaWxSZWNv
cmQiIGFuZA0KInNlbGVjdCAqIGZyb20gQ2FsbERl
dGFpbFJlY29yZERpYWdub3N0aWMiIGRhaWx5
LiBUaGUgY3JvbiBqb2IgcnVucyBhdA0KMDQ6MDAg
ZWFjaCBkYXkgYW5kIG1vc3QgZGF5cyBhcmUg
YWJvdXQgMy41TUIgY29tcHJlc3NlZC4gSSBzdGFy
dGVkIHRoZQ0KYXV0b21hdGljIHByb2Nlc3Mg
b24gSnVuIDEgYW5kIG1hbnVhbGx5IGFyY2hpdmVk
IHdoYXQgd2FzIGV4aXN0aW5nIGF0DQp0aGF0
IHRpbWUsIHNvIEkgaGF2ZSBkYWlseSBjYXB0dXJl
cyBiYWNrIHRvIEFwcmlsIDE4Lg0KDQpJIGFs
c28gZm91bmQgaXQgaGFuZHkgdG8ga25vdyB3aGF0
IHJhbmdlIG9mIENEUnMgYXJlIGF2YWlsYWJs
ZSBhbmQgd3JvdGUNCmEgcXVpY2sgc2NyaXB0IHRo
YXQgZ2V0cyBtaW4oZGF0ZVRpbWVPcmlnaW5h
dGlvbikgYW5kDQptYXgoZGF0ZVRpbWVPcmlnaW5h
dGlvbikgYW5kIHJldHVybnMgdGhlbSBpbiBo
dW1hbiByZWFkYWJsZSBmb3JtYXQuDQoNClJvYmVy
dA0KDQoNCl9fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fDQpj
aXNjby12b2lwIG1haWxpbmcgbGlzdA0KY2lz
Y28tdm9pcEBwdWNrLm5ldGhlci5uZXQNCmh0dHBz
Oi8vcHVjay5uZXRoZXIubmV0L21haWxtYW4v
bGlzdGluZm8vY2lzY28tdm9pcA0KX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX18KY2lzY28tdm9pcCBtYWlsaW5n
IGxpc3QKY2lzY28tdm9pcEBwdWNrLm5ldGhl
ci5uZXQKaHR0cHM6Ly9wdWNrLm5ldGhlci5uZXQv
bWFpbG1hbi9saXN0aW5mby9jaXNjby12b2lw
|
|
|
|
|