Details
-
Improvement
-
Resolution: Unresolved
-
Major
-
None
-
None
-
1
Description
4) Available/used processes/threads for all services (updating indexes, scanning indexes, garbage collection etc.,)
Why? This is a refinement of the point above, because they seem to have some latency on index nodes that is currently unexplained (like everyday at 3PM)._
_Also, it would help understand which processes are causing a contention on this limited resource, and whether it’s worth (re)moving an index, using a covering index or not, what’s the cost of updating indexes, scanning them, having more or fewer buckets, etc.