- Community Home
- >
- Networking
- >
- IMC
- >
- Re: How to shrink perf_db
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2013 08:27 PM
тАО01-24-2013 08:27 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2013 09:39 PM
тАО01-24-2013 09:39 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2013 11:45 PM
тАО01-24-2013 11:45 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-25-2013 08:26 AM
тАО01-25-2013 08:26 AM
Re: How to shrink perf_db
Thank you very much for all of your help on my issues. I will try your responses.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-28-2013 06:26 AM
тАО01-28-2013 06:26 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2013 12:09 PM
тАО01-29-2013 12:09 PM
Re: How to shrink perf_db
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2013 11:03 AM
тАО04-24-2013 11:03 AM
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)?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2016 11:53 PM
тАО01-20-2016 11:53 PM
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.