You can easily and quickly install SQL defrag manager SQL Defrag Manager on any computer that meets or exceeds the following hardware, software, and permission requirements. Consider the following requirements when installing SQL defrag manager in a typical environment.
TIPS | 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. SQL defrag manager 3.1 is SQL Server 2012 RTM compatible. This version of SQL defrag manager is not certified against newer builds of SQL Server and should not be used with these builds in a production environment. Idera provides experimental support while you use your installation in a testing environment to ensure the features you rely on most are working as, or better than, expected. |
SQL Defrag Manager in a typical environment.
General product requirements
All SQL Defrag Manager General Product Requirements
All SQL defrag manager components require the following software:
- Microsoft .NET Framework version 24.08
- MDAC 2.8 or later
- Windows Installer 3.1 or later
Typical
...
installation
A typical installation sets up all SQL defrag manager SQL Defrag Manager components on the same computer. The following table lists the requirements for a typical installation.
Type | Requirement |
---|
CPU | 2 GHz |
Memory | 2 GB |
Hard |
Disk Space GB for GB for the Repository |
Operating |
Systemsystem | One of the following operating systems: |
2000 Server SP4 or later- Server 2008 R2 SP1
Windows Server
|
2003 SP1 or later Vista Enterprise or Business 7Server 2016 - Windows Server
|
2008 2008 R2- 2022
Windows 7 SP1+ Windows 8 Windows 10 - Windows 11
|
Microsoft SQL Server (Repository) | One of the following versions of Microsoft SQL Server: |
Microsoft SQL Server 2000 Standard Edition SP4 or laterMicrosoft SQL Server 2000 Enterprise EditionMicrosoft SQL Server 2005 Standard or EnterpriseMicrosoft SQL Server 2005 SP2 or later on VistaMicrosoft SQL Server 2008 Standard or EnterpriseMicrosoft SQL Server 2008 R2 Standard or Enterprise- SQL Server 2005 Standard or Enterprise
- SQL Server 2008 R2 Standard or Enterprise
- SQL Server 2012 Standard or Enterprise
- SQL Server 2014 Standard or Enterprise
- SQL Server 2016 Standard or Enterprise
- SQL Server 2017 Standard or Enterprise for Windows and Linux
- SQL Server 2019 Standard or Enterprise for Windows and Linux
- SQL Server 2022 Standard or Enterprise for Windows and Linux
|
Microsoft SQL Server 2012 RTM |
Microsoft SQL Server (Managed Server) | One of the following versions of Microsoft SQL Server: |
Microsoft - SQL Server 2000 Standard or Enterprise
|
Microsoft - SQL Server 2005 Standard or Enterprise
|
Microsoft - SQL Server 2008 R2 Standard or Enterprise
|
Microsoft 2008 R2 - 2012 Standard or Enterprise
|
Microsoft SQL Server 2012 RTM...
- SQL Server 2014 Standard or Enterprise
- SQL Server 2016 Standard or Enterprise
- SQL Server 2017 Standard or Enterprise for Windows and Linux
- SQL Server 2019 Standard or Enterprise for Windows and Linux
- SQL Server 2022 Standard or Enterprise for Windows and Linux
|
Note |
---|
SQL Defrag Manager now supports Azure. SQL Defrag supports any IaaS deployments for all the SQL versions mentioned above. |
Console-only installation
A Console-only installation installs the SQL defrag manger SQL Defrag Manger Console. The Console-only installation assumes that a full installation already resides on another computer. The following table lists the requirements for a Console-only installation.
Type | Requirement |
---|
CPU | 2 GHz |
Memory | 2 GB |
Operating |
Systemsystem | One of the following operating systems: Windows Server 2008 R2 Windows Server 2012 Windows
|
2000 SP4 or later 2003 SP1 or laterWindows Vista (Enterprise or Business)Windows XP SP2...
2016 Windows 7 Windows 8 Windows 10 - Windows 11
|
Management Service permission requirements
The Windows user account used by the Management Service requires the following permissions to access the SQL Server instances you want to manage.
Permissionspermissions | Local Administrator permissions on the computer hosting the Management Service. |
SQL Server PrivilegesSQL Server privileges | A member of the sysadmin fixed server role |
on SQL Server SQL Server instance hosting the Repository and on each managed |
SQL Server instance.
Need more help? Search the Idera Customer Support Portal
...
SQL Server instance. |
Ports | SQL Defrag Manager service uses port TCP 5280. |