January 29, 2009 at 2:13 pm
We have sql server 2005 standard edition 64 bit on Windows 2003 Enterprise sp 2 64 bit. The server has 16 GB of memory and has 2 databases on it; 1 5 gb in size and 1 in 3 gb in size. The databases only support read only operations.
The server is allowed to manage its own memory and Sql Server usually takes up 14-15 GB. What I don't understand is why Sql Server would be using so much memory considering the database are so small.
Any ideas on dynamic management views or performance monitor counters that would help me figure out why Sql Server is using so much memory?
January 29, 2009 at 2:26 pm
check your permon and look for target vs total. Target memory is amount of memory sql server can use while Total memory is amount of memory sql server is using.
sql will grab all memory it can, when the OS needs some memory the SQL OS will give it back. you can limit the max memory setting if needed.
chances are it is working just as it it suppose to
January 29, 2009 at 3:34 pm
I can see Sql Server grabbing all the memory it can. What I was specifically looking for was a way to determine what it was doing with it. With the amount of memory it is consuming Sql Server could store the entire database in memory twice over. It is assuredly not doing that so what exactly is it storing in memory?
January 30, 2009 at 3:43 am
It's not as simple as that, and I'd seriously think about setting max memory for sql server to leave adequate space for the o/s. You may find with that level of memory use you have a lot of paging ( but it just depends )
If you look on my website/blog I have some rdls you can download which will graphically show buffer and proc cache memory use by database. There's also one which will show objects in buffer cache. You'll probably find tempdb has most of the memory.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 30, 2009 at 6:40 am
you can look up dbcc memorystatus or the sys.dm_os_memory_clerks for the buffer pool to see for what the memory is used for
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply