One of the important roles operations has is going to an existing server and checking if everything is fine. This is routine maintenance stuff. It can be things like checking if we have enough disk space for our expected growth, or if we don’t have too many indexes.
Here is some data from this blog’s production system:
Note that we have the squeeze button, for when you need to squeeze every bit of perf out of the system. Let us see what happens when I click it (I used a different production db, because this one was already optimized).
Here is what we get:
You can see that RavenDB suggest that we’ll merge indexes, so we can reduce the overall number of indexes we have.
We can also see recommendations for deleting unused indexes in general.
The idea is that we keep track of those stats and allow you to make decisions based on those stats. So you don’t have to go by gut feeling or guesses.