Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

More Memory Expand / Collapse
Author
Message
Posted Monday, April 14, 2014 9:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 16, 2014 1:59 PM
Points: 34, Visits: 48
We have a Sql Server running Server 2003 Std X64 SP2, On this we have a Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86).

This Server has 12 gigs of ram in it right now, Sql is using about 3.8 of that and I want it to take more as I have 7 gigs doing nothing. I have turned on AWE and set my limit from 0-6Gigs. Still I top out of 3.8 gigs.

I have turned on lock pages in memory but I am not sure if it is actually doing anything. I just used a Domain admin account as a Test maybe I need a different account.

Am I missing something or is this sort of how it is.

Post #1561517
Posted Monday, April 14, 2014 9:28 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 9:14 PM
Points: 564, Visits: 851
SQL only takes memory as it needs it. Right now the server only needs 3.8 GB of memory as it needs more it will take more. If you need it to take at least 7GB every time it starts up and "never" releases it then you can set you "min server memory" property to 7 GB. Have you setup your "max server memory" too. I would recommend you give the OS at least 2GB and start from there.

I would recommend you download this ebook (or buy the hard copy if you want). Read the whole book, but you can skip ahead to the memory section to better explain what is going on and what options to set. Be careful with "lock pages in memory" if you don't understand what is going on behind the scenes.




Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1561525
Posted Monday, April 14, 2014 9:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 16, 2014 1:59 PM
Points: 34, Visits: 48
Its been at 3.8 since we turned on AWE so I doubt that any Microsoft product could do that :). It looks like a hard stop. Its hit the 4 Gig mark and that's all it will take.

It only fluctuates about 500 megs down but will always hard stop at 3.8, We are seeing some slow down in DB function so that's why we want it to have more.
Post #1561526
Posted Monday, April 14, 2014 9:51 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:04 AM
Points: 909, Visits: 2,843
[b]I have turned on AWE and set my limit from 0-6Gigs. Still I top out of 3.8 gigs.


If this is a 64 bit machine, what did you turn on AWE?

How did you "set your limit"? Did you use sp_configure?
sp_configure 'max server memory' XXXXX
RECONFIGURE

How are you determining that it's using 3.8 GB? Task Manager?



Michael L John
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Post #1561539
Posted Monday, April 14, 2014 9:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 16, 2014 1:59 PM
Points: 34, Visits: 48
Michael L John (4/14/2014)
[b]I have turned on AWE and set my limit from 0-6Gigs. Still I top out of 3.8 gigs.


If this is a 64 bit machine, what did you turn on AWE?

How did you "set your limit"? Did you use sp_configure?
sp_configure 'max server memory' XXXXX
RECONFIGURE

How are you determining that it's using 3.8 GB? Task Manager?



We turned it on via sql manager right click on the server and selecting properties. the Min to 0 Mb and the Max to 6144MB. We have restarted both
Yes I am checking Task manager.
Post #1561541
Posted Monday, April 14, 2014 9:56 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 9:14 PM
Points: 564, Visits: 851
First of all you don't need AWE on 64-bit server http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-530-awe-must-be-enabled-on-64-bit-servers/. Second if you want it to take 7GB of memory then set the "min server memory" and it will take that amount of memory.

Are you currently having memory pressure on your server? If not, why is it so important that you see the amount of memory get up to 7GB (i.e. your boss is questioning the amount of memory that the server really needs, etc).

Please download the book and read it (at least the memory chapter).




Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1561544
Posted Monday, April 14, 2014 10:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 16, 2014 1:59 PM
Points: 34, Visits: 48
Much like other things on the internet there are many different points of of view

http://sqlblog.com/blogs/argenis_fernandez/archive/2012/12/30/the-myth-around-32-bit-sql-server-instances-on-64-bit-operating-systems-and-awe.aspx



Post #1561550
Posted Monday, April 14, 2014 10:14 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 9:14 PM
Points: 564, Visits: 851
But I thought that you stated that you have a 64-bit SQL Server on a 64-bit OS? Argenis's blog doesn't apply to your situation unless I am wrong and you are running 32-bit SQL Server on a 64-bit server.



Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1561554
Posted Monday, April 14, 2014 10:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 16, 2014 1:59 PM
Points: 34, Visits: 48
Keith:
Sorry As I reread this it is a bit fuzzy

We have a Sql Server running Server 2003 Std X64 SP2, On this we have a Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86).

Yes we have 32bit SQL running on 64Bit windows Due to other limitations it has to be this way.
Post #1561556
Posted Monday, April 14, 2014 10:17 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:04 AM
Points: 909, Visits: 2,843
A key piece of information is missing. From the article you referenced, is this a 32 bit version running on 64 bit Windows?

Ok, I will give you that. You may or may not see a difference in performance, however.

Can you run this query?
sp_configure 'show advanced options', 1
RECONFIGURE

And then run this one, and post the results?
sp_configure


Michael L John
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Post #1561557
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse