Out of the blue my server started to have the sqlservr.exe process take a huge chunk of my memory. It's taking 31 out of 32 gb. We only have a couple very small databases, why in the world out of the blue would it start taking so much memory? It's causing our server to freeze up.
After stopping the process it goes back down to normal. But I need to fix it so we can run it again.