topic Re: How to shrink perf_db in IMC

How to shrink perf_db

fritzah — Fri, 25 Jan 2013 04:27:28 GMT

Perf_db is 9780.28MB, I have tried to shrink it in MSSql, by right clicking on it in MS sql managment studio and going to -> task->shrink->database but it doesn't seem to get smaller. Any help would be appreciated. Recently deleted all switches to sort of start over and maybe there is a way just to recreate a empty perf_db? Any assistance as usual would be greatly appreciated. Thank you.

Chris

Re: How to shrink perf_db

LindsayHill — Fri, 25 Jan 2013 05:39:17 GMT

I know you can clean the alarms DB using the procedure documented here: http://kontrolissues.net/2012/05/30/hp-imc-mass-recover-active-alarms/

Basically you stop imcfaultdm, run imcfaultdm.exe -clean, then restart it.

I tried mucking around with imcperfdm, to see if it supports something similar, but it doesn't so far as I know.

I would have thought that the data would have been freed up when you deleted those devices?

It is possible to delete all performance data for a specific device, but this can be slow.

I haven't yet worked out all the knobs and levers for configuring performance reporting/data rollup/cleanup/etc. Another thing to add to the list.

Re: How to shrink perf_db

FranoM — Fri, 25 Jan 2013 07:45:06 GMT

Hi,

In MSSQL DB/log file, to be able to schrink, you have to backup it before (that's the way the DB notify, OK it's safe to freeing some space). If my remembrances are good, the procedure depend on the recovery model of the DB... please check the doc.

May be an IMC specialist could give more information.

François

Re: How to shrink perf_db

fritzah — Fri, 25 Jan 2013 16:26:51 GMT

Thank you very much for all of your help on my issues. I will try your responses.

Re: How to shrink perf_db

fritzah — Mon, 28 Jan 2013 14:26:38 GMT

I tried the backup and shrink procedure but I it only shrank it by about 1GB. It must be due to the old information from the previous auto discovery. I need to find out how to purge that infomation, don't see how from the admin guide. Maybe someone has an idea, I will update if I can figure it out. Thank you.

Re: How to shrink perf_db

LindsayHill — Tue, 29 Jan 2013 20:09:20 GMT

Is it the log file, or the data file that is big? Shrinking the log file works after doing a backup, but if it's the data, you need to somehow purge the underlying data. I haven't figured out how to do that on a wide scale, only on a per-device basis.

Re: How to shrink perf_db

MichaelM55 — Wed, 24 Apr 2013 18:03:41 GMT

Hi,

just noticed today that the DB is now close to 10GB. Has someone figure out how can to purge old data (at once)?

Re: How to shrink perf_db

Riborg — Thu, 21 Jan 2016 07:53:05 GMT

I am also interested in this.

How do I shrink or purge "perf_db"?

I have a Linux installation with MySQL and also a Windows Server with MS SQL Enterprise.