...
Tip |
---|
SQL Diagnostic Manager 1012.5 3 requires Microsoft SQL Server 2005 2016 or above running on the computer that hosts the SQL Diagnostic Manager Repository database for all installations. |
Note |
---|
Tempdb monitoring Tempdb monitoring is supported on SQL Server SQL Server 2005 and above servers only. |
...
Consider the following requirements when installing all SQL Diagnostic Manager components on one computer.
Type | Requirement |
---|
SQL Server Standard or Enterprise Edition | |
2005 SP1 or laterOnly on Windows and Linux |
SQL Server 2008 or later 2008 R2 2012 2014SQL Server 2016SQL Server 2017SQL Server 2019 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 SQL Server Privileges | Either a Windows user account or |
SQL Server SQL Server login that includes System Administrator privileges on the monitored |
SQL Server General requirements
The following requirements apply for to all SQL Diagnostic Manager components.
Type | Requirement |
---|
CPU | 2.0 GHz or higher |
Memory | 1 GB |
Operating System |
(32-bit and ) Server 2008 SP1+ Server 2008 R2 7Windows Windows 8- Windows Server 2012 R2
- Windows
|
10- Server 2016
- Windows Server
|
2016 2019 |
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 SQL Server Permissions | Your Windows login account includes Read Access to the SQL Diagnostic Manager Repository. You can specify a |
SQL Server 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 |
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 | |
0 SP2 Minimum)Microsoft .NET 4.6.2+ (Recommended)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, 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 SQL Server instance |
SQL Server |
Express, , or Enterprise/Datacenter Edition | |
2005SQL Server 2008 or laterOnly on Windows and Linux: |
2008 R2 2012 2014SQL Server 2016SQL Server 2017 (Windows & Linux)SQL Server 2019 Info |
---|
SQL Diagnostic Manager monitors and supports older versions of SQL Server on a best-effort basis. |
|
Cloud Deployment | |
Cloud Deployment Linux (SQL Server 2017)- Linux
- Amazon AWS IaaS VM Windows
- Amazon AWS
|
IaaS Linux (SQL Server 2017) Note |
---|
SQL Diagnostic Manager supports any IaaS deployment if the version of SQL Server used is supported. |
Monitored SQL Server Monitored SQL Server Instances
Type | Requirement |
---|
SQL Server Express, Standard, or Enterprise |
EditionSQL Server 2000 SP4 or laterSQL Server 2005 SP1 or later 2008 SP1SQL Server 2008 R2SQL Server 2012SQL Server Server 2019SQL Server 2017 (Windows & Linux)Only on Windows and Linux |
Express 2008 Express 2008 R2SQL Server Express 2014SQL Server Express 2016SQL Server Express 2017SQL AzureAmazon RDS Express 2012 Info |
---|
SQL Diagnostic Manager monitors and supports older versions of SQL Server on a best-effort basis. |
|
: , , . SQL: 2008, SQL Server2008 R2, 2012, 2016, 2017- 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 2019
- SQL Server 2022
|
Note |
---|
SQL Diagnostic Manager supports any IaaS deployment if the version of SQL Server used is supported. |
Info |
---|
title | AWSAzure SQL and Amazon RDS permissions |
---|
|
Review the Minimum permissions to monitor an Amazon RDS instance with SQL Diagnostic Managerthe 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. |
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
...