The Technical Specifications show requirements at a high level. For more detailed information, including required permissions and recommended server sizing guidelines, see the topics listed under Installation and Deployment .

What's New

For the new features and fixed issues in the latest version of SQL Defrag Manager, see New Features.

System Requirements

Type

PlatformVersion
Operating System (for host and management service)

Microsoft Windows
  • 10
  • 8
  • 7 SP1+ (management service)
  • 7 (host)
Microsoft Windows Server
  • 2019
  • 2016
  • 2012 R2
  • 2012
  • 2008 R2 SP1 (management service)
  • 2008 R2 (host)
Cloud (for host and managed database instances)
  • Amazon Elastic Compute Cloud (EC2)
  • Microsoft Azure Virtual Machine (VM)

Development FrameworkMicrosoft .NET
  • 4.0+
Data Access ComponentsMicrosoft Data Access Components (MDAC)
  • 2.8+
RepositoryMicrosoft SQL Server (Standard, Enterprise)
  • 2022
  • 2019 (Windows, Linux)
  • 2017 (Windows, Linux)
  • 2016
  • 2014
  • 2012
  • 2008 R2
  • 2005
Managed Database InstancesMicrosoft SQL Server (Standard, Enterprise)
  • 2022
  • 2019 (Windows, Linux)
  • 2017 (Windows, Linux)
  • 2016
  • 2014
  • 2012
  • 2008 R2
  • 2005
  • 2000

Version History

Version 3.7

  • Adding a 'Frag %' column to the ToDo Table
  • Ability to Send Schedule Reports via Email
  • Upgrade SQL Defrag Manager .NET Dependency

Version 3.6

  • Recurring automated policies
  • Setting up automated policies with different analysis types
  • New "Instant Defrag" tab

Version 3.5.1

  • Supports SQL 2019
  • Cloud for Azure and Amazon EC2
  • Supports Windows 2019
  • Supports SQL Server 2019 Database
  • Supports databases in Azure

Version 3.5

  • Supports SQL Server 2017
  • Auto-discovery
  • Show schemas of table
  • Recent activity configuration

Version 3.4

There are no new features for this product version release.

Version 3.3

  • Import policies
  • Export policies
  • Navigation tree filtering option
  • Rediscover objects action for databases and tables

Version 3.2

  • Supports SQL Server 2014
  • Includes a new CLI option that initiates a defragmentation from the command line


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