High notification thread latency in Spectrum during RESTful queries
Article ID: 113584
REST queries used for Discoveries to seed a CMDB database is causing high impact on performance to SpectroSERVER. During the period of the seed, SpectroSERVER gets so busy it cannot even poll. This last for some time and occurs consistently. What is happening?
Release: Component: SPCCSS
In this case the cause is the attribute 0x129fa used for the seeding tool. In older 9.4 environment, attribute 0x129fa Model Type ID was querying a range of model types, but is an inefficient query. Now in Spectrum 10 with a much larger environment, this attribute is heavily impacting the performance during the seeding tool running.
This attribute query is no longer needed for Spectrum 10.2.3 environment. Remove the rest calls using this attribute and the performance of SpectroSERVER should improve.
While this issue is caused by a specific attribute query, this type of issue can occur on other inefficient searches as well. Typically searches against external attributes which need to poll devices will cause much higher latency than querying internal attributes.
Spectrum has several internal attributes which store external attributes polled. For example,