You can easily and quickly install 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.
| Info |
|---|
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. |
General product requirements
...
- Microsoft .NET Framework version 24.08
- MDAC 2.8 or later
- Windows Installer 3.1 or later
...
A typical installation sets up all 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 | 30 GB for the Repository |
| Operating system | One of the following operating systems: |
2000 Server SP4 or later- Server 2008 R2 SP1
Windows Server 2012 Windows Server 2012 R2 Windows Server
|
2003 SP1 or later Vista Enterprise or Business- Server 2019
Windows 7 SP1+ Windows
|
Server 2008 Server 2008 R2 |
Microsoft SQL Server (Repository) | One of the following versions of Microsoft SQL Server: |
Microsoft 2000 Edition SP4 laterMicrosoft 2000 - 2008 R2 Standard or Enterprise
|
EditionMicrosoft 2005 - 2012 Standard or Enterprise
|
Microsoft 2005 SP2 or later on Vista- 2014 Standard or Enterprise
- SQL Server 2016
|
Microsoft SQL Server 2008 Microsoft SQL Server 2008 R2 - SQL Server 2017 Standard or Enterprise
|
Microsoft SQL Server 2012 RTM- for Windows and Linux
- SQL Server 2019 Standard or Enterprise
|
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
|
| 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 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 system | 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 SP22016 Windows 7 Windows 8 Windows 10
|
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.
| Type | Requirement |
|---|
| Windows permissions | Local Administrator permissions on the computer hosting the Management Service. |
| SQL Server privileges | A member of the sysadmin fixed server role in the SQL Server instance hosting the Repository and on each managed SQL Server instance. |
| Ports | SQL Defrag Manager service uses port TCP 5280. |
Need more help? Search the Idera Customer Support Portal
...