Don't confuse reporting and ddmdb.
Both do contain a event table, but the first is growing a lot bigger than the latter, as the events are aging out in the ddmdb due to the max_event_day setting. The same is true for the statistical data (max_stat_days), but statistical logging is disabled by default in 8.1 (I think the log poll ratio was changed to zero). If you are still logging data (and not using the data in the ddmdb) - you are wasting resources. However as the reporting database is on the OneClick server and the ddmdb on the Spectroserver they will only use the same resources if both are on the same machine. Hope that clarifies things a bit. Cheers, Joern Joern Henrichs Senior System Engineer Customer Support Group Phone: +49 69 97779 342, Fax: +49 69 97779 110, Mobil: +49 173 2946155 Email: [EMAIL PROTECTED] Voltastr. 1, 60486 Frankfurt am Main, Germany Computacenter AG & Co. oHG, mit Sitz in Kerpen (Amtsgericht Köln HRA 18096) Vertretungsberechtigte Gesellschafter: Computacenter Aktiengesellschaft, mit Sitz in Köln (Amtsgericht Köln HRB 28384) Vorstand: Oliver Tuszik (Vorsitzender), Hans-Georg Freitag, Frank Kottmann Aufsichtsrat: Michael Norris (Vorsitzender) Computacenter Management GmbH, mit Sitz in Köln (Amtsgericht Köln HRB 28284) Geschäftsführer: Dr. Karsten Freihube, Hans-Georg Freitag, Ulrich Irnich, Frank Kottmann, Reiner Louis, Jürgen Stauber, Oliver Tuszik Visit us on the Internet: http://www.computacenter.de Visit our Online-Shop: https://shop.computacenter.de This email is confidential. If you are not the intended recipient, you must not disclose or use the information contained in it. If you have received this mail in error, please tell us immediately by return email and delete the document. "Wilkerson, Mitch" <mitch.wilkerson@ To its.nc.gov> "spectrum" <[email protected]> 10.10.2008 12:36 cc Subject Please respond to RE: [spectrum] Reporting Database "Wilkerson, Size Estimates Mitch" <mitch.wilkerson@ its.nc.gov> We’ve taken this approach w/Spectrum as we use other tools for monitoring performance… It will greatly improve Spectrum’s performance and provide greater capacity for devices (against CA’s recommendation) You can still poll statistics as you want with watches. Thank You, Mitchell Wilkerson Networking Specialist NC Office of Information Technology Services 919-754-6120 (Embedded image moved to file: pic09081.jpg) ***************************************************************** * E-mail correspondence to and from this address may be subject * * to the North Carolina Public Records Law and may be disclosed * * to third parties by an authorized state official. * ***************************************************************** 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 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. (Embedded image moved to file: pic22195.gif) Roberth Edberg Adaptive Systems Architect SEB / Group IT Web: http://www.seb.se Systems E-mail: [EMAIL PROTECTED] Management Rissneleden 110 Voice: +46 8 639 30 42 SE-106 40 Mobile: +46 70 509 30 42 Stockholm 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] --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]
<<attachment: pic09081.jpg>>
<<attachment: pic22195.gif>>
