High performance SQL serverconsistent response for mission-critical applications
Nevarez, Benjamin
High performance SQL server consistent response for mission-critical applications
Benjamin Nevarez
- New York Apress c2021
- xxii, 397 p. ill. 25 cm.
Reprint, 2024
Includes index
Design and configure SQL Server instances and databases in support of high-throughput, mission-critical applications providing consistent response times in the face of variations in numbers of users and query volumes. In this new edition, with over 100 pages of additional content, every original chapter has been updated for SQL Server 2019, and the book also includes two new chapters covering SQL Server on Linux and Intelligent Query Processing. This book shows you how to configure SQL Server and design your databases to support a given instance and workload. You will learn advanced configuration options, in-memory technologies, storage and disk configuration, and more, all aimed toward enabling your desired application performance and throughput. Configuration doesn’t stop with implementation. Workloads change over time, and other impediments can arise to thwart desired performance