1748169 Members
4321 Online
108758 Solutions
New Discussion юеВ

Re: How to shrink perf_db

 
fritzah
Occasional Advisor

How to shrink perf_db

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

7 REPLIES 7
LindsayHill
Honored Contributor

Re: How to shrink perf_db

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.

FranoM
Advisor

Re: How to shrink perf_db

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

fritzah
Occasional Advisor

Re: How to shrink perf_db

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

fritzah
Occasional Advisor

Re: How to shrink perf_db

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.

LindsayHill
Honored Contributor

Re: How to shrink perf_db

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.
MichaelM55
Trusted Contributor

Re: How to shrink perf_db

Hi,

 

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

Riborg
Advisor

Re: How to shrink perf_db

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.