How can I merge a large amount of QOS data?

Document ID : KB000072808
Last Modified Date : 08/03/2018
Show Technical Document Details
Introduction:
Sometimes customers have the need to bulk merge large amounts of QOS and the SLM portlet will not scale sufficiently to accommodate this scale of administration.
Question:
How can I merge a large amount of QOS data?
Environment:
- UIM, any version
- Microsoft SQL Server 2005 or higher
Answer:

WARNING: USE AT YOUR OWN RISK!!!

Perform a backup before changing any data and confirm the backup was successful!!! 

These scripts are only offered up as examples/samples and must be edited to suit your needs and your environment! We recommend that you test them in a Test environment first before executing them. Test them on a small data set to test the results.

You must exercise caution if you decide to execute a bulk merge operation.

We recommend that you consult with your DBA or the individual who maintains the UIM database before modifying/executing any of the sample scripts included in this Article.

See attachments for Sample SP/Scripts (zip file).

 

If you are only merging a small amount of data for a few QOS objects, you can use the SLM portlet and use the Merge operation.
User-added image

User-added image

 

Notes:

- UIM doesn't support merging data/rows for different QoS types. They must be the same.

 - You can check the QOS data first that you are considering merging by hovering in the QoS column and selecting the black arrow and choosing Get Statistics while you have the QoS rows selected via the checkbox as shown above.

As an example, in the SLM portlet in UMP under Tools->Database Status, is the QoS data for a given QOS object such as QOS_CPU_USAGE_PERC, listed for both the short hostname and FQDN/longname?

If so, select the entries and use the drop down box (black arrow) to Get Statistics and see which QoS has the most current data (Last sample)

If one of the entries shows current data and the other one doesn't you can either delete the old QoS, or MERGE it in the direction to where it is currently being saved so then it will all show up in your reports/charts once merged.

Differences between QOS saved under a short vs long name source or even different targets, can affect its ability to be properly displayed in UMP/USM.

File Attachments:
Merging QoS.zip