I concur. I have a global client which generates 1,000,000 events per day (yes, that is one million events)
They have to optimize the DDM and perform DDM maintenance at least once a week, and we had to reduce their DDM retention period from 45 days to 30 days. *nix cron or Windows Scheduler is sufficient for this optimization and maintenance task. Regular optimization of the DDM is definitely necessary to avoid DDM corruption... also, without regular DDM optimization, Events tabs in OneClick will start to load very slowly. This is usually the first hint of trouble. Watch the number of events that are logged too, since you will make more work for Spectrum to store (and later purge) excess events. Use ECEditor to turn off logging for any events that you don't really care about. One of my favorites to shut off are SNMP Auth failure events. In later versions of 8.1 and in 9.x, there is a model named SSPerformance which shows many SS metrics, including the number of events logged since restart. SSPerformance logs data to a memory buffer every 10 seconds for the last 2 hours. You can increase the retention interval to a greater number of hours (24?) if you have enough memory available on the SpectroServer; if you adjust this, add 1 hour of history at a time, and watch how your SpectroServer process memory grows. You can export this data from OneClick, and pull it into your favorite spreadsheet program to make charts of various Spectrum metrics over time. HTH, --Mark S ________________________________ Mark Serencha - Inforonics LLC - (m) +1-781-439-0519 - [email protected] <mailto:[email protected]> - ** Inforonics acquires Vigilant Enterprise Solutions ** <blocked::http://www.businesswire.com/portal/site/home/permalink/?ndmVie wId=news_view&newsId=20090818005912&newsLang=en> From: Barnes, William [mailto:[email protected]] Sent: Wednesday, January 20, 2010 3:48 PM To: spectrum Cc: Merih Gulseven (Garanti Teknoloji); Baris Dokgoz (Garanti Teknoloji) Subject: Re: [spectrum] Ddm_load -i takes very long time My guess is that you are running into data corruption. We have that issue frequently on the Archive Manager's event tables. Usually when we have problems with connections to ArchMgr, all we have to do is to go to the ${SPECROOT}/SS/DDM/scripts directory and run the optimize.pl script. It will take a long time to run, but after it fixes the event table corruption, the ArchMgr is much happier. Our plans are to start scheduling the optimize.pl and the maintenance.pl scripts to run weekly through cron. We are hoping that will help keep things cleaner. Bill Barnes Sr Engineer Comcast ________________________________ From: "Cihan Subasi (Garanti Teknoloji)" <[email protected]> Reply-To: "Cihan Subasi (Garanti Teknoloji)" <[email protected]> Date: Fri, 15 Jan 2010 11:03:46 +0200 To: spectrum <[email protected]> Cc: "Merih Gulseven (Garanti Teknoloji)" <[email protected]>, "Baris Dokgoz (Garanti Teknoloji)" <[email protected]> Subject: [spectrum] Ddm_load -i takes very long time Hi, We have an issue for a long time with initializing the DDM. Every 40-45 days the servers starts saying that it is loosing connection to ArchiveManager and when we see that we save and load the ddm. We are on 8.1 version and ddm_load -i takes almost forewer and many attempts to be successfull at the end. I have other servers and ddm_load -i takes few minutes maybe not, but on my main locat,ons server initialization takes hours...How can we imporve the initialization what what should do for to improve DDM and SS performance (best practice)? Thank you for your supports and helps, This message and attachments are confidential and intended solely for the individual(s) stated in this message. If you received this message although you are not the addressee, you are responsible to keep the message confidential. The sender has no responsibility for the accuracy or correctness of the information in the message and its attachments. Our company shall have no liability for any changes or late receiving, loss of integrity and confidentiality, viruses and any damages caused in anyway to your computer system. Bu mesaj ve ekleri, mesajda gonderildigi belirtilen kisi/kisilere ozeldir ve gizlidir. Bu mesajin muhatabi olmamaniza ragmen tarafiniza ulasmis olmasi halinde mesaj iceriginin gizliligi ve bu gizlilik yukumlulugune uyulmasi zorunlulugu tarafiniz icin de soz konusudur. Mesaj ve eklerinde yer alan bilgilerin dogrulugu ve guncelligi konusunda gonderenin ya da sirketimizin herhangi bir sorumlulugu bulunmamaktadir. Sirketimiz mesajin ve bilgilerinin size degisiklige ugrayarak veya gec ulasmasindan, butunlugunun ve gizliliginin korunamamasindan, virus icermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan sorumlu tutulamaz. * --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]
