There are three types of SQLdm installation (Trial, General, and Production). Refer to the following list of requirements for each type of installation.
SQLdm 9.0 requires Microsoft SQL Server 2005 or above running on the computer that hosts the SQLdm Repository database for all installations.
Tempdb monitoring is supported on SQL Server 2005 and above servers only.
Sample installations in large environments
While this topic provides the minimum requirements for installing SQLdm, users with large environments can benefit from the sample customer installations listed below.
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 |
Trial requirements
Consider the following requirements when installing all SQLdm components on one computer.
Type | Requirement |
|---|---|
SQL Server Standard or Enterprise Edition |
|
Hard Disk Space | 200 MB for all SQLdm components |
Windows Permissions | Your Windows Logon account includes local Administrator permissions |
SQL Server Privileges | Either a Windows user account or SQL Server login that includes System Administrator privileges on the monitored SQL Server instances |
General requirements
The following requirements apply for all SQLdm components.
Type | Requirement |
|---|---|
CPU | 2.0 GHz or higher |
Memory | 1 GB |
32-bit Operating System |
|
64-bit Operating System |
|
Port Access | 5166, 5167 |
Client Browser | Internet Explorer 7.0 or later |
Production requirements
Consider the following requirements when installing SQLdm in an environment where the components are on separate computers.
SQLdm Console
Type | Requirement |
|---|---|
Disk Space | 40 MB |
SQL Server Permissions | Your Windows logon account includes Read Access to the SQLdm Repository. You can specify a SQL Server login instead. |
Software Framework | Microsoft .NET 4.0 Full |
Monitor Resolution | 1280 x 1024 with small text for the best viewing of the SQLdm Dashboard |
SQLdm Services
Type | Requirement |
|---|---|
Disk Space | 50 MB |
Collection Service Permissions | System Administrator privileges on the monitored SQL Server instances |
Management Service Permissions | Read and Write privileges on the SQLdm Repository database |
SQLdm Repository
SQLdm 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 instance |
SQL Server Standard or Enterprise Edition |
|
Monitored SQL Server Instances
Type | Requirement |
|---|---|
SQL Server Standard or Enterprise Edition |
|
SQLdm Management Pack and SCOM support requirements
The Idera SQLdm Management Pack for integration with SCOM is designed for System Center Operations Manager 2007 R2 and above. For more information about SQLdm MP and SCOM installation, see Install and configure the SQLdm Management Pack for SCOM.