This book is intended to give you the core information and tools you need to choose the best configuration and installation options for the SQL Server hardware, operating system, and RDBMS.
With the knowledge you gain from this book, you'll be able to make sure that your SQL Server instances are installed, patched, and configured for maximum performance and reliability, and that the operating system and SQL Server itself are able to handle the CPU, memory, and IO workload produced by your applications.
Relational databases put a lot of strain on the technology that supports them, and many of these databases are essential components of many different applications. As a result, performance bottlenecks are typically highly expensive for the company. Despite this, a lot of database managers lack a solid understanding of server hardware. The DBA without any hardware knowledge is frequently totally at their mercy because many media- to large-sized businesses have completely different departments that are in charge of hardware selection, configuration, and maintenance. The performance effects of the numerous SQL Server settings and configurations, as well as the Operating System on which it is installed, are also often unknown to DBAs.
