You need to consider more than just the speed of your software when determining the quality of your database performance. In this course, we discuss factors that could potentially impact performance, how you can use indexes to improve performance, how to use query plans generated by SQL Server, and how to monitor the performance of SQL Server. Then, after you know what to look for while monitoring your data storage, we cover how you can baseline the performance metrics and decide how to address any performance problems.
-Tuning Database Performance
-Optimization Using Indexes
-Optimization Using Query Plans