You can install and deploy SQL Diagnostic Manager, SQLDM Mobile, and the IDERA Newsfeed to meet your unique SQL Server environment needs. SQL Diagnostic Manager also offers a SQL Diagnostic Manager Console-only installation in environments that already have SQL Diagnostic Manager fully installed. For additional information about this type of installation, see deploy SQL Diagnostic Manager Console only.
The following installation scenario descriptions assume you are deploying SQL Diagnostic Manager, SQLDM Mobile, and IDERA Newsfeed in your environment.
In larger environments that contain more than one SQL Diagnostic Manager installation, consider dedicating a SQLDM Mobile deployment per each SQL Diagnostic Manager application.
SQL Diagnostic Manager supports monitoring virtual SQL Server instances, such as those using VMware or other virtualization software. For additional information about how SQL Diagnostic Manager works with virtualization, see How SQL Diagnostic Manager works with a virtual environment.
SQL Diagnostic Manager supports running from Amazon EC2 or Azure IaaS environments.
Typical environment
This configuration includes the following installations:
- SQL Diagnostic Manager Console on your workstation
- SQLDM Mobile Web site on a Web Server for smartphone access
- SQLDM Mobile and Newsfeed Service on the same computer that hosts the SQL Diagnostic Manager services
- SQLDM Mobile Repository and SQL Diagnostic Manager Repository on the same SQL Server instance
Clustered environment
You can install and configure SQL Diagnostic Manager to monitor virtual SQL Servers. A virtual SQL Server is a SQL Server running on a Microsoft failover cluster managed by Microsoft Cluster Services.
For SQL Diagnostic Manager to monitor virtual SQL Servers, you need to point SQLDM at the "Virtual" SQL Server rather than the individual members of the cluster.
You can install and configure SQL Diagnostic Manager with its core services and repository databases on a Microsoft failover cluster managed by Microsoft Cluster Services. For more information, review Deploy SQL Diagnostic Manager in a clustered environment.
Web farm environment
You can install SQLDM Mobile in a Web farm to make sure this site remains accessible during a failover situation. This configuration includes the following installations:
- SQLDM Mobile on a Web Server in the farm
- Typical SQL Diagnostic Manager installation
- SQLDM Mobile and Newsfeed Service on the same computer that hosts the SQL Diagnostic Manager services
- SQLDM Mobile Repository and SQL Diagnostic Manager Repository on the same SQL Server instance
Non-trusted environment
You can install and configure SQL Diagnostic Manager and SQLDM Mobile to monitor SQL Server instances running in non-trusted domains or workgroups.
This configuration includes the following installations:
- SQL Diagnostic Manager Console on your workstation in a trusted or non-trusted domain
- SQLDM Mobile Web site on a Web Server for smartphone access
- SQLDM Mobile & Newsfeed Service on the same computer that hosts the SQL Diagnostic Manager services, in a trusted or non-trusted domain
- SQLDM Mobile Repository and SQL Diagnostic Manager Repository on the same SQL Server instance, in a trusted or non-trusted domain