O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required