🏡

Performance Tuning and Optimizing SQL Databases

Course Outline MOC10987.pdf
Slides Slides.zip
Material Download
Useful Links
DayModulesSharing
1
  • SQL Server Components and SQL OS
  • Windows Scheduling vs SQL Scheduling
  • Waits and Queues
  • Core Concepts
  • Storage Solutions
  • I/O Setup and Testing
2
  • Database Structure Internals
  • Data File Internals
  • TempDB Internals
  • Windows Memory
  • SQL Server Memory
  • In-Memory OLTP
  • Concurrency and Transactions
  • Locking Internals
3
  • Statistics Internals and Cardinality Estimation
  • Index Internals
  • Columnstore Indexes
  • Query execution and optimizer internals
  • Query execution plans
  • Analyzing query execution plans
  • Plan cache internals
  • Troubleshooting plan cache issues
  • Query store
4
  • Extended events core concepts
  • Working with extended events
  • Monitoring and tracing
  • Baselining and benchmarking

Recommanded Books
TitlePro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database
ISBN978-1-484-28770-5
AuthorThomas LaRock, Enrico van de Laar
Year2023
Publisher Apress
TitlePro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers
ISBN978-1-484-29255-6
AuthorElizabeth Noble
Year2023
Publisher Apress
TitleExpert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud
ISBN978-1-484-29214-3
AuthorEdward Pollack, Jason Strate
Year2023
Publisher Apress
TitleSQL Server Query Tuning and Optimization: Optimize Microsoft SQL Server 2022 queries and applications
ISBN978-1-803-24262-0
AuthorBenjamin Nevarez
Year2022
Publisher Packt Publishing
TitleSQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques
ISBN978-1-098-10192-3
AuthorDmitri Korotkevitch
Year2022
Publisher O'Reilly Media
TitleSQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance
ISBN978-1-484-28890-0
AuthorGrant Fritchey
Year2022
Publisher Apress
TitleSQL Server 2022 Revealed: A Hybrid Data Platform Powered by Security, Performance, and Availability
ISBN978-1-484-28893-1
AuthorBob Ward
Year2022
Publisher Apress
TitlePro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance
ISBN978-1-484-26496-6
AuthorLouis Davidson
Year2021
Publisher Apress
TitleRefactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications
ISBN978-1-484-25580-3
AuthorBob Ward
Year2021
Publisher Apress
TitleHigh Performance SQL Server: Consistent Response for Mission-Critical Applications
ISBN978-1-484-26490-4
AuthorBenjamin Nevarez
Year2021
Publisher Apress
TitleExpert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries
ISBN978-1-484-25196-6
AuthorKathi Kellenberger,Clayton Groom,Ed Pollack
Year2020
Publisher Apress
TitlePro SQL Server 2019 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server
ISBN978-1-484-24915-4
AuthorEnrico van de Laar
Year2019
Publisher Apress
TitleDynamic SQL: Applications, Performance, and Security in Microsoft SQL Server
ISBN978-1-484-24317-6
AuthorEdward Pollack
Year2019
Publisher Apress