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 2000 database and select the Thorough 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 CPU Load Percentage (Total Server) 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 Rediscover server objects 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 Rediscover server objects.