MS SQL Server Internals
You’re a developer or a DBA, and you know how to get the data by SQL query. You are trying to understand how SQL Server internal works to get the query data, what can be proper index of the query and what performance optimization can be done. In this 2-hour presentation sessions, we will discuss:
- How SQL server internal works for SELECT vs UPDATE?
- What are relational engine and storage engine?
We will walkthough one typical table and index case study to explore the following topic:
- clustered & nonclustered indexes
- covering index
- The basics of execution plans
- How sargability impact the query performance
- What SQL Server uses to estimate query memory
- TempDB
Exam
• 30-min exam will be given at the end of the session
Prerequisite
· Basic understanding of Database/Windows
| Course Name |
Microsoft SQL Server Internals |
| Speaker |
Tony Hsu |
| Duration |
2.5 hours |
| Location |
|
| Language |
Chinese |
|
Agenda |
| Session 1 |
- What is ACID?
- How SQL Server Engine works?
- Take “Select” as example
- Take “Update” as example
- How SQL OS works?
- Lazy Writer with LRU
|
| Session 2 |
- clustered & nonclustered indexes
- covering index
- The basics of execution plans
- How sargability impact the query performance
- What SQL Server uses to estimate query memory
- TempDB
|
|
|