Publisher's Synopsis
Expert SQL Server Performance Engineering is a practical book with collected knowledge from more than a decade of SQL Server performance engineering and benchmarking that explains how to architect, design, build, and configure SQL Server Infrastructure, starting at the core with CPU and memory and going all the way to I/O and storage. The book explains available modern hardware in a vendor independent way, shows how to monitor and compare performance, helps you to configure SQL Server options and select hardware. It shows practical examples for all kinds of workloads and server sizes. It also provides in-depth information on topics like future expandability of systems and solid state storage devices.
There are many books out there that approach performance issues from the query and index optimization point of view. What if your queries are already optimized? Expert SQL Server Performance Engineering starts on the other end of the performance management spectrum and provides in depth information on how to get the most (and in some cases the last bit of) performance out of your existing or future SQL Server infrastructure.
- Shows how to compare, benchmark, and select server and storage hardware.
- Provides insight on garnering every last bit of performance from your system.
- Enables you to design and build the infrastructure needed to run your workload.
What you’ll learn
- Choose appropriate hardware for the workload at hand.
- Reconfigure existing hardware to be more performing end efficient.
- Understand how SQL Server storage engine works and stores data.
- Implement more effective database file group and file layouts.
- Understand and implement service level agreements.
- Monitor and compare SQL Server performance.
Who this book is for
Expert SQL Server Performance Engineering is for the database administrator who wants to get the most out of server and storage hardware while maintaining or even increasing availability and reliability. The book will provide information for existing infrastructure and also help the reader with planning and designing future systems. It also provides valuable information for system, server, network, and storage administrators wanting to provide better services for their database teams by learning how to optimize infrastructure for SQL Server.
