Hi All,
From time to time I check the My Orion Deployment - Deployment Health page and one that always seems to haunt my environment seems to be:
Check Query Performance.
While I don't experience a really slow environment (We've done a lot already regarding the performance of our environment). I don't really like to see the message, which might indicate something is not working how it's supposed to work.
Some pollers show the check as "Problem" while a few show it as a "Potential issue"
For example a "Problem":
Executing the following database query took more than threshold for this query (500 ms): Query 'SELECT * FROM Nodes' returned 9005 row(s) in (Avg=606, Min=601, Max=609) ms. Executing the following database query took more than threshold for this query (500 ms): Query 'SELECT * FROM Pollers' returned 257193 row(s) in (Avg=765, Min=739, Max=838) ms. Query 'SELECT TOP 1 * FROM Engines' returned 1 row(s) in (Avg=3, Min=2, Max=5) ms
Example of "Potential problem":
Executing the following database query took more than threshold for this query (300 ms): Query 'SELECT * FROM Nodes' returned 9005 row(s) in (Avg=461, Min=435, Max=499) ms. Executing the following database query took more than threshold for this query (500 ms): Query 'SELECT * FROM Pollers' returned 257193 row(s) in (Avg=528, Min=512, Max=550) ms. Query 'SELECT TOP 1 * FROM Engines' returned 1 row(s) in (Avg=1, Min=0, Max=2) ms.
We're running our SQL on an 8 Core 3,2Ghz with 128GB RAM. The environment has 4 modules and at this moment we have around 9000 nodes.
Has anyone else have some experience with this issue or knows how to resolve it?
