Post image

Max Server Memory and SQL Server 2016 Service Pack 1

Everything changed for SQL Server Standard Edition on 16 November 2016, and how memory limits work. On that day, a slew of Enterprise Edition features made their way into editions across the board, including Express Edition and LocalDB. The memory limit of 128GB RAM applies only to the buffer pool (the 8KB data pages that
-> Continue reading Max Server Memory and SQL Server 2016 Service Pack 1