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.
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.
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.
Log onto the SMP with the Application Identity.
Extract the contents of the point-fix PF to the local drive of the Symantec Management Platform server.