Application and Server Management
Buy Now .Live Chat Live Chat
 
GET
TOOLS & TRIALS

SQL defrag manager

Find and fix SQL fragmentation hot spots in seconds

  • 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
DOWNLOAD TRIAL

  • Purchase

    Like this? You'll love what comes next.

    $1,195 per instance


    Buy it Now

  • Product Video

    Got 5 minutes? See the product in action. 


    Watch It Now

  • Request More Info

    Questions? Need a price quote? Talk to us.

    Request Info

  • Data Sheet

    Need more info? We have a pretty color brochure for that.

    Get it Here

“ 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

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.

 

Customizable Defragmentation Control

Defrag processes can be triggered by fragmentation percentage or scan density, and prioritized based on fragmentation level, scan density, or index size. Additionally, defrag operations can be limited to the “top x” worst indexes, or by a “hard stop” time.

Policy-based Management

Defragmentation policies can be applied at the server, database or index level to apply the same defragmentation management policy to multiple objects all at once. Changing the policy changes the defragmentation approach across all objects simultaneously.

Index Management

Specify how much free space SQL Server should leave on an index page via the fill factor settings to limit page splitting and shifting. This helps you to decrease the frequency of your index rebuilds and improve the performance and availability of your SQL server applications.

Proactive System Resource Checks

Ascertain the utilization of key system resources prior to executing the defragmentation utility. If the metric is at a customer defined threshold, the execution of the defrag operation will either be delayed, prevented or run as scheduled.

 

Email Notification

Provides an early warning system to the database administrator. If the resource check detects that a user defined threshold has been exceeded prior to executing the utility, an email alert is sent to the DBA. Email alerts are also sent to notify a DBA when a defrag job has completed normally.

Detailed Metrics

View detailed information such as fragmentation percentage, index and table size, free bytes, page density, rate of fragmentation increase, defragmentation methods, post-run results, and time to execute.

Comprehensive Reporting

Built-in reports geared to technical or managerial audiences highlight the worst fragmented servers, databases, tables/indexes, reclaimed resources, and other key fragmentation related information. Users can quickly and easily access these reports on demand.

Improvement Savings Tracking

Reclaim resources from defrag jobs and track the total improvement on every object in your enterprise daily or over a year. You can even produce an annual report showing how much money has been saved through the use of the solution.

 

Central Enterprise Console

Enables rapid configuration as well as real-time monitoring of activity. This makes it easy to manage and track fragmentation over a large number of servers.

Dynamic Index Discovery

As databases, tables and indexes are created or deleted over time, SQL defrag manager automatically adds new objects and drops deleted objects on a daily basis to keep the overall database environment in top health.

Agent-less & Light-weight

Fragmentation details are intelligently collected based on customizable automation policies. SQL defrag manager is agent-less, simply running as a service, quietly in the background which keeps overhead on your servers low.

Easy installation and use

Installs quickly and supports a mixed environment of Windows integrated security and SQL Server native security. A typical installation and configuration will take less than 30 minutes.

 

Management Console

  • Windows 2000 SP4, Windows XP SP3, Windows Server 2003 SP2, Windows 2008 SP1, Windows Vista SP2+, Windows 7 SP1+, Windows 2008 R2, Windows 8, Windows 2012
  • Microsoft .NET 2.0 SP1

Management Server and Data Repository

  • Windows 2000 SP4, Windows XP SP3, Windows Server 2003 SP2, Windows 2008 SP1, Windows Vista SP2+, Windows 7 SP1+, Windows 2008 R2, Windows 8, Windows 2012
  • Microsoft .NET 2.0 SP1
  • Repository: SQL Server 2000, 2005, 2008, 2008 R2, 2012

Supported SQL Server Environments (for defragmentation)

  • SQL Server 2000 and SQL Server 2005
  • SQL Server 2008 R2
  • SQL Server 2012
SQL defrag manager does not install any components, DLLs, scripts, stored procedures or tables on the SQL Server instances being monitored.
 
TRY IT FOR FREE