Sql Server 2008 R2 takes more memory

Question

Sql Server 2008 R2 takes more memory

solomon.jernas

Hall of Fame

Points: 3680
More actions
February 10, 2013 at 10:54 pm

#270607

one of our new production server launched 3 days before, Windows 2008 and Sql server 2008 R2 with sp2..
there are 2 databases running in the server, one of the db size 15 GB another one 10 GB.
Two application is running there. and two transaction replication configured for 2 db.
Ram size: 16 GB
But the sql server takes more memory 12 GB, is it normal? CPU usage 10% only.
Please anyone help me..
Thanks
jerry

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Perfectly normal. SQL will use as much memory as it can, up to the configured max server memory. If SQL's using too much memory, drop max server memory slightly.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

solomon.jernas Hall of Fame Points: 3680 More actions · Answer 2

Thanks..

we are not configure max server memory ...

suppose if i want configure max server memory setting for 16 GB Ram... what is size will give .......

For Sql Server :

For OS

For Application :

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Chapter 4

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

kevaburg SSCoach Points: 18131 More actions · Answer 4

OK, here is a gripe. It is clear that you don't really understand the basic concepts and yet you are administering (I am guessing) production database servers. You need to get your head in some books and learn.

Gripe over.

I like to have (for Windows 2008) 2GB of free memory for the OS and a sensible proportion for the instance itself. If you are running multiple instances then you are going to have to divide the remaining memory among the three instances. If in your case you have one instance, then 14GB can be allocated to the instance.

It is ALWAYS a good idea to restrict the SQL Server from using too much memory so that the Operating System doesn't get starved.