- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- HP SIM database LARGE
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
тАО11-16-2005 08:45 AM
тАО11-16-2005 08:45 AM
Thanks.
Mike
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-16-2005 08:53 AM
тАО11-16-2005 08:53 AM
Re: HP SIM database LARGE
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-16-2005 02:46 PM
тАО11-16-2005 02:46 PM
Re: HP SIM database LARGE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-16-2005 08:51 PM
тАО11-16-2005 08:51 PM
Re: HP SIM database LARGE
OK...here is some more data:
notices table
969498 rows
163072KB
TrapData table
964333 rows
1385922KB
trapVarbinData table
964822 rows
277104KB
So, the row count on all of the tables looks consistent, it's just the size of the TrapData table that is way off.
Are there any best practices SIM tasks or SQL processes I should be running to get keep this under control? Is almost 1,000,000 rows too many or normal? My database file is now 2,000,000KB so we're creeping up on the 2GB MSDE limit.
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2005 12:38 AM
тАО11-17-2005 12:38 AM
Re: HP SIM database LARGE
My resolution was to manually back-up the database, de-install insight manager, de-install SQL server. Re-install SQL server, re-install Insight Manager then import the data from the back-up into the new database.
Now, I can run maintainence plans on the database and keep the database files at a manageable level.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2005 01:14 AM
тАО11-17-2005 01:14 AM
SolutionYou also need to investigate the source of the event storm that caused SIM to receive the 1,000,000 traps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2005 02:28 AM
тАО11-17-2005 02:28 AM
Re: HP SIM database LARGE
I think the size the SIM DB (Insight_v50_0_xxxxxxxxx.mdf and Insight_v50_0_xxxxxxxxx.ldf) will grow to is more a function of how it is configured and managed via MSSQL than how many systems or events are in the DB.
We are currently monitoring 500+ devices (450+ servers and 50+ other) and have almost 60,000 events. Our total DB size is less than 400 MB.
If you are running the HP SIM DB on MSSQL (or any other DB application) you should be doing routine backups of the DB. We currently have a Database Maintenance Plan for the HP SIM DB which does daily Optimizations, Integrity Checks, and Complete Backups of the DB, but no Transaction Log Backups.
Please note that we have the Recovery Model for the DB set to Simple.
It is my understanding that, although the DB still uses the transaction log (*.ldf), the daily full backup of the DB with the Recovery Model set to simple will create a backup file (*.bak) of the DB which includes all data in the DB file (*.mdf) and transaction log file (*.ldf) at the time of the backup.
If you do this, the size of the DB should not grow too large. Depending upon how you may need to recover the DB in the event of corruption, loss of data, or something else, you may need to choose a different Recovery Model. That in turn may affect the size of you DB and Transaction Log files.
I do not believe that any of the HP SIM documentation addresses any of these issues. I had to talk to one of our true DBAs for help getting this set up correctly. I would recommend the same if there is someone that can help you, or do some research on your own on how to manage MSSQL DBs.
I also think it would be helpful for HP to provide some general guidelines on how to manage HP SIM DB, specifically regarding configuration, size, backup, and recovery.
Pete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2005 04:17 PM
тАО11-17-2005 04:17 PM
Re: HP SIM database LARGE
Am I missing this, or is there a way to create this event collection so it gives me anything older than 3 months? All I came up with was one that was older than a specific event time.
Thanks again for your help. For those of you scoring at home, don't forget to shrink your SQL database in order to actually recover file space.
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2005 05:01 PM
тАО11-17-2005 05:01 PM
Re: HP SIM database LARGE
Thanks again for all your help.
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-22-2005 10:38 AM
тАО11-22-2005 10:38 AM
Re: HP SIM database LARGE
996000 Link Up and Link Down events from when we installed the new HP switches a few months ago. I finally found help and turned off those two traps even though I thought I set the switches to not send them. Regardless...the HP SIM database is down from 2GB to 85MB now. Oh, and it took about 5 days to clear out all of the events because I was still fighting off new events while the traps were still on.
I do want to thank you though because I learned a lot about event customization and the clear/delete event functions. And you helped solve my problem!
Mike