Page History
The following guidelines provide an estimation of 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 2008R2 Windows Server 2012 |
| Memory | 8 GB |
| CPU | Intel® Xeon® E5-2430 2.20GHz (6 Core) |
| SQLdm Repository size | Approximately 50GB |
| SQL Server version | SQL Server 2008R2 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 2008R2 Windows Server 2012 |
| Memory | 16 GB |
| CPU | Intel® Xeon® E5-2430 2.20GHz (6 Core) |
| SQLdm Repository size | Approximately 150GB |
| SQL Server version | SQL Server 2008R2 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 server hosts the SQL Diagnostic Manager Services and 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 2008R2 Windows Server 2012 |
| Memory | 8-16 GB |
| CPU | Intel® Xeon® E5-2430 2.20GHz (6 Core) |
- Machine 2 - Hosting the SQL Server and the SQLdm Repository (clustered for redundancy)
| Type | Requirement |
|---|---|
| Operating System | Microsoft Windows Server 2008R2 Windows Server 2012 |
| Memory | 16 GB |
| CPU | Intel® Xeon® E5-2430 2.20GHz (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 server hosts the SQL Diagnostic Manager Services and 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 2008R2 Windows Server 2012 |
| Memory | 16 GB |
| CPU | Intel® Xeon® E5-2450 2.10GHz (8 Core) |
- Machine 2 - Hosting the SQL Server and the SQLdm Repository (clustered for redundancy)
...