SQL Server Large Pages – Am I using it?
Question from my class: How do I know if SQL Server is using Large Pages? SQL Server supports Large Page Allocations if the following conditions are true: You are running SQL Server Enterprise Edition Your box has 8 GB RAM or more “Lock Pages in Memory” privilege is set for the SQL service account (which [...]