Page History
The following guidelines provide an estimation of estimate the hardware resources required to deploy SQL Diagnostic Manager depending on the number of servers you want to monitor with SQLDM.
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 |
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. |
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 |
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 30 instances could gather approximately 90 GB over the course of a year. |
Installs 51-200 servers
Dual-server deployment - First The first server hosts the SQL Diagnostic Manager Services and the second server hosts the SQL Server and the SQLdm Repository database.
- Machine 1 - Hosting the SQL Diagnostic Manager services (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 | 8-16 GB |
CPU |
6 Core |
- Machine 2 - Hosting the SQL Server and 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 | 16 GB |
CPU |
6 Core |
SQLdm Repository size | 200-600GB |
SQL Server version | SQL Server 2008R2 standard edition or higher |
Installs 201-300 servers
Dual-server deployment - First The first server hosts the SQL Diagnostic Manager Services and the second server hosts the SQL Server and the SQLdm Repository database.
- Machine 1 - Hosting the SQL Diagnostic Manager services (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 |
8 Core |
- Machine 2 - Hosting the SQL Server and 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 | 32 GB |
CPU |
8 Core |
SQLdm Repository size | 600 GB or more |
SQL Server version | SQL Server 2008R2 standard edition or higher |
Installs over 300 servers
Dual-server deployment - First The first server hosts the SQL Diagnostic Manager Services and the second server hosts the SQL Server and the SQLdm Repository database.
- Machine 1 - Hosting the SQL Diagnostic Manager services (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 | 32 GB |
CPU |
8 Core |
- Machine 2- Hosting the SQL Server and 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 | 32 GB |
CPU |
8 Core |
SQLdm Repository size | 900 GB or more |
SQL Server version | SQL Server 2008R2 standard/enterprise edition |
Sample installations in large environments
See the following sample customer installations for users with large environments:
Installs 51-100 servers
Type | In-House Use |
---|---|
Number of monitored servers | 52 |
Services and Repository installed on same machine | Hyper-V
|
Data storage and grooming options |
|
Monitoring features | Monitor Windows and SQL Server performance and error log monitoring |
Type | In-House Use |
---|---|
Number of monitored servers | 90 |
Services machine |
|
Services machine |
|
Data storage and grooming options |
|
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 |
|
Data storage and grooming options |
|
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 |
|
Data storage and grooming options |
|
Monitoring features | Monitor Windows and SQL Server performance |
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...
...