Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

Transform performance issues when running vCenter Server collections (2044854)

Symptoms

When running vCenter Server collections:
  • Jobs run for an extended period of time
  • Transform operations take multiple hours

Purpose

This article provides scripts to resolve some common issues that arise when running vCenter Server collections:
  • Transform failures
  • Transform performance
  • Heartbeat job performance
  • Jobs stuck in the jobs running screen
  • Raw database recreate issues
  • Transform string truncation errors
  • Transform operations taking multiple hours

Resolution

To resolve this issue, download and run the attached .sql file for your version of VMware vCenter Configuration Manager (vCM) to address the transform performance issue.

Note: The provided scripts only apply to transform performance issues encountered with vCenter Configuration Manager 5.5.x and 5.6.

To download and run the .sql file:

Caution: The script makes direct modifications to the vCenter Configuration Manager database. Ensure you have a current and valid backup of the database before following these steps.

  1. Download the .sql file attached to this article for your version of VMware vCenter Configuration Manager:

    • For VMware vCenter Configuration Manager 5.6:

      vCMTransformPerformance_5.6.sql

    • For VMware vCenter Configuration Manager 5.5.x:

      vCMTransformPerformance_5.5.x.sql

  2. Save the .sql file to a location accessible to your SQL Server instance.
  3. On the machine running SQL Server, start Microsoft SQL Server Management Studio.
  4. In the Server name dropdown, select the SQL server instance on which the vCM database runs.
  5. In the Authentication dropdown, select an account:

    • Select Windows Authentication if you are logged into the machine with a Windows account that has permission to modify the vCM database.
    • Select an account that allows you to start Management Studio with system administrator permissions to modify the vCM database.

  6. Click Connect.
  7. In the Object Explorer pane, expand Databases and select your vCM database.
  8. Click File > Open > File.
  9. Browse to the location of the .sql file, then select the file and click Open.
  10. To run the script displayed in the right pane, click Execute.

    The status of the process appears below the script.

Attachments

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 2 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
  • 2 Ratings
Actions
KB: