Page History
The following guidelines estimate the hardware resources required to deploy for SQL Diagnostic Manager Secure depending on the number of servers you want to monitor with SQLDMSQL Server instances that are registered and the repository grooming schedule applied.
Installs under 20 servers
Single-server deployment - Includes the SQL Diagnostic Manager Services and the SQL Server hosting the SQLdm Repository (clustered for redundancy).
| Type | Requirement |
|---|---|
| Operating System | Windows Server 2012 Windows Server 2012 R2 Windows Server 2016 Windows Server 2019 Windows Server 2022 Windows 10 Windows 11 |
| Memory | 8 GB |
| CPU | 6 Core |
| SQLdm Repository size | Approximately 50GB |
| Recommended SQL Server version | SQL Server 2008 R2 standard edition or higher |
| Info |
|---|
| The expected repository growth is approximately 1.5-3 GB per monitored instance for a year worth of collected data. Monitoring 15 instances could gather approximately 45 GB over the course of a year. |
| 2017 or newer |
Installs 20-50 servers
Single-server deployment - Includes the SQL Diagnostic Manager Services and the SQL Server hosting the SQLdm Repository (virtualized/clustered for redundancy).
| Type | Requirement |
|---|---|
| Operating System | Windows Server 2012 Windows Server 2012 R2 Windows Server 2016 Windows Server 2019 Windows Server 2022 Windows 10 Windows 11 |
| Memory | 16 GB |
| CPU | 6 Core |
| SQLdm Repository size | Approximately 150GB |
| Recommended SQL Server version | SQL Server 2008 R2 standard edition or higher |
...
| 2017 or newer |
Installs 51-200 servers
Dual-server deployment - The first server hosts the SQL Diagnostic Manager Services and the second server hosts the SQL Server and the SQLdm Repository database.
...
Windows Server 2012
Windows Server 2012 R2
Windows Server 2016
Windows Server 2019
Windows Server 2022
Windows 10
Windows 11
...
- Machine 2 - Hosting the SQL Server and the SQLdm Repository (clustered for redundancy)
...
Type
...
In-House Use
...
Number of monitored servers
...
90
...
Services machine
...
- 2 vCPU
- 8 GB of memory
- Windows Server 2008 R2 Enterprise
...
Services machine
...
- 2 vCPU
- 8 GB of memory
- Windows 2008 R2 Enterprise
- Repository: SQL Server 2008 R2
...
Data storage and grooming options
...
- Repository size: 100 GB
- Retain 60 days of history
...
Monitoring features
...
Monitor Windows and SQL Server performance
Installs 201- 300 servers
Type
In-House Use
Number of monitored servers
234
Services and Repository installed on same machine
- Dell 2950
- 2 quad core processors
- 16 GB of memory
- Windows Server 2003
Data storage and grooming options
- Repository size: 140 GB
- Retain 30 days of history
Monitoring features
Monitor Windows and SQL Server performance and use Query Waits for specific periods of diagnostics
Integrations
Send alerts to HP Open View via a command line program (opcmsg)
Type
In-House Use
Number of monitored servers
274
Services and Repository installed on same machine
- 4 quad core processors
- 128 GB of memory
- Windows Server 2008 R2
Data storage and grooming options
- Repository size: 1.5 TB
- Retain 365 days of history
Monitoring features
| Type | Requirement |
|---|---|
| Operating System | Windows Server 2012 Windows Server 2012 R2 Windows Server 2016 Windows Server 2019 Windows Server 2022 Windows 10 Windows 11 |
| Memory | 16 GB |
| CPU | 6 Core |
| SQLdm Repository size | 200-600GB |
| Recommended SQL Server version | SQL Server 2008R2 standard edition or higher |
Installs 201-300 servers
Dual-server deployment - The first server hosts the SQL Diagnostic Manager Services and the second server hosts the SQL Server and the SQLdm Repository database.
...
Windows Server 2012
Windows Server 2012 R2
Windows Server 2016
Windows Server 2019
Windows Server 2022
Windows 10
Windows 11
...
- Machine 2 - Hosting the SQL Server and the SQLdm Repository (clustered for redundancy)
...
Windows Server 2012
Windows Server 2012 R2
Windows Server 2016
Windows Server 2019
Windows Server 2022
Windows 10
Windows 11
...
8 Core
...
Installs over 300 servers
Dual-server deployment - The first server hosts the SQL Diagnostic Manager Services and the second server hosts the SQL Server and the SQLdm Repository database.
...
Windows Server 2012
Windows Server 2012 R2
Windows Server 2016
Windows Server 2019
Windows Server 2022
Windows 10
Windows 11
...
8 Core
- Machine 2- Hosting the SQL Server and the SQLdm Repository (virtualized/clustered for redundancy)
...
Windows Server 2012
Windows Server 2012 R2
Windows Server 2016
Windows Server 2019
Windows Server 2022
Windows 10
Windows 11
...
8 Core
...
Sample installations in large environments
See the following sample customer installations for users with large environments:
...
Number of monitored servers
...
Services and Repository installed on same machine
...
- 4 quad core processors
- 14 GB of memory
- Windows Server 2008 R2 Enterprise
...
Data storage and grooming options
...
- Repository size: 120 GB
- Retain 60 days of history
...
Monitor Windows and SQL Server performance and error log monitoring
| 2017 or newer |