Resources on Capacity and IO Planning

I am posting some collection of links and resources related with capacity planning, plan for performance, and IO planning. This is also a kind of note to self, so it will be easier for me to find out those links in the future.

 

Estimating the Size of a Clustered Index
http://msdn.microsoft.com/en-us/library/ms178085.aspx

Estimating the Size of a Database
http://msdn.microsoft.com/en-us/library/ms187445.aspx>

Proper I/O Capacity Planning and Configuration Resources for SQL Server
http://blogs.msdn.com/b/askjay/archive/2011/03/25/proper-i-o-capacity-planning-and-configuration-resources-for-sql-server.aspx

Predeployment I/O Best Practices
http://technet.microsoft.com/en-us/library/cc966412.aspx

Physical Database Storage Design
http://technet.microsoft.com/en-us/library/cc966414.aspx

Storage and SQL Server capacity planning and configuration
http://technet.microsoft.com/en-us/library/cc298801.aspx

Storage Performance Testing with SQLIO
http://www.brentozar.com/archive/2008/11/storage-performance-testing-with-sqlio/

SQLIO Tutorial: How to Test Disk Performance
http://www.brentozar.com/archive/2008/09/finding-your-san-bottlenecks-with-sqlio/

Leave a Reply