Hello,
We've had performance issues with our server. We typically get 'insufficient resources' error and eventually wind up rebooting the server.
I've been trying to use perfmon to see what in SQL Server is not normal.
At this time Execution Contexts (SQL Server Cache Manager) is just over 4 billion. I've seen it below 1000 when the system was rebooted and monitored it for that day... no major fluxuation.
So at this point I've tried flushing caches per non-system DB and it doesn't seem to have an effect.
Any suggestions are greatly appreciated (aside from jumping off a bridge) 🙂
-Peter