Versions Compared

Old Version 54

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version 55

changes.mady.by.user Wara Hermosa

Saved on

Key

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

...

Tip

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

...

Type

Requirement

CPU

2.0 GHz or higher

Memory

1 GB

Operating System 64-bit

  • Windows Server 2008 SP2SP1+
  • Windows Server 2008 R2
  • Windows 7
  • Windows 8
  • Windows Server 2012
  • Windows 8Windows Server 2012 R2
  • Windows 10
  • Windows Server 2016
  • Windows 2019

Port Access

5166, 5167, 5169

Client Browser

Internet Explorer 7.0 or later

...

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

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.7.2+ (Required)
  • MDAC 2.8
Note

SQL Diagnostic Manager 1011.6 0 installer checks for your current .NET framework version and prompts the .NET 4.7.2 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.

Type

Requirement

Disk Space

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

SQL Server Express, Standard, or Enterprise/Datacenter Edition

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

Monitored SQL Server Instances

Type

Requirement

SQL Server Express, Standard, or Enterprise/Datacenter Edition

SQL Server 2000

  • SQL Server 2005
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • SQL Server 2017 (Windows & Linux)
  • SQL Server 2019 (Windows & Linux)
  • SQL Azure
  • Amazon RDS
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, SQL Server 2019
  • Azure IaaS VM Windows (All SQL Versions)
  • Azure IaaS VM Linux (SQL Server 2017, 2019)
  • Amazon AWS IaaS VM Windows (All SQL Versions)
  • Amazon AWS IaaS VM Linux (SQL Server 2017)
Info
titleAWSAzure SQL and Amazon RDS permissions

Review the Minimum permissions to monitor an Amazon RDS instance with SQL Diagnostic Manager and the Minimum and Recommended Permissions for Azure SQL to create a SQL Server user on the 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

...