There are three types of SQL Diagnostic Manager installation (Trial, General, and Production). Refer to the following list of requirements for each type of installation.

SQL Diagnostic Manager 10.0 requires Microsoft SQL Server 2005 or above running on the computer that hosts the SQL Diagnostic Manager Repository database for all installations.

Tempdb monitoring is supported on SQL Server 2005 and above servers only.

SQL DM supports monitoring of images hosted on virtualized or cloud IaaS environments such as Microsoft Azure and Amazon EC2.

This topic provides the minimum requirements for installing SQL Diagnostic Manager. For more information about installation requirements, view SQL Diagnostic Manager Hardware Sizing guidelines.

Trial requirements

Consider the following requirements when installing all SQL Diagnostic Manager components on one computer.

Type

Requirement

SQL Server Standard or Enterprise Edition

  • SQL Server 2005 SP1 or later
  • SQL Server 2008 or later
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016

Hard Disk Space

200 MB for all SQL Diagnostic Manager components

Windows Permissions

Your Windows Logon account includes local Administrator permissions

SQL Server Privileges

Either a Windows user account or SQL Server login that includes System Administrator privileges on the monitored SQL Server instances

General requirements

The following requirements apply for all SQL Diagnostic Manager components.

Type

Requirement

CPU

2.0 GHz or higher

Memory

1 GB

32-bit Operating System

  • Windows XP SP2 or later
  • Windows Server 2003 SP2 or later
  • Windows Vista SP2 or later
  • Windows Server 2008 SP2
  • Windows Server 2008 R2
  • Windows 7
  • Windows Server 2012
  • Windows 8
  • Windows Server 2012 R2
  • Windows 8.1
  • Windows 10

64-bit Operating System

  • Windows XP SP2 or later
  • Windows Server 2003 SP2 or later
  • Windows Vista SP2 or later
  • Windows Server 2008 SP2
  • Windows Server 2008 R2
  • Windows 7
  • Windows Server 2012
  • Windows 8
  • Windows Server 2012 R2
  • Windows 8.1
  • Windows 10

Port Access

5166, 5167, 5169

Client Browser

Internet Explorer 7.0 or later

Production requirements

Consider the following requirements when installing SQL Diagnostic Manager in an environment where the components are on separate computers.

SQL Diagnostic Manager Console

Type

Requirement

Disk Space

40 MB

SQL Server Permissions

Your Windows logon account includes Read Access to the SQL Diagnostic Manager Repository. You can specify a SQL Server login instead.

Software Framework

Microsoft .NET 4.0+ and MDAC 2.8

Monitor Resolution

1280 x 1024 with small text for the best viewing of the SQL Diagnostic Manager Dashboard

SQL Diagnostic Manager Services

Type

Requirement

Disk Space

50 MB

Collection Service Permissions

System Administrator privileges on the monitored SQL Server instances

Management Service Permissions

System Administration privileges on the SQL Diagnostic Manager Repository instance

Software FrameworkMicrosoft .NET 2.0 SP2+ and MDAC 2.8

SQL Diagnostic Manager Repository

SQL Diagnostic Manager 7.2 and later includes a repository autogrow setting at 32 MB, which is sufficient for trial and small environments in production. Environments with larger, multi-server installations should change the repository autogrow setting to 250 MB or higher to prevent frequent data file autogrow, which can cause performance problems. Using percentage-based autogrow is not recommended.

Type

Requirement

Disk Space

1GB to 3GB for one year of data per monitored SQL Server instance

SQL Server Standard or Enterprise Edition

  • SQL Server 2005 SP1 or later
  • SQL Server 2008 or later
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016

Monitored SQL Server Instances

Type

Requirement

SQL Server Express, Standard, or Enterprise Edition

  • SQL Server 2000 SP4 or later (Standard or Enterprise only)
  • SQL Server 2005 SP1 or later (Standard or Enterprise only)
  • SQL Server 2008 or later
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016

SQL Diagnostic Manager Management Pack and SCOM support requirements

The IDERA SQL Diagnostic Manager Management Pack for integration with SCOM is designed for System Center Operations Manager 2007 R2 and above. For more information about SQL Diagnostic Manager MP and SCOM installation, see Install and configure the SQL Diagnostic Manager Management Pack for SCOM.

 

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources Legal