ApexSQL is a comprehensive tool set that streamlines and automates SQL Server database management and development processes while also addressing security and compliance. With its expansive portfolio of products, ApexSQL enables SQL Server DBAs and developers to dramatically increase their efficiency without sacrificing the quality of their work or the safety of the databases.

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. Limit defragmentation to the worst indexes and by fixed time duration.

As index fragmentation increases over time, performance degrades, response times slow, and I/O suffers. SQL defrag manager performs an automated analysis of key metrics related to fragmentation to quickly pinpoint those areas where fragmentation is severely hindering performance, then triggers corrective measures.

Automate identification of index fragmentation "hot spots"
Schedule index defragmentation jobs
Avoid database contention with system resource pre-checks
Reduce page splits with index fill factor settings control
Centrally manage, report and notify instantly

Find and fix SQL fragmentation hot spots fast

Automate identification of index fragmentation "hot spots"
Schedule index defragmentation jobs
Avoid database contention with system resource pre-checks
Reduce page splits with index fill factor settings control
Centrally manage, report and notify instantly