SQL Defrag Manager

 Like

Find and Fix SQL Fragmentation.

License model

Country of Origin

  • US flagUnited States

Platforms

  • Windows
  No rating
0likes
0comments
0news articles

Features

Suggest and vote on features
  1.  Database Management Tool

 Tags

SQL Defrag Manager News & Activities

Highlights All activities

Recent activities

Show all activities

SQL Defrag Manager information

  • Developed by

    US flagIdera
  • Licensing

    Proprietary and Commercial product.
  • Alternatives

    4 alternatives listed
  • Supported Languages

    • English

Our users have written 0 comments and reviews about SQL Defrag Manager, and it has gotten 0 likes

SQL Defrag Manager was added to AlternativeTo by bpursley on May 11, 2015 and this page was last updated Jun 17, 2024.
No comments or reviews, maybe you want to be first?
Post comment/review

What is SQL Defrag Manager?

  • 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.