SQL Defrag Manager provides a robust, easy-to-use SQL Server solution. Behind a friendly user interface, SQL Defrag Manager offers a unique architecture that is both flexible and extremely powerful. SQL Defrag Manager fits your environment, no matter how simple or complex.

Product components

SQL Defrag Manager consists of a light, unobtrusive architecture that easily runs in your SQL Server environment with minimal configuration. All SQL Defrag Manager components run outside and separate from SQL Server processes. SQL Defrag Manager does not add to or modify any of your native SQL Server files or services.

SQL Defrag Manager Console

The SQL Defrag Manager Console is the interface you use to configure SQL Defrag Manager, view analysis and defragmentation results, schedule automation activities, and perform other related functions.

SQL Defrag Manager Repository

The SQL Defrag Manager Repository is a central storage area for configuration information, as well as fragmentation data and statistics collected by the Management Service.

Management Service

The SQL Defrag Manager Management Service gathers fragmentation data from your managed SQL Server instances and stores the information in the SQL Defrag Manager Repository database. The Management Service also controls scheduling activities.

Managed instances

The managed instances are the SQL Server instances you registered with SQL Defrag Manager. SQL Defrag Manager periodically analyzes and optimizes these instances based on the management settings you specified. SQL Defrag Manager stores this collected data in the SQL Defrag Manager Repository and displays the data in the SQL Defrag Manager Console.

Product architecture

The following diagram illustrates the components of the SQL Defrag Manager architecture.



  • No labels