281.937.7618      

Overview

SQL DataBase Defragmenter (SQLDBD)

  • "Senses and responds" to SQL Server *.MDF & Index fragmentation hot-spots
  • Selectable database MDF defragmentation ,allows remaining databases to be available during defragmentation process
  • Provides policy driven functionality for selected databases and indexes without taking the entire server offline
  • Tracks index page splits and provides fill factor management
  • Provides informative dashboard for summarization of all Fragmentation hotspots, activities


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

  • Set fragmentation threshold for MDF and or Index files
  • Run Now
  • Schedule to Run during maintenance outages


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.