Sql Server 2008 R2 takes more memory

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Sql Server 2008 R2 takes more memory

Sql Server 2008 R2 takes more memory

Rate Topic

Display Mode

Topic Options

Author

Message

solomon.jernas

Posted Sunday, February 10, 2013 10:54 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 2:28 AM
Points: 139, Visits: 630

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

Post #1418210

GilaMonster

Posted Monday, February 11, 2013 12:12 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640, Visits: 29,895

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 2008, MVP
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

Post #1418228

solomon.jernas

Posted Monday, February 11, 2013 12:49 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 2:28 AM
Points: 139, Visits: 630

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 :

Post #1418234

GilaMonster

Posted Monday, February 11, 2013 12:57 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640, Visits: 29,895

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 2008, MVP
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

Post #1418236

kevaburg

Posted Tuesday, February 12, 2013 8:12 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 11:15 PM
Points: 145, Visits: 173

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.

Post #1418992

« Prev Topic | Next Topic »

Permissions