Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip

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

Note

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

...

Type

Requirement

SQL Server Standard or Enterprise Edition

  • SQL Server SQL Server 2005 SP1 or later
  • SQL Server SQL Server 2008 or later
  • SQL Server SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • SQL Server 2017
  • SQL Server 2019 (Experimental support)

Hard Disk Space

200 MB for all SQL Diagnostic Manager components

Windows Permissions

Your Windows Logon account includes local Administrator permissions

SQL Server SQL Server Privileges

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

General requirements

...

Type

Requirement

CPU

2.0 GHz or higher

Memory

1 GB

Operating System (32-bit and 64-bit)

  • Windows Server 2008 SP1+
  • Windows Server 2008 R2
  • Windows 7
  • Windows Server 2012
  • Windows 8
  • Windows Server 2012 R2
  • Windows 8.1Windows 10
  • Windows Server 2016
  • Windows 2019 (Experimental support)

Port Access

5166, 5167, 5169

Client Browser

Internet Explorer 7.0 or later

...

SQL Diagnostic Manager Console

Type

Requirement

Disk Space

40 MB

SQL Server

SQL Server Permissions

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

SQL Server

SQL Server login instead

.

Software Framework

Microsoft

.

NET 4.0  (Minimum)

Microsoft .NET 4.6.2+ (Recommended)

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

For more information, review the User Creation Scripts.

Management Service Permissions

Sysadmin fixed server role on SQL Diagnostic Manager Repository instance

Software Framework

Linux - SQL Server Server 2017 (Monitored SQL Instances only)
  • Red hat Enterprise 7.3 or Higher
  • SUSE Enterprise v12 SP2 or Higher
  • Ubuntu 16.04LTS and 16.10 or Higher
Windows Runtime Components
  • Microsoft .NET 4.0 SP2 (Minimum)
  • Microsoft .NET 4.6.2+ (Recommended)
  • MDAC 2.8

SQL Diagnostic Manager Repository

...

Type

Requirement

Disk Space

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

SQL Server SQL Server Express, Standard, or Enterprise Edition

  • SQL Server 2005 SP1 or later
  • SQL Server SQL Server 2008 or later
  • SQL Server SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • SQL Server 2017 (Windows & Linux)
  • SQL Server 2019 (Experimental support
Cloud Deployment
  • Azure IaaS VM Linux (SQL Server 2017)
  • Amazon AWS IaaS VM Windows
  • Amazon AWS IaaS Linux (SQL Server 2017)

Monitored SQL Server SQL Server Instances

Type

Requirement

SQL Server SQL Server Express, Standard, or Enterprise Edition

  • SQL Server 2000 SP4 or later
  • SQL Server SQL Server 2005 SP1 or later
  • SQL Server SQL Server 2008 SP1
  • SQL Server SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • SQL Server 2019
  • SQL Server 2017 (Windows & Linux)
  • SQL Server Express 2008
  • SQL Server Express 2008 R2
  • SQL Server Express 2012
  • SQL Server Express 2014
  • SQL Server Express 2016
  • SQL Server Express 2017
  • SQL Azure
  • Amazon RDSSQL Server 2019 (Experimental support
Cloud Deployment

Azure DB: Single, Elastic Pool, Managed Instance.

Amazon RDS SQL: SQL Server 2008, SQL Server2008 R2, SQL Server 2012, SQL Server 2016, SQL Server 2017

Azure IaaS VM Windows (All SQL Versions)

Azure IaaS VM Linux (All SQL Versions)

Amazon AWS IaaS VM Linux (SQL Server 2017)

Info
titleAWS

Review the Minimum permissions to monitor an Amazon RDS instance with SQL Diagnostic Manager.

...

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.



Scroll pdf ignore
SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|  
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|  
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse