Memory Optimization

Question

Post reply

Memory Optimization

SQLSACT

SSC-Insane

Points: 21838
More actions
May 7, 2013 at 1:49 am

#274803

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

Viewing 8 posts - 1 through 7 (of 7 total)

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

Neeraj Dwivedi SSCertifiable Points: 6768 More actions · Answer 1

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.

SQLSACT SSC-Insane Points: 21838 More actions · Answer 2

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

Neeraj Dwivedi SSCertifiable Points: 6768 More actions · Answer 3

Look at he Memory Manager. First Section.

VM Reserved

VM Committed

SQLSACT SSC-Insane Points: 21838 More actions · Answer 4

SQLSACT

SSC-Insane

Points: 21838

May 7, 2013 at 8:09 am

#1613002

Thanks

Steve Jones - SSC Editor SSC Guru Points: 736280 More actions · Answer 5

Check this: http://msdn.microsoft.com/en-us/library/ms190673%28v=sql.105%29.aspx

SQLSACT SSC-Insane Points: 21838 More actions · Answer 6

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

EdVassie SSC Guru Points: 60472 More actions · Answer 7

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: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara