SQL Server Premier Field Engineer Blog

This is a shared team blog of the SQL Server Premier Field Engineer team

Browse by Tags

Tagged Content List
  • Blog Post: SQL Server memory models (Part II)

    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...
  • Blog Post: SQL Server memory models (Part I)

    You may have questioned why, on 64 bit enterprise Edition, DBCC MEMORYSTATUS reports non zero “AWE allocated” memory even if ‘AWE enabled’ option is not enabled. A short description of SQL Server memory model will help to answer. Here is an example of a DBCC MEMORYSTATUS output on a 32GB X64 Enterprise...
Page 1 of 1 (2 items)