Thursday, May 7, 2009

About My SQL Server Performance Tuning - Day 4 & Day 5

Day 4:
 1. Turn on SQL Trace to capture performance of tuned scripts

Day 5:
 1. Present tuning results
     a. CPU usage
     b. Memory usage
     c. Hard disk I/O
     d. Network usage
     e. Overall server performance
     f. Overall database performance (peak & non-peak hours)
     g. Tuned scripts' performance

No comments: