This eBook suggests several techniques that can be used for ensuring performant SQL Server instances and assumes intermediate-level experience with knowledge of basic database principles (i.e. indexing, locking, etc.).
Rate this eBook:
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.