February 5, 2015 at 1:00 pm
I have a SQL Server 2012 on a Windows 2008 R2 Enterprise OS. I've been watching the memory via vSphere. First thing in the morning, Average Guest Memory starts at 5898 MB, then it will vary throughout the day with the following memory being used(all in MB): 10321, 15482, 18432, etc., with an occasional high of 28753. I've set the minimum memory to be 26624 and maximum at 60000, the server OS has 73728 MB of memory. The memory hardly ever hits the minimum I've set, it is always lower. No balloon memory has been used. Is this a normal function of memory usage in SQL Server? Why doesn't it stay at the minimum that is set? Thanks in advance for any comments.
February 5, 2015 at 2:47 pm
What size data is being accessed? If you have (or only access) small amounts of data then SQL Server will not acquire more memory than it needs.
Try dbcc memorystatus to get a lot of useful information about memory consumption. You can find info on that online.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 5, 2015 at 2:54 pm
284 GB including the ldf. mdf by itself is 252 GB
February 5, 2015 at 3:01 pm
1) what is max memory setting in SQL Server?
2) SQL Server buffer pool will use all memory available to it up to the max mem setting. If queries are reading data larger than what you are seeing and still below the max memory setting then something is hosed with your VM config is my best guess.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 5, 2015 at 3:08 pm
Max memory is set at 60,000 MB. I left approximately 12 gb for the OS.
February 5, 2015 at 3:37 pm
So you aren't reading significant data, you have a config issue limiting memory usage or you aren't monitoring correctly in vSphere. Those are the only 3 options that I know of.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 5, 2015 at 3:39 pm
Thanks.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply