FREE DOWNLOAD OPEN BOOKS

SQL Server Hardware

SQL Server Hardware

by Glen Berry


DOWNLOAD EBOOK READ ONLINE SHARE BOOK QR CODE

Book Description

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.

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.

This open book is licensed under a Creative Commons License (CC BY). You can download SQL Server Hardware ebook for free in PDF format (9.0 MB).

Report an issue

Table of Contents

Chapter 1
Processors and Associated Hardware
Chapter 2
The Storage Subsystem
Chapter 3
Benchmarking Tools
Chapter 4
Hardware Discovery
Chapter 5
Operating System Selection and Configuration
Chapter 6
SQL Server Version and Edition Selection
Chapter 7
SQL Server Installation and Configuration
Appendix A
Intel and AMD Processors and Chipsets
Appendix B
Installing a SQL Server 2008 R2 Cumulative Update
Appendix C
Abbreviations

Book Details

Subject
Computer Science
Publisher
Red Gate
Published
2011
Pages
318
Edition
1
Language
English
ISBN13 Digital
9781906434625
ISBN10 Digital
190643462X
PDF Size
9.0 MB
License
CC BY

Related Books

SQL Server Internals: In-Memory OLTP
SQL Server Internals: In-Memory OLTP

by Kalen Delaney

The SQL Server 2016 In-Memory OLTP engine (a.k.a. Hekaton) is designed to exploit terabytes of available memory and high numbers of processing cores. It allows us to work with memory-optimized tables and indexes, and natively compiled stored procedures, in addition to the disk-based tables and indexes, and T-SQL stored procedures, that SQL Server h...

Defensive Database Programming with SQL Server
Defensive Database Programming with SQL Server

by Alex Kuznetsov

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment. Too often as deve...

Data Science with Microsoft SQL Server 2016
Data Science with Microsoft SQL Server 2016

by Buck Woody, Danielle Dean, Debraj GuhaThakurta, Gagan Bansal, Matt Conners, Wee-Hyong Tok

R is one of the most popular, powerful data analytics languages and environments in use by data scientists. Actionable business data is often stored in Relational Database Management Systems (RDBMS), and one of the most widely used RDBMS is Microsoft SQL Server. Much more than a database server, it's a rich ecostructure with advanced analytic capab...

Migrating SQL Server Databases to Azure
Migrating SQL Server Databases to Azure

by Carl Rabeler

SQL Server is Microsoft's relational database management system (RDBMS). SQL Server can now be hosted entirely in Microsoft Azure, either in a hosted virtual machine (VM) or as a hosted service. Hosting a virtual machine in Azure is known as infrastructure as a service (IaaS), and hosting a service in Azure is known as platform as a service (PaaS)....

Microsoft SQL Server Notes for Professionals
Microsoft SQL Server Notes for Professionals

by GoalKicker

The Microsoft SQL Server Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....

Performance Tuning with SQL Server Dynamic Management Views
Performance Tuning with SQL Server Dynamic Management Views

by Louis Davidson, Tim Ford

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions. Why, then, aren't all DBAs using them? Why do many DBAs continue to ignore them in favour of "tried an...