Versions Compared

Key

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

...

Type

Requirement

Disk Space

50 MB

Collection Service Permissions

Sysadmin rights and local admin rights on the monitored servers.
For more information regarding lowered permissions requirements, review the User Creation Scripts.

Management Service Permissions

Sysadmin fixed server role on SQL Diagnostic Manager Repository instance

Linux - SQL Server (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

...

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 2008 or later
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • SQL Server 2017 (Windows & Linux)
  • SQL Server 2019 (Windows & Linux)
Cloud Deployment
  • Azure IaaS VM Linux (SQL Server 2019)
  • Amazon AWS IaaS VM Windows
  • Amazon AWS IaaS Linux (SQL Server 2019)

...

Type

Requirement

SQL Server Express, Standard, or Enterprise/Datacenter Edition

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

...