About My SQL Server Performance Tuning - Day 3

Day 3:

 1. Apply all scripts into database

     a. Index tuning scripts

     b. Plan guide

     c. Add/Drop/Move data/log files

     d. Adjust TempDB

     e. Create database maintenance plans

Note:

 1. OLTP and OLAP have different tuning objectives. OLTP aims for faster insertion while OLAP aims for faster data retrieval.

 2. Under certain circumstances, we may need to create new table(s) to achieve certain objectives (normally for reporting purposely)

 3. Sometimes, we, as DBAs, may not have the influence over front  end application. Plan guide may only provide limited capability to tune the queries.

 4. It is very rare that we need to modify existing database structure (this require too much programming effort)