Español
 
 

SQL defrag manager

Automate & optimize database defragmentation

Bullet image Take Tour
Bullet image Product Datasheet

 

Product Highlights:

  • Automates analysis of index fragmentation levels
  • Identifies fragmentation “hot spots”
  • Takes action to defragment indexes automatically, or at user discretion
  • Provides central management and detailed reporting

Download Now

Screen shot
Click to enlarge
 

SQL defrag manager is a one-of-a-kind solution that automates the time-consuming process of finding and fixing database index fragmentation issues across multiple SQL Servers. SQL defrag manager improves server performance by analyzing database index fragmentation levels in real-time, pinpointing fragmentation "hot spots" and taking action to defragment automatically, or at your command.

SQL defrag manager is simple to install, configure and use across all your SQL Servers, from one server to an enterprise-scale implementation. DBAs view activity in real-time, quickly exposing fragmentation hot spots. SQL defrag manager provides three methods for performing fragmentation analysis or defragmentation: scheduled policy-based automation, semi-automated using a to-do list, and ad-hoc. SQL defrag manager provides reports and metrics from the enterprise level down to individual indexes. SQL defrag manager automation policies are like a DBA autopilot for fragmentation management across your entire enterprise. Tell it where to go and how to get there with as little or as much detail as you’d like.

 
 
Improve SQL Server Performance
As index fragmentation increases over time, performance degrades, response times slow, and I/O suffers. SQL defrag manager continuously monitors fragmentation levels and takes automated action to resolve fragmentation issues, resulting in better, more consistent server performance.
Automated Analysis
SQL defrag manager performs automated analysis of key fragmentation metrics to quickly pinpoint fragmentation hot spots, those areas where fragmentation is severely hindering performance.
“Smart” Policy-Based Remediation
SQL defrag manager provides three levels of automation for performing defragmentation:

Policy-Based
  • Automated: SQL defrag manager automatically takes action according to user-specified parameters and fragmentation levels. Unlike brute force scripts or maintenance plans, SQL defrag manager takes the most appropriate actions at the best times.
  • Semi-automated: SQL defrag manager generates to-do list items to highlight fragmentation problem areas. You can then address the issues how and when you want with the click of a button.
Manual
  • Ad-hoc: You can initiate fragmentation analysis manually, and initiate remediation actions at your own discretion.
Centralized Management
The SQL defrag manager management console provides a real-time window into fragmentation levels, and the ability to view and manage defragmentation activity across hundreds of servers and thousands of databases.
Comprehensive Reporting
SQL defrag manager provides comprehensive reporting of analysis and defragmentation activity, giving DBAs and managers the information they need to ensure that database performance is continuously optimized.
 
 
 
  Idera Counted Among Top Finalists for the 2008 Microsoft Partner of the Year Award  
More
  Idera Adds 6 More Tools to SQL admin toolset Free Public Beta: Database administrators say product is a ‘must have’  
More
  PRODUCT REVIEW: "Stop Wasting Time Guessing About Your Server’s Health and Start Being Proactive"  
View PDF
  SQL Server Performance Tuning Myths  
More
  ON DEMAND WEBCAST: SQL Server 2008 First Look  
More
  ON DEMAND WEBCAST: Fragmentation: Fact & Fiction  
More
  SQL Server Fragmentation Explained  
Download
 
 
     Home  |  Products  |  Downloads  |  Support  |  Customers  |  Partners  |  About Us  |  Resources  |  Resources  
   Copyright © 2004-2008 BBS Technologies, Inc. |  Legal |  Privacy Policy |  Sitemap |  Contact Us