SQL defrag manager v1.2 improves SQL Server database performance by automating the lengthy process of analyzing and fixing database index fragmentation levels and issues across multiple SQL servers.
Idera's SQL defrag manager v1.2 is a product that automates the time-consuming process of finding and fixing database index fragmentation issues across multiple SQL Server instances. 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 of your SQL Server databases, from one server to an enterprise-scale implementation.
Database administrators can view activity in real time to quickly expose fragmentation problem areas. SQL defrag manager's three methods for performing fragmentation analysis or defragmentation are automated scheduling; semi-automated, using a to-do list; and scheduling manually on your own terms.
SQL defrag manager also provides reports and metrics from the enterprise level down to individual indexes. It allows for simple and automated methods of detecting, prioritizing and fixing your worst fragmentation problems.
Detailed metrics provide the following information:
- Fragmentation percentage
- Index and table size
- Free bytes
- Page density
- Rate of fragmentation increase
- Defragmentation methods and post-run results
- Time to execute
System requirements: Hardware and software requirements for version v1.2 include: Management consoles: Windows 2000 SP3+, Windows XP SP2+ or Windows Server 2003 SP1+, Windows Vista, Microsoft .NET 2.0. Management servers and data repositories: Windows 2000 SP3+, Windows XP SP2+ or Windows Server 2003 SP1+, Windows Vista, Microsoft .NET 2.0. Repositories: SQL Server 2000 (all versions and service packs) (32-bit and 64-bit), SQL Server 2005 (all versions and service packs) (32-bit and 64-bit). Supported SQL Server environments for defragmentation are SQL Server 2000 or SQL Server 2005.
Pricing: SQL defrag manager v1.2 is $995 per SQL Server instance.
This was first published in January 2008