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.
Typical environment
This configuration includes the following installations:
- SQL Diagnostic Manager Console on your workstation
- SQLdm Mobile Web site on a Web Server for smart phone 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.
This configuration deploys all SQL Diagnostic Manager services to your virtual instances. A service-only deployment to a virtual instance includes the following installations:
- SQL Diagnostic Manager Console on your workstation (not located in the cluster)
- SQLdm Mobile Web site on a non-clustered Web Server for smart phone access
- SQLdm Mobile Repository and SQL Diagnostic Manager Repository on the same SQL Server instance
- SQLdm Mobile and Newsfeed Service and the SQL Diagnostic Manager Services on each cluster node hosting the virtual SQL Server you want to monitor
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 work groups.
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 smart phone 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