Versions Compared

Key

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

...

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

Type

Requirement

SQL Server Standard or Enterprise Edition

  • SQL Server 2008
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016

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.

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

Type

Requirement

CPU

2.0 GHz or higher

Memory

1 GB

Operating System 64-bit

  • Windows Server 2008 SP1+
  • Windows Server 2008 R2
  • Windows 8

    • Windows Server 2012
    • Windows Server 2012 R2
    • Windows Server 2016
    • Windows Server 2019
    • Windows
    10
    • Server 2022
    • Windows
    Server 2022
    • 10
    • Windows 11

    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.

    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.

    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

    Windows Runtime Components
    • Microsoft .NET 4.
    6
    • 8+ (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. Otherwise, SQLDM installation fails.

    ...

    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 Standard or Enterprise/Datacenter Edition

    SQL Server 2008 R2

    • SQL Server 2012
    • SQL Server 2014
    • SQL Server 2016

    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.

    • SQL Server 2022 (Experimental support)
    Cloud Deployment
    • Azure IaaS VM Linux (SQL Server 2019)
    • Amazon AWS IaaS VM Windows
    • Amazon AWS IaaS Linux (SQL Server 2019)

    Monitored SQL Server Instances

    Type

    Requirement

    SQL Server Express, Standard, or Enterprise/Datacenter Edition

    • SQL Server 2008
    • SQL Server 2008 R2
    • SQL Server 2012
    • SQL Server 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.

    • SQL Server 2022 (Experimental support)
    Cloud Deployment
    • Azure DB
    :
      • Single
      • Elastic Pool
      • Managed Instance
    • Amazon RDS
    SQL: 
    • 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
      • SQL Server 2019
    • Amazon AWS IaaS VM Windows (All SQL Versions)
    • Amazon AWS IaaS VM Linux
    :
      • SQL Server 2017
      • SQL Server 2019
    Info
    titleAzure SQL and Amazon RDS permissions

    Review the Minimum and Recommended Permissions for Amazon RDS and the Minimum and Recommended Permissions for Azure SQL to create a SQL Server user on the server to monitor a cloud instance.

    ...