MS SQL Server tuning is very similar to any other powerful Database Management System (DBMS), with similar performance and tuning considerations. For example:
1. How effective are the memory-resident database buffers at reducing disk I/O?
2. Where have you placed the database transaction recovery log files?
3. Does the database design minimize contention for SQL Server locks and [...]

Beginning with SQL Server 2000, performance objects are named differently depending on whether you are running a single, unnamed instance of SQL Server or either a named instance or multiple instances of SQL Server. If you are installing SQL Server on a machine that is also running a previous version of SQL Server, then you must install [...]