Yup have a look in $SPECROOT/mysql/data/reporting (if memory serves) You should have lots of MySQL tables in there, most of which are sensibly sized, then you'll have EVENTS.MDB which will be bigger than Kanye West's ego.
If you keep defaults set on SRM and have a particularly "noisy" network you will find that EVENTS.MDB and the associated log/lookup index thing will often go into several 10's of GB. If you don't keep an eye on it, it can get really unwieldy and the only way to fix it is to run "TRUNCATE TABLE EVENTS" on the MySQL command prompt. Which will lose your historical event data and get you back a shed-load of disk space. You can also set SRM to record most stuff but NOT events if you want, due to the size the tables get to which is why there's a separate check box for events on each landscape being processed by SRM. Also keep those tables in mind when you're planning major release upgrades if there's a change in DB table format as there was recently. You'll need at least the same amount again in free space for the conversion process to work, and obviously the larger the tables, the longer the upgrade process takes. For speed of deployment against historic event availability, it may be wise to just zero out the events database before a major upgrade and take the hit. Dave David K. Game Consultant - Infrastructure Management Systems Logicalis UK Ltd +44 (0) 7967 464365 +44 (0) 1753 560553 / 777363 +1 646 797 3283 sip:david.g...@uk.logicalis.com david.g...@uk.logicalis.com DKGame __________________________________________________________________ -----Original Message----- From: Franck, Raphael [mailto:raphael.fra...@computacenter.com] Sent: 18 March 2015 08:13 To: spectrum Subject: AW: [spectrum] Server Size Hi Kenneth, following up Jason's statement, the Spectrum Report Manager actually consists of two parts. First one is the SRM data gathering and processing logic inside tomcat which uses the mysql instance on the OneClick server, where the SRM component was installed. Secondly the CABI reporting engine may be installed on the same or separate machine, is based on SAP Business Objects and just accessing the data within the reporting db. Having said that, you might just look for the ${SPECROOT}/mysql/data directory. Regarding the SpectroSERVER machines Jason was most likely referring to the SSdb backups, which typically reside within ${SPECROOT}/SS-DB-Backup. Spectrum does no cleaning up there so you have take care for removing old database backup files. Mit freundlichen Gruessen - Yours sincerely Raphael Franck Consultant Global Infrastructure Operations Computacenter AG & Co oHG Enabling Users Europaring 34-40, 50170 Kerpen, Germany E-Mail: raphael.fra...@computacenter.com WWW: www.computacenter.de -----Ursprüngliche Nachricht----- Von: Kenneth Kirchner [mailto:k...@kirchners.com] Gesendet: Mittwoch, 18. März 2015 05:48 An: spectrum Betreff: Re: [spectrum] Server Size I will give the file system a look over and see where that space is going. I was just under the impression that OneClick was the Java web server piece of Spectrum and as such, should not be warehousing any data. That should all be on the Spectro servers. If that is the case, I would expect the OneClick to be much less in size than the Spectro boxes (assuming there is no reporting or debug logging going on). Thanks again! -Ken > On Mar 17, 2015, at 9:30 PM, Jason Hebron <jason.heb...@gmail.com> wrote: > > Hi > 90Gb is definitely space for the Poller By nodes yes per device > polled, though CA define a node as a device with up to 200 interfaces > - so if you have a network device with 600 interfaces that counts as 3 > nodes As far as the cruft :-) building up - if its unix just start > tracking where the badness is happening start at root and use the > command du -hc --max-depth=1 This shows disk space use per directory - > start drilling down the directory paths to find where the "cruft" is > One thing I have seen - core dumps created on app crashes can build up > excessively - so that may be a culprit if you have disk bloat Another > can be someone turning on debugging in the spectrum logs and > forgetting to turn it off again As far as Report Manager goes - yes > its a seperate product but still makes use of some components of > OneClick You can tell if the oneclick part is enabled if you check the > <$spectrum>\mysql\data\reporting and find the reporting dir is full of > info MEans that even if Cabi is not installed the data is being > recorded > --- To unsubscribe from spectrum, send email to lists...@unc.edu with the body: unsubscribe spectrum raphael.fra...@computacenter.com --- To unsubscribe from spectrum, send email to lists...@unc.edu with the body: unsubscribe spectrum david.g...@uk.logicalis.com Please be aware that Logicalis UK Ltd may monitor email traffic data and also email content for security purposes. ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________ This email communication does not create or vary any contractual relationship between Logicalis and you. Internet communications are not secure and accordingly Logicalis does not accept any legal liability for the contents of this message. The contents of this email are confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to or used by anyone other than this addressee, nor may it be copied in any way. If received in error, please contact Logicalis on the above switchboard number quoting the name of the sender and the addressee and then delete it from your system. Please note that neither Logicalis nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Please be aware that Logicalis UK Ltd may monitor email traffic data and also email content for security purposes. Logicalis UK Ltd, Registered in England and Wales No: 3732397, Registered Office: 110 Buckingham Avenue, Slough. Berkshire, SL1 4PF ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________ --- To unsubscribe from spectrum, send email to lists...@unc.edu with the body: unsubscribe spectrum arch...@mail-archive.com
