Idera SQL Defrag Manager

Idera SQL Defrag Manager

หมายเหตุ
  • สินค้าจะได้รับภายใน 7-15 วันทำการ
  • บริษัทขอสงวนสิทธ์ในการเปลี่ยนแปลงเงื่อนไขการสั่งซื้อสินค้า โดยไม่ต้องแจ้งให้ทราบล่วงหน้า
 
Total 82,700.00 บาท

Automatically find and fix
database index fragmentation

Database administrators for SQL Server need to maintain the high availability and performance of their databases. Key areas that dramatically affect the performance of SQL Server are indexes that are fragmented and out of cluster. SQL Defrag Manager is a unique solution for defragmenting indexes for SQL Server. It automates the time-consuming process of finding fragmented indexes based on policies for the targeted databases.

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