Page History

Versions Compared

Key

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

...

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

...

Info
To run PowerShell scripts, upgrade to PowerShell 3.0 or higher. This upgrade is required to use the PowerShell snap-in.

...

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 2016

Only on Windows and Linux

SQL Server

2012

2017
SQL Server

2014

2019
SQL Server

2016

2022

Info
SQL

Server 2017

Diagnostic Manager monitors and supports older versions of SQL Server on a best-effort basis.

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 to all SQL Diagnostic Manager components.

Type	Requirement
CPU	2.0 GHz or higher
Memory	1 GB
Operating System

(32-bit and

64-bit

)

Windows

Vista SP2 or later

10
Windows

Server 2008 SP2

Windows Server 2008 R2

Windows 7

11
Windows Server 2012

Windows 8

Windows Server 2012 R2
Windows

8.1

Server 2016
Windows

Server 2019
Windows Server

2016

2022
Port Access	5166, 5167, 5169
Client Browser

Internet Explorer 7.0 or later

Microsoft Edge
Google Chrome
Mozilla Firefox
Safari 9+

Production requirements

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

...

title	Permissions and Privileges

...

SQL Diagnostic Manager Console

Type	Requirement
Disk Space	40 MB
SQL Server Permissions	Your Windows login account includes Read Access to the SQL Diagnostic Manager Repository. You can specify a 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

System Administrator privileges on the monitored SQL Server instances

For more information, review the User Creation Scripts.

Management Service Permissions

System Administration privileges on the

Sysadmin fixed server role on SQL Diagnostic Manager Repository instance

Software Framework

Windows Runtime Components

Microsoft .NET 4.

0 SP2

8+ (

Minimum)Microsoft .NET 4.6.2 (Recommended)

Required)
MDAC 2.8

Note
SQL Diagnostic Manager 11.0 installer checks for your current .NET framework version and prompts the required .NET update. After installing the latest version of .NET Framework you need to reboot your machine. Otherwise, SQLDM installation fails.

SQL Diagnostic Manager Repository

Tip
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.

Tip

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

SQL Server Standard or Enterprise/Datacenter Edition

SQL Server

2005 SP1 or later

SQL Server 2008 or later

SQL Server 2008 R2

2016

Only on Windows and Linux:

SQL Server

2012

2017
SQL Server

2014

2019
SQL Server

2016

2022

Info
SQL

Server 2017 (Windows & Linux)

Diagnostic Manager monitors and supports older versions of SQL Server on a best-effort basis.

Cloud Deployment

Azure IaaS VM Windows
Azure IaaS VM Linux
Amazon AWS IaaS VM Windows
Amazon AWS IaaS Linux

Note
SQL Diagnostic Manager supports any IaaS deployment if the version of SQL Server used is supported.
Info
Below, some additional information about SQL Diagnostic Manager Repository requirements: Database file size at creation time: 100 MB with and a filegrowth of 32 MB Log initial size: 5 MB and a filegrowth of 32 MB Default database collation: SQL_Latin1_General_CP1_CS_AS

Monitored SQL Server Instances

Type	Requirement

SQL Server

SQL Server 2005 SP1 or later

SQL Server 2008 or later

SQL Server 2008 R2

SQL Server 2012

SQL Server 2014

SQL Server Express, Standard, or Enterprise/Datacenter Edition

SQL Server

2000 SP4 or later

2014
SQL Server 2016
SQL Azure
Amazon RDS

Only on Windows and Linux

SQL Server 2017
SQL Server 2019
SQL Server 2022

Info
SQL Diagnostic Manager monitors and supports older versions of SQL Server on a best-effort basis.

Cloud Deployment

Azure DB
- Single
- Elastic Pool
- Managed Instance
Amazon RDS SQL

- SQL Server 2016
- SQL

Express 2008

- Server 2017
- SQL Server 2019
- SQL Server

Express 2008 R2

- 2022
Azure IaaS VM Windows (All SQL Versions)
Azure IaaS VM Linux
- SQL Server

Express 2012

- 2017
- SQL Server

Express 2014

- 2019
- SQL Server

Express 2016

Microsoft SQL Azure

Amazon RDS

SQL Server 2017 (Windows & Linux)

- 2022
Amazon AWS IaaS VM Windows (All SQL Versions)
Amazon AWS IaaS VM Linux
- SQL Server 2017
- SQL Server 2019
- SQL Server 2022

Note
SQL Diagnostic Manager supports any IaaS deployment if the version of SQL Server used is supported.

Info

title	AWS	Azure SQL and Amazon RDS permissions

Review the Minimum and Recommended Permissions for Amazon RDS and the Minimum and Recommended Permissions for Azure SQL To monitor an Amazon RDS instance using SQL Diagnostic Manager, you have to create a SQL Server user on the instance with the following permissions:

Roles: public

Other permissions (under the Securables tab in using SSMS): View server state, View any definition, View any database, and Connect SQL.

Note
No OS Collections supported on Linux under monitored versions.

server to monitor a cloud instance.

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

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.

Legal

Scroll pdf ignore

SQL