Quick look at how much RAM is allocated to SQL Server?
17
votes
2
answers
86421
views
With SQL Server 2005, you could look at the Task Manager and, at least, get a cursory look at how much memory is allocated to SQL Server.
With SQL Server 2008, the Working Set or Commit Size never really goes above 500 MB, even though the SQLServer:Memory Manager/Total Server Memory (KB) perf counter states 16,732,760.
Is there a setting where it will actually show the server memory in the Task Manager? Or is it a result of them changing how memory is used in SQL Server
Asked by AngryHacker
(1961 rep)
Jul 16, 2012, 05:18 PM
Last activity: Mar 11, 2025, 08:49 PM
Last activity: Mar 11, 2025, 08:49 PM