Hardware for SQL Server: Optimizing performance

Last updated:September 2013


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.

1Choosing SQL Server hardware-

Selecting SQL Server hardware: Expert advice

Making the right hardware selections for SQL Server is important because hardware plays a part in performance and can facilitate virtualization efforts and other functions. The stories in this section offer advice on what to look for when purchasing SQL Server hardware, as well as common mistakes to avoid.


Helpful advice for choosing SQL Server hardware

In order to optimize SQL Server BI performance, keep these three pointers in mind when choosing hardware. Continue Reading


Mistakes to avoid when purchasing hardware for SQL Server

Learn what not to do when selecting hardware for SQL Server. Strong performance depends on the right choices. Continue Reading


Expert tips for choosing SQL Server virtualization hardware

Buying hardware for a virtualization host that runs SQL Server is different from selecting hardware for SQL Server itself. These tips will help you make informed decisions when buying hardware for SQL Server virtualization. Continue Reading


Keeping up with SQL Server hardware trends

This article describes trendy offerings for SQL Server, such as iSCSI and blade servers. Continue Reading


How to identify your SQL Server hardware needs

Evaluate all the factors for SQL Server hardware needs over time by reviewing the insights in this guide. Continue Reading

2Enhancing performance-

SQL 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.


Boost performance with these three SQL Server hardware upgrades

Get tips for choosing SQL Server hardware upgrades that will give performance a kick. Continue Reading


Fine-tune SQL Server performance with disk arrays and disk partitioning

Learn how to maximize hardware performance with correct disk array configuration and disk partition alignment. Continue Reading


Enhance SQL Server scalability with these four tips

Scaling up is easier than scaling out. Apply these four tips to produce optimum performance. Continue Reading


Best practices for SQL Server clustering

A cluster service arbitrates ownership of the resource groups. Achieve high availability by sharing server resources over several nodes with SQL Server clustering. Continue Reading


How to identify SQL Server storage requirements

The earlier and more accurately you set your storage needs, the more precise the system budget will be. Figure out storage requirements during the development phase -- before you order production hardware. Continue Reading

3Best practices-

Best 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.


Quick guide to SQL Server consolidation

In this guide, you'll find strategies and best practices for SQL Server consolidation. Continue Reading


SQL Server consolidation: What are the benefits?

Managers and DBAs have several options for SQL Server consolidation. Learn some of the strategies and details in this article. Continue Reading


How to create fault-tolerant SQL Server installations

Read about traditional fault-tolerance configuration options, like failover clustering, and updated options, like database mirroring. Continue Reading


Simplify SQL Server failovers with these hardware considerations

Learn failover methods and hardware considerations that will help should you need to go to the last resort. Continue Reading


Expediting SQL Server backup and restore tasks

Gain insights into improving performance time for hardware, native backups and restores and third-party software. Continue Reading

Join the conversation


Send me notifications when other members comment.

Please create a username to comment.


How much space or how many gig I will be using if i keep 943309 scanned and indexed pages on the server.
That's going to depend largely on what resolution the images were scanned at, the compression type, and the color bit-depth. Also, the number and type of fields is going to matter regarding index size. For the scanned pages ONLY, a best-case scenario is going to be about 22 GB. (for 200 dpi B/W CCIT G4) though so much is scanned in color now, it would likely be much more.