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 ««12

Memory Expand / Collapse
Author
Message
Posted Saturday, January 10, 2009 5:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, July 25, 2010 9:38 PM
Points: 107, Visits: 264
AWE is not required, not available, on a 64bit system. It was included as a workaround to solve the maximum 2GB address space available to 32bit processes.

To limit your SQL Server, in your SQL Server Instance properties, goto the Memory tab and enter the maximum amount of RAM you wish to use in KB.


If you want to ensure that SQL Server will manage the memory it is using and not respond to Windows requests for paging, enable the Lock Pages in Memory privilege for the service account that is running the SQL Server Database Engine service.



--
Andrew Hatfield
Post #634140
Posted Wednesday, July 14, 2010 3:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 26, 2012 11:26 AM
Points: 2, Visits: 11
How do you gauge the memusage in sysprocesses? how many pages in KB?
Post #952730
Posted Wednesday, July 14, 2010 3:21 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:43 AM
Points: 40,617, Visits: 37,083
Please post your question in a new thread. Thank you.


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 #952733
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse