I am facing a critical issue that our server sometime will be out of memory and some process will be auto killed. Here is what happened recently.
And more wired thing is, after I add the server back and re-balance servers, all my indexes on that particular server will stop working. Any query with index on that server will return empty result. I have to rebuild all the indexes to make it work again.
Is there someone else experiencing this? Any solution or workaround?