MS SQL Database Performance Tuning
這堂課主要透過許多實際個案與上機練習了解 MS SQL database performance 的奧秘與調教技巧
超過12小時的上機實做，從 Query, Performance monitoring, Index, Execution plan, database configuration 等，測試並了解 MS SQL database performance tuning 的原理與步驟。
The learning objective is to identify MS SQL Database performance issue AND take tuning related actions. There are over 20+ hands Labs. In the end of the course, you will be able to answer:
- Performance benchmark methodology
- What performance tools are available to identify the root/cause and do benchmark?
- What performance monitor counters can be used for SQL Server and what does these mean to performance?
- How to query Top 10 CPU usage queries, Top 10 I/O usage queries, Top missing indexes?
- Query Design consideration, identifying the bottleneck by execution plan and how to improve the query performance?
- “SELECT” Query best practices
- “JOIN” makes a difference. What are Hash Join, Merge Join and Loop Join?
- How Index may help the query performance?
- What is non/clustered index, and covering index?
- Identify Blocking and deadlock. How to solve these issue?
- Performance case study. I/O or CPU Usage intensive cases.
Prerequisite
- Basic understanding of SQL Server/SQL Query
- Basic Performance testing methodology
Evaluation
- Attendance rate 50%
- Homework / Lab 50%
課程綱要
| Course Name | MS SQL Database Performance Tuning Hands-on Labs | ||||||||||||
| Duration | 16~20 hours | ||||||||||||
| Target Audience | Attendee whom may be interested or involved with
|
||||||||||||
| Agenda |
|