Senses and responds to MDF Fragmentation
Query performance is directly tied to primary database file and Index fragmentation. Inserting and deleting rows from the tables and indexes adversely affects the database structure, causes fragmentation and the sorted order of the indexes. SQL Database Defragmenter detects this fragmentation and defragments the MDF file and indexes for complete SQL Server defragmentation
Selectable Primary Database defragmentation
There are often many databases in a single SQL Server instance. One or more of these databases may have a fragmented primary database file. When this happens the entire instance must be taken offline to address the fragmented primary database file. SQLDBD allows you to select individual databases for defragmentation, and leaves the remaining databases online for business processing
Customized Policies
SQL DBD lets you create your own defragmentation policies against any database and or index in your environment for fragmentation
Index Management
SQL DBD lets you manage the fill factor settings for your index pages to help minimize the frequency of index page splitting. Solutions for Information Technology
Web-based Dashboard
SQL DBD provides a web-based portal that centralized all fragmentation hotspots for primary databases and indexes. In addition it gives you real time status for defragmentation jobs and alerts
Policy-base fragmentation management
SQL DBD database fragmentation is identified by SQL Database Defragmenter (SQL DBD). SQL DBD allows you to specify the fragmentation threshold for the primary data file. Once the threshold is exceeded the defragmentation process will begin during a predetermined maintenance outage. SQL DBD will automatically sense and respond, take the individual database offline and leave the remaining databases online for business. In addition, SQL DBD will also rebuild your indexes, stored procedures, update statistics and bring your database online.
Pre fragmentation management
SQL DBD database fragmentation is identified by SQL Database Defragmenter (SQL DBD). SQL DBD allows you to specify the fragmentation threshold for the primary data file. Once the threshold is exceeded the defragmentation process will begin during a predetermined maintenance outage. SQL DBD will automatically sense and respond, take the individual database offline and leave the remaining databases online for business. In addition, SQL DBD will also rebuild your indexes, stored procedures, update statistics and bring your database online.