SQL Server Hardware [Paperback]

Glenn Berry (Author)

Book Description

Publication Date: June 6, 2011

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.

Editorial Reviews

From the Author

I wanted this book to be a little different from the multitude of good, existing books about SQL Server performance and scalability. I wanted to start, from the ground up, showing how to evaluate and choose hardware and storage subsystems from a SQL Server specific perspective.
Next, I wanted to show how to properly install and configure the operating system and SQL Server itself for the best performance, scalability, and reliability. I also wanted to give you ammunition for convincing your boss or customers why newer versions of the operating system and newer versions of SQL Server were a better solution than older versions. Finally, I wanted to talk about the tangible performance benefits you get from SQL Server Enterprise Edition, that make it worth the extra licensing cost. I think that I accomplished most of these goals, but I will leave that judgment up to the reader. I really enjoyed writing this book, and I hope it is a valuable resource to you!

About the Author

Glenn Berry works as a Principal Consultant at SQLskills in Parker, CO. He is a SQL Server MVP, and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves he likes to take tests. He is also an Adjunct Faculty member at University College, University of Denver, where he has been teaching since 2000, and he has completed the Master Teacher Program.

Product Details

• Paperback: 340 pages
• Publisher: Red gate books (June 6, 2011)
• Language: English
• ISBN-10: 1906434638
• ISBN-13: 978-1906434632
• Product Dimensions: 7.5 x 0.7 x 9.2 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.8 out of 5 stars  See all reviews (14 customer reviews)
• Amazon Best Sellers Rank: #527,035 in Books (See Top 100 in Books)

Most Helpful Customer Reviews

17 of 19 people found the following review helpful

5.0 out of 5 stars Fantastic, thorough, accurate coverage August 3, 2011

By Brent Ozar

Format:Paperback

You probably only buy a couple of SQL Servers per year. You probably just tell your sysadmins, "I need a 2-socket server with 32GB of memory," and then you just assume everything's okay.

Scratch that. Let's be honest. It's just us here, you and me, so I can be frank. You don't trust those bozos. They sit around playing Capture the Flag while your server is down, and you've got a sneaking suspicion that they use your server as a BitTorrent host for a few weeks before they actually give it to you. You're lucky if it's even got the right OS, let alone the right CPUs.
Yes, I used pink Post-It notes.

It's time to take the problem into your own hands, and Glenn Berry is here to help. Glenn, like me, is a hardware addict who loves reading Anandtech and digging through the details of the latest CPU architectures, memory configurations, and storage options. Unlike me, Glenn wrote an entire book on the topic, all by himself, and this book kicks ass. It's everything you need to know to get the right hardware and get SQL Server set up correctly on it.
Hardware, Budgeting, and More

Let's pick just one page. Page 21 explains the difference in speed and quantity for all kinds of data - storage, memory, L3 cache, L2 cache, and L1 cache. Glenn then explains why you care about each and how to pick the right CPU for SQL Server. He finishes up (we're still on page 21, mind you) by discussing why you might want to invest more in CPU power than memory - something that seemed blasphemous to me until I read his explanation, but now I'm sold too.

The book covers more than just hardware details, though: Chapter 6, SQL Server Version and Edition Selection, does a better job of explaining the business benefits of Enterprise Edition better than anything I've ever read. Glenn gives a personal touch when he writes about each feature, and gives real-life hands-on-based advice about the feature's worth. For example, Distributed Partitioned Views sounds great in theory, but I've never seen it scale well. Glenn points out why Data Dependent Routing is a better solution. What, you haven't heard of that? Probably because it's not a SQL Server feature - it's a better way to design applications and databases, and it doesn't require Enterprise Edition. He doesn't teach you how to do it, but like everything else in the book, he points you where to learn more about the topic.
The Bad News

I read books with a stack of Post-It notes at my side. Whenever I see something that really surprises me - good or bad - I slap a Post-It note on the page with the edge just ever-so-slightly sticking out, and I jot notes on the Post-It. I have this thing about not writing on books - probably comes from my childhood years spent at the library. At the end of the book, I circle back and reread the tagged pages. If there's more good stuff than bad, I post a review on the blog.

Going back through this book, I only had one single negative Post-It. Chapter 4, Hardware Discovery, explains how to use CPU-Z, MSINFO32, Task Manager, and Computer Properties to build an inventory of what your SQL Server is running on. After reading that chapter, I was a little bummed that it didn't explain how to gather an inventory of storage data, or how to get more in-depth hardware information from onboard management systems like the HP iLO or Dell DRAC.

But then it hit me: this is a 321-page book exclusively dedicated to evaluating, buying, and installing SQL Server hardware. 321 pages of technical goodness, and my only complaint is that it's not long enough? There's never been a book like this before, and it's a Herculean effort for anyone to pull off alone, and do it accurately. Glenn pulled it off. I didn't find a single inaccuracy in the entire book, and believe me, that's a rarity. I even liked the cover photo of power plant cooling towers, a subtle joke about overclocked processors.

6 of 7 people found the following review helpful

5.0 out of 5 stars Great Book July 25, 2011

By Scott G. Newman

Format:Paperback|Amazon Verified Purchase

Very very good book. This book delves into the gory details of setting up sql server properly from the very ground up. Processor specs, IO subsystems, bench-marking, windows & sql server installation options...you'll find it all.

If you follow the advice in this book, I guarantee that you will not only have the most optimal running sql server, you'll look like a rockstar as well.

This book should be on every DBA's bookshelf, and should be the first one you reach for when provisioning a new server. It's that good.

3 of 3 people found the following review helpful

5.0 out of 5 stars Where was this book all there years - A Must have book for all! August 11, 2011

By Pinalkumar Dave

Format:Paperback

For most people working with relational databases, a lot of time, effort and money is spent on the software. SQL Server Hardware by Glenn Berry focuses on one of the most important, and most overlooked, aspects of setting up SQL server - the hardware (as you may have guessed from the title). If you've ever had a question about the type of hardware you might need and what to do with it once you have it, this book will answer all your questions.

Not only is this book basically an exhaustive look at all aspects of database hardware, the author clearly has a passion for the subject - and that is what makes it a truly great book. The author's enthusiasm and expertise is obvious throughout the book, which makes it interesting as well as informative. The author has a long string of very impressive acronyms after his name - all leading up to the fact that he is a SQL Server MVP, and it shows here in this book.

This book goes into in-depth detail about the best way to install and configure SQL Server on your hardware to get the best performance possible out of your machines. Topics in this book include current and upcoming hardware you should know about, like processors, memory, and storage; how to determine what hardware you need for specific SQL Server uses; the pros and cons for the various versions of Windows server available and why some work better with SQL Server; how to install and configure SQL Server, as well as the patches, fixes, and updates you need to know about. Calling this manual the "bible" of SQL Server hardware would not be an exaggeration.

Honestly the best part of the book is - it answers following questions.
1. What kind of CPU I should use to get best out of my Database?
2. What kind of Memory will improve the caching performance for database?
3. What are the optimal IO settings to avoid performance bottleneck?

Well, the answers are all there in the book, one just have to read it.

If you work with SQL Server, would like to learn how, or just want to be able to communicate with your sysadmin, I recommend that you buy this book. It covers everything from CPU architecture to installing and configuring SQL Server. This is a must-have reference book.

Five Stars!