July 17, 2009 at 1:21 pm
Hi,
I have SQL Server 2005 SE installed on Windows Server 2003. Currently the OS Server has 4G or RAM. When I run PerfMon on the server I have following values:
SQLServer:Memory Manager - Target Server Memory = 1595968
SQLServer:Memory Manager - Total Server Memory = 1595968
I enabled AWE switch and set Max Server Memory to 2048 MB
Why does the Total Server Memory counter shows 1.5G instead of anywhere around 2G?
What can I do to increase it?
Any help will be really appreciated.
Thanks,
SK
July 17, 2009 at 1:35 pm
Keep in mind that even though SQL may have access to more memory it may not use it. The standard edition can access that much memory given AWE. How big are the tables, how much data does the queries look at, is that 1.5GB number after a period of time that the server is running or fairly close to start.. I have had servers running a process that even with 10GB of memory will never make the server use more than 1GB, it simply doesn't need it..
CEWII
July 17, 2009 at 1:59 pm
Thanks for your reply. There are around 10 tables out of 90+ tables that gets used frequently, out of which 3 tables have 3+Million rows with data size averaging 500MB. Database size is currently 8+ Gig. So not that big. This is OLTP datbase. We are having some sluggish performance lately.
I know SQL Server 2005 uses Dynamic memory allocation and etc. But I was just curious if I can make more memory available to SQL Server, so Target Memory (which is Memory SQL Server would like to use) ideally can be made less than the Total Server Memory?
Which perfmon counter tells me that SQL Server has 2G available memory to work on?
July 19, 2009 at 9:12 pm
I have to admit, I don't know that without doing some research..
CEWII
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply