White Papers

Deploying SQL Server on ME4 Series storage
13 Dell EMC PowerVault ME4 Series and Microsoft SQL Server | 3923-BP-SQL
Frequent data modifications can also lead to fragmentation within SQL Server data files, producing
unnecessary I/O. Fragmentation can be addressed through index reorganization or rebuilds as part of regular
database maintenance.
The database maintenance process itself can also have a large I/O impact. Typically, every table and index
does not need to be rebuilt or reorganized every time maintenance is run. In addition, table partitioning
strategies can also be leveraged to make the maintenance process more selective. Consider implementing
intelligent maintenance scripts that utilize usage statistics to perform maintenance on an as-needed basis.
For mission-critical databases, maintenance activities need to be considered as part of the overall design. If
maintenance is not considered as part of the overall process, issues can arise such as unmanageable sizes
and feature incompatibilities that limit available options and strategies.