SQL Server leverages Windows Memory Manager’s Large-Page support which is particularly beneficial in 64-bit OSs with important amounts of physical memory (RAM). The idea behind this mechanism provided by the OS is to reduce TLB misses when accessing frequently...

Much has been written about SQL Server’s support for Soft Numa since even before the first release which supported that concept (SQL Server 2005) was released. Among the list of interesting posts about it, I propose you to read these: A new platform layer...

This is something I planned to start a while ago and never found the time to do it properly. The idea behind this series of posts is to highlight what are all those benefits which are only available in the Enterprise Edition. Not only the ones well renown...