MSSQLTips

Many customers (and non-customers) are often confused about all the different memory configurations and options available on 32bit systems (64bit systems do not have so many considerations thanks to the large flat memory space and a VAS size of 16 terabytes as of my typing this)...so, here's an attempt...

Earlier this week I had a customer send me the following question: I have a server running the 32-bit edition of SQL 2005 SP1 with 16 GB of memory and 8 CPUs. AWE is enabled and the max server memory setting is 12 GB. When the service is started, memory usage starts low and gradually increases as the...