There are few different locations and pickers in the Symantec Management Platform Console that end up using the stored procedure spResourceSearchSelectProviderByResourceType. In some environments this can experience poor performance.
A couple of the locations that have been noted are:
There are no specific error messages however some of the symptoms that have been noticed are:
This can be made worse by having a large number of resources, roles, or localization strings on a system
This has been addressed in Hot Fix 6.
For all versions of 7.5 and also 7.6 through Hot Fix 5, The attached version can be used.
Run the code in SQL Management studio against the Symantec_CMDB or custom named database. This will replace the old version of the stored procedure with the new one.