Database administrators for SQL Server need to maintain the high availability and performance of their databases. Key areas that dramatically affect the performance of SQL Server are indexes that are fragmented and out of cluster. SQL Defrag Manager is a unique solution for defragmenting indexes for SQL Server. It automates the time-consuming process of finding fragmented indexes based on policies for the targeted databases.
Trigger defragmentation of database indexes by fragmentation percentage and scan density. Prioritize defragmentation by fragmentation level, scan density, and index size.
Apply policies for defragmentation of database indexes at level of instances, database, and indexes. Apply the same policy to multiple objects at simultaneously.
Specify how much free space SQL Server should leave on the index page via settings for fill factor to limit page splitting and shifting.
Ascertain utilization of critical system resources before starting defragmentation to delay, prevent, or run as scheduled.
When resource check detects that the metric exceeds user-defined threshold before executing the defragmentation of database indexes, it sends an email alert.
View detailed information such as fragmentation percentage, index and table size, free memory, page density, rate of increase of fragmentation, and more.
Access built-in reports that target technical and managerial audiences. Report on worst fragmented instances, databases, tables and indexes, and more.
Reclaim resources from defragmentation of database indexes and track total improvement on every object in SQL Server environment daily or over year.
The central console enables rapid configuration as well as real-time monitoring of activity. It makes it easy to manage and track fragmentation over a large number of instances.
As databases, tables, and indexes are created or deleted over time, automatically add new objects and drop deleted objects.
Collect fragmentation details intelligently based on customizable automation policies. Run agentless and quietly in the background as service.
Complete typical installation and configuration in minutes. Support mixed environment of Windows integrated security and SQL Server native security.
Unify your control by running SQL Defrag Manager on cloud virtual machines—such as Azure Virtual Machine (VM) and Amazon Elastic Compute Cloud (EC2).
Monitor your SQL Server instances running on cloud virtual machines—such as Azure VM and Amazon EC2.
Save time by using the same monitoring tool for SQL Server databases on-premises (on your physical and virtual machines); and in private, public, and government cloud (on virtual machines).
Get most out of cloud with cloud storage that is mapped as network drives or removable drives on Windows with SQL Defrag Manager. For example, map storage to Amazon Simple Storage Service (S3) and Azure Blob Storage.
Everything you need to know, all in one downloadable PDF
See the main features and benefits of SQL Defrag Manager
Learn about its automated analysis, intelligent remediation, continuous improvement, centralized management, granular retrospective analysis, and more.
Learn about fragmentation, the different types, how to defragment, how to compact data, and about interleaved indexes.
Dave Walden presents the different types of indexes, index statistics, how to use indexes to improve queries, and more.
Learn about the detailed mechanics behind fragmentation and how defragment to improve performance