Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

When you install SQL Diagnostic Manager, a default Dashboard view is applied to all your SQL Server instances. The Panel Gallery allows you to alter your view so that you can monitor the metrics that are most important metrics. You can To access the Panel Gallery by selecting the appropriate SQL Server , select your preferred SQL server instance from the Servers pane , and then clicking click Customize. Once in the Dashboard Designer, click a panel in the Panel Gallery for SQL Diagnostic Manager to display additional information about that panel.

...

When you design a Dashboard view, it is important that you select the metric panels that give you display the current status and the best information for your selected SQL Server instance and the current status of that instance. Because SQL Diagnostic Manager allows you to create multiple designs, you can create one design with panels specifically for SQL Server 2000 instances and another design for SQL Server 2005 instances. It allows you to create designs that show the most important panels to monitor when certain events trigger alerts.

...

Once you are pleased with the selection and positioning of your panels, you can save your design. In the Dashboard Designer, click Save. SQL Diagnostic Manager allows you to name this design, which is then displayed in the Dashboard Gallery. For additional information about saving a dashboard design, see Save a dashboard design. 

...

SQL Diagnostic Manager allows you to use a design for a single session of the SQL Diagnostic Manager Management Console, apply a design to a specific monitored SQL Server instance, or apply the layout to any other SQL Server instance including those you add later. You can use a custom Dashboard view in the following situations:

One-time use

SQL Diagnostic Manager allows you to view a custom layout of your Dashboard view for a single session of the SQL Diagnostic Manager Management Console. For example, an event in one of your instances triggered an alert. You want to watch the metric that includes statistics relating to this alert, so you access the Panel Gallery in the Dashboard Designer. Drag the panel displaying the alert-related statistics to the top-left corner of your layout, and then close the Dashboard Designer. SQL Diagnostic Manager displays a message that you made changes to the current design. Click No to use this design only until you close this session of the SQL Diagnostic Manager Management Console.

...

When you no longer want that panel foremost in your Dashboard view, simply close the SQL Diagnostic Manager Management Console knowing that the default Dashboard view for that instance appears the next time you access SQL Diagnostic Manager.

Set as the default design for one or more instances

While the default Dashboard view includes panels that are important to your monitored SQL Server instances, the panels may not be in the order in which you want or this design does not include all of the panels you want to view. If there are no existing designs you want to use, access the Panel Gallery to select and move the panels you want to the positions that most suit your needs.

When you are done with your design, click Save to make sure you can use this design again. Type a unique name for this design, verify that this SQL Server instance appears in the Selected Servers area. You can add any other SQL Server instances by selecting , select the name of that the instance, and then clicking click Add > to move the instance to the Selected Servers area. Once your list of selected instances is complete, click OK.

Each time you access the Dashboard view for this instance, SQL Diagnostic Manager displays the information using this design.

You can also select an existing dashboard design as the default for one or more monitored SQL Server instances. On the Server Overview tab, click Customize, and then in to open the Dashboard Designer, and click Select a Dashboard. Scroll through the available designs until you find and select the one you want to use for this the monitored SQL Server instance. Click Select and each time you access the Dashboard view for this instance, SQL Diagnostic Manager displays the information in this design.

Set as the default design for all new or unassigned instances

SQL Diagnostic Manager allows you to select a design to use as the default for all new or unassigned monitored SQL Server instances so that you have a consistent format across all of your monitored SQL Server instances. When saving a dashboard design, check the Use this dashboard as my default for new or unassigned servers check box.

Available panels

...