First published on MSDN on Dec 22, 2009
So what is part II about? It is about a change in Standard 64 bit Editions of SQL Server 2005 and 2008. This change implements the support of AWE APIs and “Lock Pages in Memory” privilege by these editions. It has been already advertised by Bob Ward and worth to be known especially by the DBAs who have seen their Standard Edition of SQL Server 2005 and 2008 being paged out from time to time without immediate solution or workaround.
Starting with this Cumulative Updates:
The 3 available memory allocation types now driven by the following condition are:
More Information
For the trimming issue there were several possible workarounds.
Again none of these solutions is easily applicable from a SQL Server perspective.
Running SQL Server on Windows 2008
Windows 2008 is less subject to memory trimming issues because of an improved contiguous memory allocation management. Related links can be found here:
Memory Model naming conventions
§ The three different memory model names starting with double M which stands for… Memory Model of course, i.e. Memory Model AWE, Memory Model Large and Memory Model Conventional.
Lionel Pénuchot
Senior PFE, Microsoft France
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.