Automatically find and fix
database index fragmentation

Automate the identification of index fragmentation hot spots
Defragment on-demand and via schedules
Receive email notifications for policy and resource check exceptions
Use a centralized dashboard and detailed reporting

 

Defragmentation Management

• Customize defragmentation

  Trigger defragmentation of database indexes by fragmentation percentage and scan density. Prioritize defragmentation by fragmentation level, scan density, and index size.

• Manage with policies

  Apply policies for defragmentation of database indexes at level of instances, database, and indexes. Apply the same policy to multiple objects at simultaneously.

• Manage indexes

  Specify how much free space SQL Server should leave on the index page via settings for fill factor to limit page splitting and shifting.

• Check system resources proactively

  Ascertain utilization of critical system resources before starting defragmentation to delay, prevent, or run as scheduled.

 

Reporting & Notification

• Notify via email

  When resource check detects that the metric exceeds user-defined threshold before executing the defragmentation of database indexes, it sends an email alert.

• View detailed metrics

  View detailed information such as fragmentation percentage, index and table size, free memory, page density, rate of increase of fragmentation, and more.

• Report comprehensively

  Access built-in reports that target technical and managerial audiences. Report on worst fragmented instances, databases, tables and indexes, and more.

• Track improvement savings

  Reclaim resources from defragmentation of database indexes and track total improvement on every object in SQL Server environment daily or over year.

 

Enterprise Management

• Centrally manage, report, and notify

  The central console enables rapid configuration as well as real-time monitoring of activity. It makes it easy to manage and track fragmentation over a large number of instances.

• Discover indexes dynamically

  As databases, tables, and indexes are created or deleted over time, automatically add new objects and drop deleted objects.

• Keep overhead low

  Collect fragmentation details intelligently based on customizable automation policies. Run agentless and quietly in the background as service.

• Install quickly and use easily

  Complete typical installation and configuration in minutes. Support mixed environment of Windows integrated security and SQL Server native security.

 

Cloud

• Install on cloud virtual machines

  Unify your control by running SQL Defrag Manager on cloud virtual machines—such as Azure Virtual Machine (VM) and Amazon Elastic Compute Cloud (EC2).

• Monitor SQL Server on cloud virtual machines

  Monitor your SQL Server instances running on cloud virtual machines—such as Azure VM and Amazon EC2.

• Monitor hybrid environments with single tool

  Save time by using the same monitoring tool for SQL Server databases on-premises (on your physical and virtual machines); and in private, public, and government cloud (on virtual machines).

• Access mapped cloud drives

  Get most out of cloud with cloud storage that is mapped as network drives or removable drives on Windows with SQL Defrag Manager. For example, map storage to Amazon Simple Storage Service (S3) and Azure Blob Storage.

IDERA Dashboard services requirements

You need to comply with the following requirements to install the IDERA Dashboard:

Type : Microsoft .NET Framework version
Requirement : 4.0 or later
Suggestions : Make sure to install this software prior to the installation of the IDERA Dashboard. For more information about the .NET Framework, see the MSDN article .NET Framework Versions and Dependencies.


Type : Microsoft Library
Requirement : msolap.dll
Suggestions : The msolap.dll file needs to be installed where the data collection service runs. The installation will search for the file and if it is not found, it will prompt the user to install the file. This file can be installed by downloading and installing from the latest version of the SQL Server Feature Pack from Microsoft SQL Server 2016 Feature Pack (choose the ENU\x64\SQL_AS_OLEDB.msi installer).

Type : Operating System
Requirement :

• Windows Server 2008 R2 (86-bit)
• Windows Server 2008 R2 (64-bit)
• Windows Server 2012 R2 (64-bit)
• Windows Server 2016 (64-bit)
• Windows 10 (64-bit)
• Windows 2019 (64-bit)

Suggestions : -

 

IDERA Dashboard repository requirements

The IDERA Dashboard supports any of the following versions for hosting its repositories:

• SQL Server 2008 R2 - All Editions
• SQL Server 2012 R2 - All Editions
• SQL Server 2014 - All Editions
• SQL Server 2016 - All Editions
• SQL Server 2017
• SQL Server 2019

Browser requirements

The IDERA Dashboard user interface can be accessed via web with the following browsers:

• Internet Explorer IE 10.x+
• Google Chrome
• Mozilla Firefox
• Microsoft Edge
• Safari

Port requirements

The IDERA Dashboard uses the following ports by default:

• Idera Dashboard Core Services port: 9292
• Idera Dashboard Web Application Service port: 9290
• Idera Dashboard Web Application Monitor port: 9094
• Idera Dashboard Web Application SSL port: 9291