Page History

Phase out SQL Defrag Manager Itanium support

IDERA is phasing out all Itanium support in SQL Defrag Manager 3.0 and all subsequent versions. SQL Defrag Manager 3.0 does not support the Itanium processor architecture and limited technical support is available through November 2012. For more information, see the product requirements.

SQL Server 2000 does not support Thorough analysis

If you select a SQL Server select a SQL Server 2000 database and select the the Thorough analysis analysis type, SQL Defrag Manager performs a Fast analysis for that database.

Small indexes can cause errors in the Recent Activity tab

Small indexes may not meet your fragmentation threshold levels and can cause SQL Defrag Manager to display errors on the Recent Activity tab. When SQL Defrag Manager analyzes and defragments a database, it displays an error message on the Recent Activity tab for each index that it cannot sufficiently defragment. Small indexes often have fragmentation levels that cannot be reduced. By default, SQL Defrag Manager excludes small indexes from the Fragmentation Explorer tab. You can also modify your automation policies to ignore the fragmentation level of small indexes.

Fragmentation level may not be updated

If an analysis process fails, SQL Defrag Manager does not update the fragmentation information displayed on the Fragmentation Explorer tab. SQL Defrag Manager displays that fragmentation information from the last successful analysis.

HTML column headings may be truncated

When you export information from a tab, such as the Scheduled Activity tab, to an HTML file, the column headings may be truncated for narrow columns. To avoid this issue, export the information to an XML file.

SQL Server may not list all instances

When you register instances on a server, SQL Defrag Manager may not list all instances on that server. You can add missing instances by name to register those instances.

Requirements for 64-bit support

SQL Defrag Manager supports the following 64-bit software versions:

• Microsoft Windows Server 2003 SP1
• Microsoft SQL Server 2005 Standard and Enterprise Editions

Disabling OLE can cause a resource check error

A policy configured to use the the CPU Load Percentage (Total Server) resource resource check does not work correctly if OLE is disabled on the server.

Non-clustered indexes automatically rebuilt with clustered indexes for SQL Server 2000 users

When a user with SQL Server 2000 performs a rebuild of a clustered index, SQL Server also rebuilds all non-clustered indexes. This issue occurs during all clustered index rebuilds, including when the user accepts a change to the fill factor settings as that feature requires a rebuild of the clustered index.

Partitions on partitioned indexes are not automatically recognized after an upgrade

Users with partitioned indexes and who upgrade from a previous version must use the the Rediscover server objects feature feature for SQL Defrag Manager to recognize partitions. To rediscover these objects, right-click the appropriate server name while in Fragmentation Explorer, and then select select Rediscover server objects.