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