Original: SQL Server Performance Tuning Training Introduction
Hello everybody, this is the first blog post I wrote in the blogging park, and the reason I want to open this blog is a record of my interest in MS SQL Technology learning.
As a computer professional graduates, their own grasp of the technology always feel very superficial, Bo and not specialized, until now I find their interests, so I found a variety of MS SQL technology related documents through the network, always feel that speaking relatively dry, not a systematic, At the end of March this year I had no intention of browsing to a website offering free performance tuning half-yearly Training (http://www.sqlpassion.at/academy/performance-tuning-training-plan/), The site will be sent to your mailbox every week to send a performance tuning training materials, so today, one months to learn, I feel that my understanding of SQL Server has begun to deepen, so I think we should share these materials to everyone, by the way to learn MS SQL technology a record.
Because I think, a lot of things only self-explaining to others, will deepen their understanding, the way to improve themselves.
The following is my study material sharing, this is the No. 0 article, General Introduction:
- 1th Month: Base of database
- In the 1th month we will build the foundation of SQL Server by discussing the basic concepts in SQL Server. In the first 4 weeks of the month we will learn:
- 1th Week how SQL SERVER executes a query
- 2nd week page _sql The basic unit of data storage in Server
- 3rd week Area _sql Server The basic unit of management space
- 4th Week page limit 8060 bytes
- 2nd Month: Index
- based on what you've learned in the 1th month, the 2nd is all about indexes in SQL Server. With a good indexing strategy, you can get a significant speed-up in SQL Server work. We will cover (below) the details in 4 weeks.
- 5th Zhou
- 6th Week clustered Index
- 7th Zhou Fei clustered index
- 8th Week Overlay Index unload point (Tipping points)
- 3rd month: Plan of execution
- When we submit a query to SQL Server, we only tell SQL Server what we want through the T-SQL statement. But inside SQL Server, it is compiled into an execution plan. The implementation plan is how we obtain the acquisition strategy of the data we need. If you have a performance problem, you need to understand how to read and adjust the resulting execution plan. You will learn the following about the implementation plan for the 4 weeks.
- 9th Week Understanding Execution Plan
- 10th Week plan Cache
- 11th Chikashige Compilation
- 12th Week parallel Execution plan
- 4th Month: Statistical information
- statistics are the most important part of a SQL Server database, and when you generate execution plans, statistics are used to determine how many columns in your query can be returned. If your stats expire, you'll get a good execution plan from SQL Server. So we devote one months of our time to statistical information so that you can be very familiar with them. This month we will talk about:
- 13th Week Why is statistics so important
- 14th Zhou Zifangtu and density (the histogram & the Density Vector)
- 15th Week column related issues (problems with column correlations)
- 16th Week cardinality estimates in SQL Server 2014 (cardinality estimation in SQL Server 2014)
- 5th month: Lock, block, deadlock
- As a developer or database administrator so far, your life is still peaceful because we are only single-user dealing with SQL Server. What happens inside SQL Server if it's multi-user? In that case, SQL Server needs to get the lock, which will eventually cause a blocking situation. And, if you're unfortunate, blocking can lead to deadlocks. For you to prepare for these scenarios, this month we will talk about:
- 17th Week Transaction ISOLATION LEVEL
- 18th Week optimistic concurrency control (optimistic Concurrency)
- 19th Zhou Yi Upgrade (Lock Escalations)
- 20th Week of deadlock
- 6th month: Performance monitoring and troubleshooting
- Wow, you finally got to the last one months of performance tuning. You're already on the road to being a performance tuning expert. But you still need some extra knowledge: running in SQL Server, how we do performance monitoring and troubleshooting to avoid performance problems. So in the last one months we will cover:
- 21st Week Pal Tool
- 22nd Week Wait Statistics (wait Statistics)
- 23rd Week temp Table (TempDb)
- 24th Week Database Maintenance (DB maintenance)
SQL Server Performance Tuning Training Introduction
