Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Configuring a server storage system for scalability


The scalability and performance is guaranteed when the reliable storage is configured at the hardware level. In general, the storage configuration and management is handled by the Storage Administrators and it is a compulsory exercise for an organization to involve DBAs at configuration level that will shape up a well-built database server on hardware perspectives.

The reliability characteristics and performance implications depend on the RAID configuration, and in this chapter we will go through the best practice layout in configuring a server storage system for scalability. When deploying a new SQL Server instance or performing a scale-out exercise of an existing SQL Server platform, it is important to have an overall understanding of the key file types that are essential for a database. The file type's workload along with the database type and size enables both storage administrators and DBAs to establish necessary storage requirements...