The Dashboard view is customizable per monitored SQL Server instance by selecting the panels that are important to view for that instance. You can customize your Dashboard view for the selected SQL Server instance or as the default for all SQL Server instances added to SQL Diagnostic Manager.
Using the Panel Gallery
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 most important metrics. To access the Panel Gallery, select your preferred SQL server instance from the Servers pane and then 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.
Designing a Dashboard view
When you design a Dashboard view, select the metric panels that display the current status and the best information for your selected SQL Server instance. 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.
SQL Diagnostic Manager allows you to choose from several different layouts of columns and rows for your dashboard design. You can then drag and drop panels from the Panel Gallery to the actual location in the layout where you want that panel to reside. You can also click, hold, and drag panels to re-arrange their location. When you drag a panel to another position and release the mouse button, the panel you moved switches locations with the existing panel. For example, your design includes the CPU panel in the upper left corner and the Sessions panel in the lower right corner. Click, hold, and drag the Sessions panel to the upper left corner, and then release. Note that the Sessions panel is in the upper left corner and the CPU panel is now in the lower right corner. For more information on available designs, see Design a dashboard view.
SQL Diagnostic Manager includes several options for you to use as your Dashboard view. You can also create a design using the available panels, and save the design for other people in your environment to use as their Dashboard view. For more information on available designs, see Select a dashboard design.
Saving a design
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.
Understanding how you can apply 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.
SQL Diagnostic Manager keeps that panel in the position of your Dashboard view until you close the SQL Diagnostic Manager Management Console session. Even after accessing other areas within SQL Diagnostic Manager, when you return to your Dashboard view, the same panel appears in the same location.
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, select the name of the instance, and then 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 to open the Dashboard Designer, and click Select a Dashboard. Scroll through the available designs and select the one you want to use for the monitored 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
- Cache panel
- CPU panel
- Custom Counters Panel
- Databases panel
- Disk panel
- File Activity panel
- Lock Waits panel
- Memory panel
- Network panel
- Server Waits panel
- Sessions panel
- Tempdb panel
- Virtualization panel