Versions Compared

Key

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

...

Tip

SQL Diagnostic Manager 1012.5 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.

...

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.

    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

    ...

    Type

    Requirement

    CPU

    2.0 GHz or higher

    Memory

    1 GB

    Operating System 64-bit

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

    Port Access

    5166, 5167, 5169

    Client Browser

    • Microsoft Edge
    • Google Chrome
    • Mozilla Firefox
    • Safari 9+

    ...

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

    Cloud Deployment
    • Azure IaaS VM Windows
    • Azure IaaS VM Linux (SQL Server 2019)Linux 
    • Amazon AWS IaaS VM Windows
    • Amazon AWS IaaS Linux (SQL Server 2019)IaaS Linux 
    Note

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

    Monitored SQL Server Instances

    Type

    Requirement

    SQL Server Express, Standard, or Enterprise/Datacenter Edition

  • SQL Server 2008
  • SQL Server 2008 R2

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

    Cloud Deployment
    • Azure DB
      • Single
      • Elastic Pool
      • Managed Instance
    • Amazon RDS SQL 
      • SQL Server 20082016
      • SQL Server2008 R2SQL Server 20122017
      • SQL Server 20162019
      • SQL Server 20172022
      • SQL Server 2019
    • Azure IaaS VM Windows (All SQL Versions)
    • Azure IaaS VM Linux
      • SQL Server 2017
      • SQL Server 2019
      • SQL Server 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
    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.

    ...