Queries cache in Enterprise Managers

Products

• CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

Request to know if there is a way to configure queries cache in the Enterprise Managers.

There are some integrations to the EM webservice API and sometimes different users access to the same data.

It would be good that the EM doesn't have to get again the data from disk.

Environment

Release : 10.7.0

Component : Introscope

Cause

There is an in-memory cache of the last 8 minutes of data but the results of queries are not cached

Resolution

There is an in-memory cache of the last 8 minutes of live data (can be increased through configuration) but the results of queries are not cached

Additional Information

For performance reasons, it is advised to use the SQL REST API instead of the older SOAP-based web services

New APM architecture from version 20.2 exposes direct metric query endpoints on NASS which will provide even better performance.