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
IMC
cancel
Showing results for 
Search instead for 
Did you mean: 

[IMC 7.0] deleting old performance data (MS SQL + perf_db)

 
SOLVED
Go to solution
MichaelM55
Trusted Contributor

[IMC 7.0] deleting old performance data (MS SQL + perf_db)

 

So I´m stuck on Microsoft SQL Express edition (which is another topic). I did a database backup within IMC and now I´m ready to delete all performance data which is older than three months from perf_db. How to do this correctly?

 

  1. Let´s use the GUI. Well, there´s no possibility to do so?
  2. idea. Let´s start from beginning. Many monitors haven´t been that important, so export all devices from IMC, delete them afterwards and import that list again. So I can use new default monitor instances. Hopefully all performance data is gone afterwards? (Downside, it seems I cannot rescue my topology map?)
  3. use sqlcmd
sqlcmd

use perf_DB
go

sp_help
go

 

   => Well, many tables. Which one should I "truncate" or "DELETE FROM"?

 

 

3 REPLIES
LindsayHill
Honored Contributor

Re: [IMC 7.0] deleting old performance data (MS SQL + perf_db)

You can delete performance data on a per-device basis from the GUI. That will be slow if you need to do it for a lot of devices though.

 

Do you have API access? (Either through IMC Enterprise, or with the API license). There might be an API call for deleting performance data on a per-device basis. That would make it faster for scripting.

 

I'd be wary of manipulating the database directly. I have done it for a few things, but not for performance data. Try taking a look at the various tables - the names are usually meaningful.

LindsayHill
Honored Contributor
Solution

Re: [IMC 7.0] deleting old performance data (MS SQL + perf_db)

Oh and yes, deleting/re-adding devices should delete all old performance data.
MichaelM55
Trusted Contributor

Re: [IMC 7.0] deleting old performance data (MS SQL + perf_db)

Well, no Enterprise, no API. Seems deleting and reimporting would be the best choice for me. Thanks!