Versions Compared

Key

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

...

Type

Requirement

SQL Server Standard or Enterprise Edition

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

Only on Windows and Linux

  • SQL Server 2017
  • SQL Server 2019
Info

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

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

...

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.

Type

Requirement

Disk Space

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

SQL Server Express, SQL Server Standard , or Enterprise/Datacenter Edition

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

Only on Windows and Linux

  • SQL Server 2017 
  • SQL Server 2019
Info

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

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

  • 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
(Windows & Linux)SQL Server 2019 (
  • SQL Server 2019 
Info

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

Windows & Linux)

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
    ,
    • 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 permissions to monitor an Amazon RDS instance and the Minimum and Recommended Permissions for Azure SQL to create a SQL Server user on the server to monitor a cloud instance.

...