SQL Server Hardware

by Glenn Berry

Relational databases place heavy demands on their underlying hardware and many of these databases are mission-critical resources for multiple applications, where performance bottlenecks are immediately noticeable and often very costly to the business. Despite this, many database administrators are not very knowledgeable about server hardware. Many medium-to-large companies have completely separate departments that are responsible for hardware selection, configuration, and maintenance, and the DBA with no knowledge of hardware is often completely at their mercy. Likewise, many DBAs are also unaware of the performance implications of the various options and configurations for SQL Server, and the Operating System on which it is installed. Glenn Berry is a highly experienced Database Architect, teacher and SQL Server MVP, and his book is designed to provide the fundamental knowledge and resources you need to make intelligent choices about optimal installation and configuration of SQL Server hardware, operating system and the SQL Server RDBMS. With what you learn in this book, you'll be able to ensure that your SQL Server instances can handle gracefully the CPU, memory and IO workload generated by your applications, and that the operating system and SQL Server itself are installed, patched, and configured for maximum performance and reliability.

340 pages, Paperback

First published June 6, 2011

Reviews

[Drikus · Rating 4 out of 5]

Loved this book. It's an easy, yet informative read. It makes a lot of common sense, and deals with things you might think are ordinary, but you've never sat down and analysed it so much.

It's a great help, for anyone estimating, and testing database hardware. It addresses servers, processors, memory, disk-arrays, bench-marking, processor topologies, operating systems, SQL Server Editions, installation and configuration, and more.

I follow Glen's blog, and find his expertise very usefull.

[Dina · Rating 4 out of 5]

This book gives a step by step guide to follow for testing and setting hardware prior to setting up SQL Server. The visuals allow to browse the book later on. I recommend it for anyone who has to build a server from scratch.

[Christophe Addinquy · Rating 3 out of 5]

Ma note de lecture complète en français ici