Loading or saving Software Products can be very slow or never fully load or save

Products

• IT Management Suite

Issue/Introduction

When you try to save a new Software Product, or when trying to load an existing, it can take a long time to load. It can also stop loading and never finish.

Cause

The problem originates from SQL Query Optimizer. This is the component that looks for query work that is not needed for the results of the query and excludes it. The join we do to vComputer includes the AeX AC TCPIP table. The IP data is not needed in the results, but SQL is running through the full capture of that data, including doing a TOP query to get the prominent IP Address of each system. SQL should be excluding this work, but it is not. 99.9% of the time, Query Optimizer does its job and excludes unnecessary querying.

Resolution

To avoid the issue, Development has created a PF that bypasses the need to query the TCPIP table, thus avoiding the SQL Query Optimizer issue.

Filename: ECV_8_1_POST_RU7_v1_13Aug.zip

1. Log onto the SMP with the Application Identity.
2. Extract the contents of the point-fix PF to the local drive of the Symantec Management Platform server.
3. Execute PFInstaller2.exe and choose to Install.