Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server Hardware

By Glenn Berry,

High Performance SQL Server

SQL Server HardwareSQL Server Hardware by Glenn Berry

Buy Printed Book: $29.99
Buy Kindle Edition: $14.99
Download eBook (PDF): Free


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.


Editorial Review

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.


Publisher: Red Gate Books

View Related Books:

Total article views: 9745 | Views in the last 30 days: 46
 
Related Articles
FORUM

Development server configuration(hardware)

Development server configuration(hardware)

BLOG

System Configuration Check – Without Starting SQL Server Installation

Question : Can we do system configuration check with starting SQL Server installation? One of my fri...

FORUM

What is the "ideal" hardware configuration for SQL Server 2008

What is the "ideal" hardware configuration for SQL Server 2008

FORUM

Server Hardware Sizing

Guidelines for server hardware sizing

FORUM

Configure Server Hardware

how to configure server hardware details with help of bandwidth,size of data,no. of concurrent user...

Tags
books    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones