| Sumario: | Begin your journey into query optimization by learning the basics of how SQL Server processes a query from start to finish. Once this foundation is established, you will focus on execution plans: What are they? How do we read them? And what are their more common operations? A variety of statistics options will be introduced that provide insight into query duration and the load that a given query presents on memory and storage resources. With a set of tools defined, you will tackle a variety of common optimization challenges. You’ll review some common problems in which performance is inadequate and then solutions to mitigate those problems and improve performance. These basic patterns will provide a format for viewing and analyzing queries with the goal of being able to identify the source of the problem when a query is running too slow. What You'll Learn Discover how SQL Server optimizes a query and generates an execution plan Enable, read, and decipher execution plans for query analysis Identify a variety of common execution plan operators Use STATISTICS IO to gauge query impact on memory and disk resources Measure query duration using STATISTICS TIME Analyze problem queries to find the source of performance problems Identify common query mistakes and how to quickly resolve them Who This Video Is For Database administrators, developers, or anyone who writes TSQL queries on a regular basis. For all database professionals who need to write efficient code that executes quickly while consuming minimal resources.
|
|---|
