Hardware for SQL Server: Optimizing performance

Last updated:September 2013

Editor's note

Making the best hardware choices for SQL Server is important to ensure efficiency, performance and an appropriate storage configuration. SQL Server hardware choices also impact scalability and BI systems. With more and more businesses moving to SQL Server virtualization, IT administrators should recognize how proper hardware selection facilitates workload management, consolidation and high availability. Scaling out with SQL Server is also complicated, entailing partitioned databases, federation and more. Often organizations scale up first.

Database administrators often find the decision-making process for choosing hardware for SQL Server challenging; they must select cost-effective hardware options while considering new technology advancements and various requirements. Building a SQL Server system is a complex task. How do you know which SQL Server tools are most important for your organization's needs?

This Essential Guide delivers expert advice on selecting SQL Server hardware, enhancing hardware performance, and instituting server consolidation and disaster recovery best practices.

1SQL Server hardware requirements: Performance, scalability and availability

Read tips from contributors in this section on meeting storage, performance, scalability and availability requirements for SQL Server hardware, including how to optimize performance with upgrade recommendations.

2Best practices for SQL Server consolidation, backup and disaster recovery

When it comes to server consolidation and disaster recovery, experts have advice for making good hardware decisions for SQL Server. The stories in this section explore proven strategies for successfully handling consolidation, failovers and backups and restores.