Slow Search for Service Item in IT Shop (4345134)

Slow Search for Service Item in IT Shop

When performing a search for service item in IT Shop (Service Catalog | Request | Find a service item) the search takes from 1.5 to 2 minutes to return results.

Defect ID 27017.  This is a performance issue with the function, QER_FGIPWOOrderPerson.  E.g.:

(22244 ms) - select dbo.QER_FGIPWOOrderPerson(@uidperson, null, @uidaccproduct, null, null)

WORKAROUND

Reviewing database performance, specifically with regards to I/O, is important.  Review the results from select * from qbmvsystemoverview for actual and recommended values, including minimum requirements for CPU and memory, as well as read/write times.

STATUS

Performance issues are addressed in both Service Pack 1 (7.1.1) and Service Pack 2 (7.1.2), both available here.  This issue is addressed in SP1.  A hotfix can also be requested from Support.

27017