December 20, 2013 at 3:03 pm
OK. Before I begin you should know I have read all of the threads that say that SQL Server will try to use as much RAM as possible and that somehow that is a wonderful thing.
I have two SQL Server 2012 boxes...
(SETUP ONE) Has 16 GB of RAM and is running v. 11.0.2100 and has 40 fairly small databases and during normal running times is consuming a total of 800MB of RAM
(SETUP TWO) is setup on a virtual private server and allocated 4GB of RAM running v. 11.0.3000 and has 2 small databases and is consuming 2.2GB of RAM, all other configurations between the two SQL Server instances are the same.
If I take both databases offline on SETUP TWO and restart the instance, the level of RAM drops about 50MB. The problem is that my VPS only has 4GB of RAM available and with all processes running the server is at 95% physical memory at all times. I have had a handful of issues with other applications not starting because they cannot allocate enough RAM.
SETUP ONE has 16 GB of physical RAM, has only 25% allocated at one time and SQL Server is using very little.
The only other difference between these two instances, is that SETUP TWO was an Express 2012 install which I then ran the upgrade to get it be the business intelligence version. SETUP ONE was initially setup as the business intelligence version and not upgraded.
There is no reason that a SQL Server instance with all user databases offline should be using 2.2GB of RAM. How can I get my SETUP TWO to act like my SETUP ONE?
Thanks!
Attached are some screenshots showing the task manager...
December 20, 2013 at 3:24 pm
what is the OS on each?
is windows 32 or 64 bit?
is sql server 32 or 64 bit?
is max memory set on either box?
what is the size of the two small databases on server 2?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
December 20, 2013 at 3:35 pm
The only way you can really control the ram on setup 2 is to set a max memory. However, I'd look at the target memory on both setups as well. That tells you what SQL wants.
(and answer Kevin's questions)
December 20, 2013 at 4:15 pm
I'm with Kevin. It sounds like OS and possibly 32bit.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 21, 2013 at 3:20 am
Do you have or have you ever played with service broker on Setup 2?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 21, 2013 at 9:30 am
Both servers are running windows 2008 r2 and both are running 64bit sql server.
Both have the same max/min memory settings.
Setup two is a vps which is starting to make me think that maybe sql server is allocating ram based on the server hardware configuration. The servers profile show 4 gb of ram, but if I go to view memory allocation for the server it shows all of the ram on the computernot just what my vps has. If sql server thinks I have 200gb of ram and not 4 would it simply allocate a minimum percentage of that available. .. or what it thinks is available?
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply