Database Reference
In-Depth Information
19. The command-line operation usage of PageDefrag is:
Usage: pagedefrag [-e | -o | -n] [-t <seconds>]
-e
Defrag every boot.
-o
Defrag once.
-n
Never defrag.
-t
Set countdown to specified number of seconds.
This completes the essential steps in configuring and managing the storage system for
optimized defragmentation processes.
It is highly essential to perform the preceding steps during the preferred
maintenance window, which will work out as defragmentation activities.
How it works...
The storage level defragmentation needs to be addressed on a regular basis where many
third-party tools are available in the market. In this recipe, we have used the Windows
Sysinternals suite that offers many tools to accomplish the tasks. Initially, we overviewed
the disk and storage configuration at the deployment level, then choosing two tools that
are essential and helpful in defragmenting the storage level that is outside of the SQL
Server environment.
As a best practice, these methods must be followed
whenever the fragmentation level is higher than 40 percent
or half-yearly if the database system is highly transactional.
By default, the Contig tool uses the Windows NT defragmentation support that is introduced
in NT 4.0 version; it will scan the disk collecting the locations and sizes of free areas. Then, it
decides whether the file can be optimized based on the free areas and number of fragments
the file currently consists of.
The PageDefrag tool can be used as a one-time operation to defragment the paging files and
registry hives. It is recommended to test the tool in the development environment to ensure
that no problems occur for SQL Server operations. Internally, the tool will use the Windows
chkdsk operation on hard drives during the boot time startup of the server.
Search WWH ::
Custom Search