Bad performance from spGetResourceItemAttributesByTrustees
Last Updated June 04, 2019
The customer noticed that while trying to access Manage>Jobs and Tasks OR Manage>Computers>Jobs and Tasks middle frame, for example, it took too long to load and also caused a time out when they tried with different users who are in other security roles.
ITMS 8.5 RU2
According to the profiler, this is the process taking the most time:
Known issue. "spGetResourceItemAttributesByTrustees" stored procedure needed to be optimized in order to take advantage of the new "fnAC_HasFullScopeAccess" function added to the product to avoid excessive checks for permissions when using different security roles other than Symantec Administrators role.
This issue has been reported to the Symantec Development team. A fix is currently targeted for ITMS 8.5 RU3 release.
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe