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.

General product requirements

All SQL Defrag Manager components require the following software:

  • Microsoft .NET Framework version 4.8
  • MDAC 2.8 or later
  • Windows Installer 3.1 or later

Typical installation

A typical installation sets up all SQL Defrag Manager components on the same computer. The following table lists the requirements for a typical installation.

TypeRequirement
CPU2 GHz
Memory2 GB
Hard disk space30 GB for the Repository
Operating system

One of the following operating systems:

  • Windows Server 2008 R2 SP1

  • Windows Server 2012

  • Windows Server 2012 R2

  • Windows Server 2016

  • Windows Server 2019

  • Windows 7 SP1+

  • Windows 8

  • Windows 10

Microsoft SQL Server (Repository)

One of the following versions of Microsoft SQL Server:

  • 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

Microsoft SQL Server (Managed Server)

One of the following versions of Microsoft SQL Server:

  • SQL Server 2000 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

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.

TypeRequirement
CPU2 GHz
Memory2 GB
Operating system

One of the following operating systems:

  • Windows Server 2008 R2

  • Windows Server 2012

  • Windows Server 2012 R2

  • Windows Server 2016

  • 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.

TypeRequirement
Windows permissionsLocal Administrator permissions on the computer hosting the Management Service.
SQL Server privilegesA 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.



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal


  • No labels