does anybody know is it possible to find which SQL query is running under Foglight specific rule?
I am looking for SQL query unde the DBO-Latch Free
The internal logic and code of the collections used by the Foglight database cartridges are considered proprietary. I would recommend opening a Service Request with Quest Support if you have a specific question about a query or if there is an issue with a collection and a Support Engineer may be able to assist.
when looking at the DB Deployment Guide you will see which views we access - look at here:
Your DBAs are saying that there is a query which should not run. Which query is it? Please compare if the query is running against one of the listed views in the deployment guide.
If you want you can raise an SR and we can check if Foglight is working incorrectly.