Professional Microsoft SQL Server 2014 Administration by Jorgensen Adam & Ball Bradley & Wort Steven & LoForte Ross & Knight Brian
Author:Jorgensen, Adam & Ball, Bradley & Wort, Steven & LoForte, Ross & Knight, Brian
Language: eng
Format: epub
ISBN: 9781118859193
Publisher: Wiley
Published: 2014-09-07T16:00:00+00:00
SUMMARY
In this chapter, you learned how to read query plans, how queries are processed in SQL Server, and how to identify potential performance improvements. You learned the steps a query goes through when it is compiled and executed: it is parsed into logical operators, optimized into physical operators, and then sent to the execution engine for actual processing. Cost optimization and the impact of the new SQL Server 2014 Cardinality Estimator were discussed. You also learned about the impact of statistics on the Cardinality Estimator, and the value of having updated statistics for accurate query plans.
You learned the impact of various query plan operators on performance, including several data access operators (Table Scan, Index Scan), and several join operators (Hash Join, Nested Loops Join, and Merge Join). This chapter also covered partitioning and its impact on query performance.
Identifying and isolating problem queries should be a standard part of system administration for a SQL Server environment, and Microsoft and other third-party vendors provide many tool sets for monitoring the environment and measuring performance. You learned that the Extended Events monitoring tool can provide a lot of detail that can be used to troubleshoot performance problems, and that the key is understanding expected behavior versus unexpected behavior. You also learned that system DMVs are useful for monitoring query recompile activity.
Now that you understand the basics of SQL performance tuning, you can move to Chapter 14, in which you learn more about creating indexes that will help your query performance.
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
NET | C & C++ Windows Programming |
SQL Server | VBA |
Visual Basic |
Deep Learning with Python by François Chollet(12587)
Hello! Python by Anthony Briggs(9924)
OCA Java SE 8 Programmer I Certification Guide by Mala Gupta(9800)
The Mikado Method by Ola Ellnestam Daniel Brolund(9784)
Dependency Injection in .NET by Mark Seemann(9347)
Algorithms of the Intelligent Web by Haralambos Marmanis;Dmitry Babenko(8309)
Test-Driven iOS Development with Swift 4 by Dominik Hauser(7770)
Grails in Action by Glen Smith Peter Ledbrook(7704)
The Well-Grounded Java Developer by Benjamin J. Evans Martijn Verburg(7566)
Becoming a Dynamics 365 Finance and Supply Chain Solution Architect by Brent Dawson(7139)
Microservices with Go by Alexander Shuiskov(6900)
Practical Design Patterns for Java Developers by Miroslav Wengner(6819)
Test Automation Engineering Handbook by Manikandan Sambamurthy(6758)
Secrets of the JavaScript Ninja by John Resig Bear Bibeault(6422)
Angular Projects - Third Edition by Aristeidis Bampakos(6178)
The Art of Crafting User Stories by The Art of Crafting User Stories(5698)
NetSuite for Consultants - Second Edition by Peter Ries(5630)
Demystifying Cryptography with OpenSSL 3.0 by Alexei Khlebnikov(5441)
Kotlin in Action by Dmitry Jemerov(5072)
