Hi James,
We were having significant memory issues with our SQL server usage back when we were on 10.1.600.5 that have completely gone away in our patch to 10.1.600.20.
We never could figure out why our test database with no user in it was running at like 80%-90% usage. Then our production was frequently getting up to 95% usage and then people opening programs with large customizations were having difficulties and we’d do a reboot of the server. We found we had to take away other instances of our database from developing (i.e., test2, training) to reduce SQL server usage. It was pretty irritating as it’s a completely new server with install back in August 2018. The (Epicor platinum partner) consultant who did the install and migration couldn’t see anything wrong with it either.
Since new patch it’s completely gone.
I saw this fella’s post and it made me think of our issue and perhaps the suggestions in the exchange might help you too.
Nancy