[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 Hardware Sizing Microsoft SQL Server
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
SQL Server 2008
SQL Server 2012
SQL Server 2014
Tips
Troubleshooting
Tuning

Hardware Sizing Microsoft SQL Server


The following are some resources to help determine hardware needs for Microsoft SQL Server deployments.

 

Recommended blog posts.

1. SQL Server Sizing Resources by Bart Duncan (MSFT).

2. Business Intelligence - how to determine the configuration settings for a data mart or warehouse project - notes from field. (Business Intelligence)

 

Tools from Microsoft and Hardware Vendors.

1. HP ProLiant Transaction Processing Sizer for Microsoft SQL Server 2005/2008 (x64).

2. SQL Server DataSizer Tool.


Sizing an OLAP Solution.

1. Scale-Out Querying with Analysis Services - SQL Server Best Practices Article. Sizing Guidelines.

2. Scaling Up Your Data Warehouse with SQL Server 2008.

3. Hardware Sizing a Tabular Solution (SQL Server 2012).
 

Useful documentation.

1. SQL Server Best Practices Article. Predeployment I/O Best Practices.

2. Analyzing I/O Characteristics and Sizing Storage Systems for SQL Server Database Applications.

3. Analyzing I/O Characteristics and Sizing Storage Systems for SQL Server Database Applications. Section "Sizing Considerations for the Physical Storage Components", page 11.

4. Server sizing recommendations for Microsoft SQL Server 2005.

5. Hardware and Software Requirements for Installing SQL Server 2008 R2.


 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.