HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

HP SIM MSDE Near 2GB Limit

 
kitan
Occasional Visitor

HP SIM MSDE Near 2GB Limit

our HP SIM database is nearing its 2GB limit. in looking around in the db, i see there's a table called TrapData that is over 1GB with 360K rows. is this normal? if not, can i prune some of this data or is there some HP provided tool to get the db back down to a more manageable size? sorry if basic question but i'm new to SIM...

thanks in advance
2 REPLIES
My_HP_user
Occasional Visitor

Re: HP SIM MSDE Near 2GB Limit

kitan,
If you are comfortable working in the SQL Server Management console you can go in and perform some maintenance on your database by shrinking the database. That will help compact and free up some space. If you keep hitting the 2GB limit then it may be time to migrate to a full SQL license.

There is no need to go into the tables to delete records. You can do that it the SIM interface - then shrink the database via the SQL Server management console.
Darrin Rawls
Respected Contributor

Re: HP SIM MSDE Near 2GB Limit

That means that you have a lot of old traps probably in HP SIM. I would create a Delete Events task that removes old events you aren't interested in any more. You can create a task that is tied to "All Cleared Events" and have it delete every 90 or 120 days. That way it won't delete any events you haven't cleared (i.e. acknowledged) and will clean up the event db.