December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
What’s New in Configuring, Tuning, and Optimizing SQL Server Options
There are a few new configuration options in SQL Server 2012. These new configuration options are primarily targeting memory care and feeding. Specifically, there are new aspects to max server memory, min server memory, and Addressing Windowing Extensions (AWE)-enabled memory options. Another change is the startup parameter of the SQL Server database engine that provides an amount of memory to reserve (-g option). However, you must be warned that there are options available that are not obsolete yet but have no effect (even if you set them). We identify them in this chapter as they come up.
SQL Server 2000 had a total of 36 options. With SQL Server 2005, the number of options ...