SQL Server Content
Managing and Optimizing SQL Server
You can improve SQL Server performance and maintenance by paying attention and tweaking five key settings after the default installation is finished: system and database file locations, memory allocation, database default settings, the alias, and scheduled backups, including transaction log backups.