This is a better approach when you have a lot of statistical metrics to collect around the clocks. Use SSLOGGER instead. The challenges we had were to parse the log files and loaded them into Oracle DB.
Charles ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2008 3:34 AM To: spectrum Subject: SV: [spectrum] Reporting Database Size Estimates http://spectrum.knowsitall.info/wiki/Disable_statistics_logging <http://spectrum.knowsitall.info/wiki/Disable_statistics_logging> If you don't use the stored statistics i DDMDB, you can do this. This will both increase performance of Spectrum and limit use of DDMDB. Roberth Edberg Adaptive Systems Architect SEB / Group IT Web: http://www.seb.se <http://www.seb.se/> Systems Management E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Rissneleden 110 Voice: +46 8 639 30 42 SE-106 40 Stockholm Mobile: +46 70 509 30 42 Fax: +46 8 706 60 25 ________________________________ - "Did you know that the first Matrix was designed to be a perfect human world, where none suffered; where everyone would be happy. It was a disaster. No one would accept the program. Entire crops were lost. Some believed that we lacked the programming language to describe your perfect world, but I believe that as a species, human beings define their reality through misery and suffering. So the perfect world we dreamed, but your primitive cerebrum kept trying to wake up from. Which is why The Matrix was redesigned to this...the peak of your civilization." / Agent Smith {The Matrix} ________________________________ Från: Nissel, David [mailto:[EMAIL PROTECTED] Skickat: den 10 oktober 2008 02:46 Till: spectrum Ämne: RE: [spectrum] Reporting Database Size Estimates We've got about 1300 routers and switches (mostly routers) and probably 300 or so servers and after about 11 months or so, our Event Table is about 11.5GB and the Interface Outage table is about 2.2GB. Most of the rest are only in the 10's of megabytes. Hope that helps Dave Nissel Network Architect ~~~~~~~~~~~~~~~~~~ Select Medical Corporation 717-975-4522 [EMAIL PROTECTED] SendPlainText ________________________________ From: Brett Davis Sent: Thu 10/9/2008 10:34 AM To: spectrum Subject: [spectrum] Reporting Database Size Estimates -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I'm trying to get a feel for how much storage capacity we'll need if we start using report manager. We'd like keep data for a whole year, and currently we have about 3,200 devices being monitored. Can anybody give me some ideas on how big your reporting DB has become, along with the approximate number of network devices and data retention period? Rough estimates are all I need. Thanks guys. - -- Brett Davis IT Network and Security Operations Cisco Certified Network Associate (CCNA) Purdue University YONG 605 Phone (765) 49-62304 [EMAIL PROTECTED] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.8 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkjuFmwACgkQ+j4RojbPFmDYPQCcDyNKiM2QQSLqehhlAd0Li9cB jSMAoIGfLy4Wo5osfw1d4LAP9H2UmMDF =5C0O -----END PGP SIGNATURE----- * --To unsubscribe from spectrum, send email to [EMAIL PROTECTED] with the body: unsubscribe spectrum [EMAIL PROTECTED] * --To unsubscribe from spectrum, send email to [EMAIL PROTECTED] with the body: unsubscribe spectrum [EMAIL PROTECTED] <html> <body> <p>***********************************************************************</p> <p>The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter.</p> <p>***********************************************************************</p> </body> </html> --- To unsubscribe from spectrum, send email to [EMAIL PROTECTED] with the body: unsubscribe spectrum [EMAIL PROTECTED]
<<image001.gif>>
