Application and Server Management
 

SQL Defrag Manager

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

Identify Index Fragmentation

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.

Schedule Jobs

Manage the defragmentation process through scheduling of jobs at the most optimal time and based on the size of the index.  Automate remediation and run the defragmentation utility immediately or during off-peak hours.

Avoid Contention

Check the utilization of key system indicators prior to execut­ing the defragmentation. This ensures that the policy is able to run as scheduled and avoid any potential system problems or application bottle­necks.

Manage Fill Factor

Most solutions don’t pay attention to the fill factor of tables, this can be a big drawback. With SQL defrag manager, users can manage index fill-factor settings and reduce splitting and shifting of pages as well as defrag job frequency.

Centralized management

The global dashboard displays all the SQL servers in your environment from one console, each database is color coded to reflect how much impact fragmentation is having on it, its databases, tables and indexes. You can easily sort to bring the items most in need of your attention to the forefront and take corrective action.

DOWNLOAD TRIAL
[Give it a try! Your trial is fully functional for 14 days]

With SQL defrag manager, I am able to quickly monitor fragmentation levels across multiple SQL Servers.  Not only does it save me a great deal of time over manual fragmentation analysis, it also puts my mind at ease. Now I can quickly determine if fragmentation levels are getting out of hand. It’s also very easy to use!

- Michael Perino, Sr. Database Manager, Community America Credit Union

We have quite a large SQL Server environment and ensuring performance levels, monitoring fragmentation, and defragmenting all of the hundreds of thousands of indexes in this environment could quickly become a full time job! Now I can quickly pinpoint fragmentation “hot spots” and automate the process of defragmentation to occur automatically. SQL defrag manager is extremely easy to use. I highly recommend it!

- Josh Boaz, SQL Server DBA, Computer Automation Systems