December 28, 2006 at 10:04 am
Hi ,
i have 18 GB total memory for my Windows 2k3 x64 Bit server and 14 GB is configured for SQL Server , but it looks some memory issue with my SQL Server but unable to find the what is the exact memory is being consumed by my SQL Server currently out of 14 GB, any help will be much appretiated to find that.
Thanks
December 28, 2006 at 11:31 am
Consider watching these two counters: SQLServer:Memory Manager: Total Server Memory (KB) and SQLServer:Memory Manager: Target Server Memory (KB). The first counter, SQLServer:Memory Manager: Total Server Memory (KB), tells you how much the mssqlserver service is currently using. This includes the total of the buffers committed to the SQL Server BPool and the OS buffers of the type "OS in Use".
The second counter, SQLServer:Memory Manager: Target Server Memory (KB), tells you how much memory SQL Server would like to have in order to operate efficiently. This is based on the number of buffers reserved by SQL Server when it is first started up.
http://www.sql-server-performance.com/performance_monitor_counters_memory.asp
MohammedU
Microsoft SQL Server MVP
December 29, 2006 at 8:30 am
if you are using SP4 then there is a bug and you need to apply a patch - " If Address Windowing Extentions (AWE) support is enabled, a single instance of SQL Server 2000 can only use a maximum of 50 percent of the physical memory that is on the computer. "
check out this link - http://support.microsoft.com/default.aspx?kbid=899761 or Bug #: 474343
** What you see, Depends on what you Thought, Before, You looked! **
December 29, 2006 at 9:43 am
Thanks much Mohammed and Ross
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply