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

Memory Optimization Expand / Collapse
Author
Message
Posted Tuesday, May 7, 2013 1:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 2:08 AM
Points: 1,380, Visits: 2,703
Hi All

Environment:
Windows 2003 Enterprise Edition - 32bit
SQL 2005 Standard Edition - 32Bit

PAE has been enabled
Server has 16GB of ram installed and 8GB has been allocated to SQL Server

Using task manager and sys.dm_os_sys_info - SQL is only using +-1.6GB

From what I understand, AWE needs to be enabled now?

Once AWE is enabled, should I see the amounts in task manager and sys.dm_os_sys_info increase to 8GB?

Am I on the right track here?

Thanks
Post #1450015
Posted Tuesday, May 7, 2013 7: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: Friday, October 31, 2014 4:01 PM
Points: 835, Visits: 1,192
Have you given the ‘Lock pages in memory’ right to the account used by the SQL Server instance?

Also the task manager is not a right place to look for how much memory SQL server is using.

Run DBCC MEMORYSTATUS to see the actual values.
Post #1450147
Posted Tuesday, May 7, 2013 7:56 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 2:08 AM
Points: 1,380, Visits: 2,703
Neeraj Dwivedi (5/7/2013)
Have you given the ‘Lock pages in memory’ right to the account used by the SQL Server instance?

Also the task manager is not a right place to look for how much memory SQL server is using.

Run DBCC MEMORYSTATUS to see the actual values.


Yes I have

Which memory status am I looking for under DBCC memorystatus?

thanks
Post #1450152
Posted Tuesday, May 7, 2013 8:06 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: Friday, October 31, 2014 4:01 PM
Points: 835, Visits: 1,192
Look at he Memory Manager. First Section.

VM Reserved
VM Committed
Post #1450159
Posted Tuesday, May 7, 2013 8:09 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 2:08 AM
Points: 1,380, Visits: 2,703
Thanks
Post #1450164
Posted Tuesday, May 7, 2013 8:26 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:12 AM
Points: 31,284, Visits: 15,746
Check this: http://msdn.microsoft.com/en-us/library/ms190673%28v=sql.105%29.aspx






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1450179
Posted Tuesday, May 7, 2013 10:32 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 2:08 AM
Points: 1,380, Visits: 2,703
Steve Jones - SSC Editor (5/7/2013)
Check this: http://msdn.microsoft.com/en-us/library/ms190673%28v=sql.105%29.aspx


Thanks

If I had a Windows 2003 Standard edition server, regardless of whether I had more than 4GB of ram in the server, it won't see it.

Thanks
Post #1450244
Posted Wednesday, May 8, 2013 2:51 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 14, 2014 8:26 AM
Points: 2,894, Visits: 3,278
Take a look at this link, it covers a lot of the background about using AWE: http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20Memory%20Management

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1450454
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse