Page History
...
Tip |
---|
SQL Diagnostic Manager 10.5 and above requires Microsoft SQL Server SQL Server 2005 or above to run 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. |
...
Type | Requirement |
---|---|
SQL Server Standard or Enterprise Edition |
Only on Windows and Linux
|
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 SQL Server instances |
General requirements
The following requirements apply to for all SQL Diagnostic Manager components.
Type | Requirement |
---|---|
CPU | 2.0 GHz or higher |
Memory | 1 GB |
Operating System 64-bit |
|
Port Access | 5166 - SQLDM Management Service, 5167, 5169 |
Client Browser | Internet Explorer 7.0 or later |
...
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 |
...
Type | Requirement |
---|---|
Disk Space | 50 MB |
Collection Service Permissions | Sysadmin rights and local admin rights on the monitored servers. |
Management Service Permissions | Local admin rights and sysadmin Sysadmin fixed server role on SQL Diagnostic Manager Repository instance |
Linux - SQL Server Server 2017 (Monitored SQL Instances only) |
|
Windows Runtime Components |
|
Note |
---|
SQL Diagnostic Manager 11.1 0 installer checks for your current .NET framework version and prompts the required .NET 4.7.2 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 SQL Server Express, Standard, or Enterprise/Datacenter Edition |
Only on Windows and Linux
|
Cloud Deployment |
|
Monitored SQL Server SQL Server Instances
Type | Requirement |
---|---|
SQL Server SQL Server Express, Standard, or Enterprise/Datacenter Edition |
Only on Windows and Linux
|
Cloud Deployment |
|
Info | ||
---|---|---|
| ||
Review the Minimum and Recommended Permissions for 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. |
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
...