Microsoft® SQL Server 2008 R2 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 49 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 system. You do not want dozens and dozens of smaller files or devices for each database. Having all these files or devices becomes harder to administer, move, and manipulate. We often come into a SQL ...