Microsoft® SQL Server 2012 Unleashed

SQL Server Instance Guidelines

Next comes the SQL Server instance itself and the critical items that must be considered:

SQL Server configuration—We do not list many of the SQL Server instance options here, but many of the default options are more than sufficient to deal with most SQL Server implementations. See Chapter 60 for information on all the available options.

SQL Server device allocations—Devices should be treated with care and not overallocated. SQL databases utilize files and devices as their underlying allocation from the operating ...