SQL Server Hardware - Redgate Software


SQL Server Hardware

Download free PDF

Download your free eBook.

About the eBook

by Glen Berry

Buy from Amazon.com
Buy from Amazon.co.uk

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.

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.


  • Twitter
  • Facebook
  • Google+
  • LinkedIn

You may also like

Case study

How Payment Sense cut provisioning time 85%

Read about how Payment Sense, the UK’s largest merchant service provider, cut provisioning time by 85% and transformed the way teams …


Troubleshooting SQL Server: A Guide for Accidental DBAs

Learn the steps and techniques three SQL Server MVPs use day-to-day to troubleshoot real SQL Server performance problems.


Fundamentals Of SQL Server 2012 Replication

All you need to decide whether replication is the right feature to use and which type of replication is the most advantageous in your s…