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...

Lots of customers I visit are frequently interested in determining what objects/structures/files/etc. are consuming the largest amount of space at a given time (or over time) within the Sql Server buffer pool. In Sql 2000, this was a bit complicated to determine to say the least, however with Sql 2005's...