SQL defrag manager allows me to configure automated index maintenance based on the fragmentation level of the individual indexes. The maintenance process runs each night, takes a fraction of the time it used to and has very little load impact. I find SQL defrag manager to be an indispensable tool in my day to day duties as a DBA.
HOUSTON (PRWEB) August 14, 2007
Over time, as data is inserted, updated, and deleted, databases become fragmented - a condition that adversely affects database performance, especially in large scale SQL Server environments. Fragmentation ranks as one of the top causes of poor database performance, yet the task of defragmentation is often neglected because it can be extremely time-consuming, labor-intensive, and often must be done in off-hours to avoid service interruption.
"SQL defrag manager is the first and only product that intelligently and safely automates the process of SQL Server database defragmentation," said Rick Pleczko, President and CEO at Idera, "It significantly increases DBA productivity by reducing the time spent finding and remediating fragmented tables and indexes and ensures the performance and availability of critical SQL Servers."
"One of the most difficult tasks in my day to day operations has been to maintain index optimization." commented Mike Flanagan, Senior DBA with Aries Systems Corporation, "SQL defrag manager allows me to configure automated index maintenance based on the fragmentation level of the individual indexes. The maintenance process runs each night, takes a fraction of the time it used to and has very little load impact. I find SQL defrag manager to be an indispensable tool in my day to day duties as a DBA."
Key features and benefits provided by SQL defrag manager include:
-- Improved SQL Server performance: SQL defrag manager continuously monitors fragmentation levels and takes automated action to resolve fragmentation issues, resulting in better, and more consistent database performance.
-- Automatic Analysis: SQL defrag manager automatically analyzes index and table fragmentation levels to quickly pinpoint "hot spots" or areas where performance is severely hindered.
-- Customizable Remediation: SQL defrag manager offers three easy options for performing SQL Server defragmentation:
-- Automated: Performs automatic remediation according to user-specified parameters and fragmentation levels.
-- Semi-automated: Performs automatic analysis and highlights fragmentation problem areas in a to-do list for subsequent 'one-click' remediation.
-- Manual: Initiate fragmentation analysis on demand and remediate manually as required.
-- Centralized Management: View fragmentation analysis in real-time and manage defragmentation activity across hundreds of servers and thousands of databases from a central console.
-- Comprehensive Reporting: Generate comprehensive reports of analysis and defragmentation activity providing proof that database performance is continuously optimized.
Pricing and Availability
SQL defrag manager is now available and is priced at $995 per SQL Server instance. More information about SQL defrag manager as well as a free, 14 day, fully-functional evaluation copy is available at: http://www.idera.com/products/sqldefrag
Idera delivers a new generation of tools for proactively managing, administering, and securing the world's fastest growing database management system - Microsoft SQL Server. Battle-proven and engineered for distributed enterprises, Idera's solutions help companies ensure database availability while also reducing tedious administrative tasks and expense. Idera's solutions include: Security and Compliance Management, Performance and Availability Management, Backup and Recovery, and Change and Configuration Management. Headquartered in Houston, Texas, Idera's products are sold and supported directly and via authorized resellers and distributors around the globe.
To learn more, please contact Idera at 713-523-4433 or visit http://www.idera.com.