Latest Discussions. The best way to see how much memory your SQL server really need use perfmon: Before reducing the max server memory value, use Performance Monitor to examine the SQLServer:Buffer Manager performance object while under a load, and note the current values of the Stolen pages and Reserved pages counters. Looking for product roadmap webcasts, technical sessions, user group meetings, conferences, and workshops? SQL Server has to be limited in memory usage as best practice first. Log in now.
nest...