This eBook can help you learn more about SQL Server performance tuning. It suggests several techniques that can be used for ensuring performant and tuned SQL Server instances and assumes intermediate-level experience with knowledge of basic database principles (i.e. indexing, locking, etc.).
eBook Format: PDF
Author: Artemakis Artemiou, B.Sc., M.Sc., MCP, MCTS, MCITP, Former Microsoft Data Platform MVP (2009-2018)
Rate this eBook:
About the Author
Artemakis Artemiou is a Senior SQL Server and Software Architect and Author. Artemakis received the prestigious Microsoft Data Platform MVP award for 9 consecutive years (2009-2017). He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator, DBA Security Advisor and In-Memory OLTP Simulator. Moreover, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). You can follow Artemakis on Twitter.
Table of Contents
Chapter 1: Indexes
– Getting Table Index Information in SQL Server
– Index Fragmentation in SQL Server (Reorganizing/Rebuilding Indexes)
– How to Rebuild all the Indexes of a Database in SQL Server
Chapter 2: Log Files Management
– Retrieving Log Space Information within a SQL Server Instance
– Retrieving Log Space Information within a SQL Server Instance – The Stored Procedure!
– Handling Disk Space Issues During Heavy Index Rebuild Operations
– Executing Heavy Set-Based Operations Against VLDBs in SQL Server
– Summary 28
Chapter 3: Locking and Blocking
– Monitoring Locking in SQL Server
– Updating SQL Server Tables Using Hints
– Table-Level Locking Hints in SQL Server
Chapter 4: TempDB
– TempDB Growth
– Where are Temporary Tables Stored in SQL Server?
– TempDB Enhancements in SQL Server 2016
List of Listings
List of Figures
List of Tables
Who Should Read This Book
This book is for database administrators and architects who monitor and tune SQL Server instances in order to keep them operating to the maximum possible performance and stability. The book suggests several techniques that can be used for ensuring a performant SQL Server instance. However, the book is not intended to be a step-by-step comprehensive guide. Additionally, it assumes at least intermediate-level experience with SQL Server administration and knowledge of basic database principles (i.e. indexing, locking, etc.).
How This Book Is Organized
This book is organized as follows. Chapter 1 discusses the usage of indexes and the derived benefits of using them along with techniques to maintain them healthy in order to ensure performance. Chapter 2 discusses ways of managing log files as well as how to ensure that their growth will not create issues during the execution of heavy set-based operations. Chapter 3 discusses how you can monitor locking and tracking blocking cases in SQL Server as well as other locking-related topics. Chapter 4 discusses topics having to do with maintaining the good health and performance of the tempdb database as well as retrieving information from tempdb’ s data structures.