Click here to monitor SSC
  • Av rating:
  • Total votes: 21
  • Total comments: 4

SQL Server Hardware

08 December 2010

SQL Server Hardware

Glenn Berry

Available to buy from Amazon.com and Amazon.co.uk.

Free EPUB and PDF versions available to download for Simple-Talk site members here.

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.

Why read this book?

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. It covers:

  • Current, and upcoming hardware, including processors, chipsets, memory, and storage subsystems
  • How to evaluate hardware for use with different types of SQL Server workloads
  • Strengths and weaknesses of the various versions and editions of Windows Server, and their suitability for use with different versions and editions of SQL Server
  • How to install, patch and configure the operating system for use with SQL Server
  • SQL Server editions and licenses
  • Installing and configuring SQL Server, including how to acquire and install service packs, cumulative updates, and hotfixes
  • Methods for quickly and easily upgrading to newer versions of the operating system and SQL Server with minimal downtime

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.

About the Author

Glenn Berry works as a Database Architect at NewsGator Technologies in Denver, 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 that 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. His blog can be found here and he is GlennAlanBerry on Twitter.

Glenn Berry

Author profile:

Glenn Berry is a Principal Consultant with SQLskills. He has worked as a SQL Server professional for many years in a variety of roles, most recently as Database Architect for Avalara in Parker, CO.

Glenn has been a SQL Server MVP since 2007, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection and configuration, and performance tuning. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College.

Glenn is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2 books.

Glenn's blog is at http://sqlserverperformance.wordpress.com/ and he can be reached by email at glenn@SQLskills.com and on Twitter at GlennAlanBerry.

Search for other articles by Glenn Berry

Rate this article:   Avg rating: from a total of 21 votes.


Poor

OK

Good

Great

Must read
Have Your Say
Do you have an opinion on this article? Then add your comment below:
You must be logged in to post to this forum

Click here to log in.


Subject: Price?
Posted by: Howserx (view profile)
Posted on: Tuesday, December 14, 2010 at 1:20 PM
Message: Do you know what the price will be? Even an approximation is good enough.

Subject: RedGate as always
Posted by: Dugi (view profile)
Posted on: Wednesday, December 15, 2010 at 10:59 AM
Message: As always publishing from RedGate are very welcome, worth to have this book in your home bookstore!

Subject: Availability
Posted by: tabibuitt (view profile)
Posted on: Tuesday, January 11, 2011 at 12:01 AM
Message: hopefully it will be available in INDIA/Pakistan as well ?

Subject: SQL Server Hardware
Posted by: haile (view profile)
Posted on: Saturday, May 14, 2011 at 3:29 PM
Message: We are in May. Where is the book?

 

Recommended site

PInvoke.net is a user-driven wiki which provides .NET developers with native method signatures, so they don't have to spend time writing them from scratch.

Check out PInvoke.net!

Top Rated

Book Review: Optimizing And Troubleshooting Hyper V Networking 2013
 If you want to learn how to optimize and troubleshoot Hyper-V, then this book, written by Microsoft... Read more...

Book Review: Windows Server 2012 Hyper-V Cookbook
 Windows Server 2012 Hyper-V Cookbook is a comprehensive resource for administrators and consultants... Read more...

The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman
 FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data... Read more...

Don't Just Roll the Dice - eBook Download
 Neil Davidson has created a short handbook with the theory, practical advice and case studies, to... Read more...

Captain Biplane: Interplanetary Airman
 Simple-Talk caters for the lighter side with its publication of 'Captain Biplane: Interplanetary... Read more...

Most Viewed

Troubleshooting SQL Server: A Guide for the Accidental DBA
 Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, provide... Read more...

Exchange 2010 - A Practical Approach
 Jaap's Practical Guide to Exchange Server 2010 draws upon all that experience to deliver an easy-to-use... Read more...

Brad's Sure Guide to SQL Server Maintenance Plans
 Brad's Sure Guide to Maintenance Plans shows you how to use the Maintenance Plan Wizard and Designer to... Read more...

Inside the SQL Server Query Optimizer
 This book will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the... Read more...

SQL Server Hardware
 SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent... Read more...

Why Join

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.