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
About the Author
About the Reviewers
More DBA Manageability Best Practices

Configuring and managing storage systems for optimized defragmentation processes

The database fragmentation can be addressed by using native DBCC statements, and when it comes to physical storage system fragmentation then professional grade disk defragmentation software is essential. There is not much SQL Server-related technical details provided in this recipe, and most of the time the storage level tasks may not be a direct-responsibility for a DBA, where storage level administrators will manage the disk subsystem. In this recipe, we will go through the best practice process in configuring and managing the storage system for optimized defragmentation methods.

Getting ready

The following are the referred best practices to configure the storage for the database server to reduce any fragmentation.

  • SQL Server 2008 R2 and Windows Server 2008 R2

  • Using 64-bit operating system and software servers

  • Using a dedicated server for SQL Server and application database

  • The application requirement of processing...