Summary
Using ServiceManager 7.X, there is an extremely slow response in web service requests to Config module. Using the same request in ServiceCenter 6.2 is much faster. Our Development staff is working on this issue under QCR52548. There is a workaround provided.
Question
We have a web services based integration that pulls CI information out of Service Manager 7. Since our upgrade from SC 6.2 to SM 7 the performance has been extremely poor.
Our config module currently has only 8600 records and yet to get a dump of all the records via web services it takes well over 10 minutes. From our testing across our environments it is taking about 7-8 records per second. We find this stat to hold true even when we limit the query to only pull back a subset of CIs (such as of a certain type). Response time was significantly better under SC 6.2.
RTE: 7.01.053
App: SM7
Server OS: Win 2003
RDBMS: Oracle 10g
Does HP have any general guidelines/benchmarking on what is "normal" wait time for a web services request/response?
Our config module currently has only 8600 records and yet to get a dump of all the records via web services it takes well over 10 minutes. From our testing across our environments it is taking about 7-8 records per second. We find this stat to hold true even when we limit the query to only pull back a subset of CIs (such as of a certain type). Response time was significantly better under SC 6.2.
RTE: 7.01.053
App: SM7
Server OS: Win 2003
RDBMS: Oracle 10g
Does HP have any general guidelines/benchmarking on what is "normal" wait time for a web services request/response?
Answer
Our Development staff is working on this issue under QCR52548.
Workaround:
1. Add the following parm to your sm.ini file: dbcachequery:extaccess
2. Recycle ServiceManager
3. Test your webservices scenarios.
What the parm does is it caches any query that is run against the file specified.