Page History
...
Tip |
---|
SQL Diagnostic Manager 10.0 1 requires Microsoft SQL Server 2005 or above running on the computer that hosts the SQL Diagnostic Manager Repository database for all installations. |
Note |
---|
Tempdb monitoring is supported on SQL Server 2005 and above servers only. |
Note |
SQL DM supports monitoring of images hosted on virtualized or cloud IaaS environments such as Microsoft Azure and Amazon EC2. |
Info |
---|
This topic provides the minimum requirements for installing SQL Diagnostic Manager. For more information about installation requirements, view SQL Diagnostic Manager Hardware Sizing guidelines. |
...
Type | Requirement | ||
---|---|---|---|
CPU | 2.0 GHz or higher | ||
Memory | 1 GB | ||
Operating System (32-bit Operating System |
| and 64-bit Operating System) |
|
Port Access | 5166, 5167, 5169 | ||
Client Browser | Internet Explorer 7.0 or later |
...
Consider the following requirements when installing SQL Diagnostic Manager in an environment where the components are on separate computers.
SQL Diagnostic Manager Console
Type | Requirement |
---|---|
Disk Space | 40 MB |
SQL Server Permissions | Your Windows logon login account includes Read Access to the SQL Diagnostic Manager Repository. You can specify a SQL Server login instead. |
Software Framework | Microsoft .NET 4.0+ and MDAC 2.8 |
Monitor Resolution | 1280 x 1024 with small text for the best viewing of the SQL Diagnostic Manager Dashboard |
SQL Diagnostic Manager Services
Type | Requirement |
---|---|
Disk Space | 50 MB |
Collection Service Permissions | System Administrator privileges on the monitored SQL Server instances |
Management Service Permissions | System Administration privileges on the SQL Diagnostic Manager Repository instance |
Software Framework | Microsoft .NET 24.0 SP2+ and MDAC 2.8 |
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 instance |
SQL Server Standard or Enterprise Edition |
|
Monitored SQL Server Instances
Type | Requirement |
---|---|
SQL Server Express, Standard , or Enterprise Edition |
|
SQL Diagnostic Manager Management Pack and SCOM support requirements
The IDERA SQL Diagnostic Manager Management Pack for integration with SCOM is designed for System Center Operations Manager 2007 R2 and above. For more information about SQL Diagnostic Manager MP and SCOM installation, see Install and configure the SQL Diagnostic Manager Management Pack for SCOM.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >