Applies to the following products and features: The SentryOne Monitor product and the on-premises SentryOne Portal feature for SQL Sentry.
SentryOne Monitor offers the ability to create custom dashboards. With custom dashboards, you can include the performance metric widgets that you want, and you can have performance charts for different targets on the same dashboard.
Create Custom Dashboard
1. To create a custom dashboard, select Add New from the bottom of the Dashboards drop-down menu:
2. After selecting Add New, the Create Dashboard dialog appears where you will enter the name of the custom dashboard. You have the option to start with a Blank Dashboard or Clone Existing. If you select Clone Existing, you must then select from an existing dashboard to clone. When you are done, select Create Dashboard.
3. Once the dashboard appears, use the edit button in the upper right to customize the dashboard:
4. Select the performance charts from the list of Available Widgets to add them to your custom dashboard:
5. Once you've added the desired widgets, select Save Dashboard:
Success: You've created your first custom dashboard!
Note: This custom dashboard is available across other targets. If you toggle the sidebar and select a different target, it'll display this custom dashboard with the CPU Usage and Disk I/O widgets for that target.
Widgets may be configured to have a Custom Date Range or a Custom Target (which allows for multiple targets per dashboard).
Custom Date Range
A Custom Date Range allows you to configure a widget to display a defined number of minutes, hours, or days.
To set a Custom Date Range:
- Select edit on a custom dashboard.
- Select configure on a specific widget.
- Toggle the Use Dashboard Time Range switch to false.
- Use the Enter Number textbox and Select Units drop-down to enter an amount of time.
- Select Save on the Configure Widget screen.
- Select Save Dashboard on the Edit Dashboard screen.
In this example, the top CPU Usage chart has the default Dashboard Time Range, and the bottom chart is displaying a Custom Time Range of 5 minutes.
Multiple Targets per Dashboard
1. If you would like to have different targets on the same dashboard, use the Configure option on a widget in the custom dashboard to open the Configure Widget options. Under Configure Widget options, toggle Use Dashboard Target to off, then click Select Target.
2. Use Select Target to open the target selection window and choose a target to associate with the performance chart widget. You can type into the filter area or use (chevron-down) to select a target from the list of devices.
3. Once you've selected a device, you'll see it populated under Custom Target. Select Save to set the chart widget to the Custom Target:
4. Configure the widgets until you have the performance chart and target combination desired for your custom dashboard and save your changes using Save Dashboard. The example below shows a custom dashboard with CPU Usage for a custom target and Disk I/O for the primary target of the dashboard:
The example below shows a custom dashboard with three SQL Server Activity chart widgets, all configured to display the values for a different target:
SQL Server vs. Azure SQL DB Widgets
When adding widgets, you'll see SQL Server and Azure SQL DB labels under the widget name. If you add an Azure SQL DB widget to a custom dashboard that has an Azure SQL Database as the default target, then the chart widget will use that target.
Add an Azure SQL DB widget to a dashboard that has an Azure SQL Database as the default target:
The widget loads for the default target without any additional configuration:
However, if you start from a different target type as the base (SQL Server in this case), you'll need to configure the target to an Azure SQL DB instance to populate the chart data.
Add an Azure SQL DB widget to a dashboard with a different target type from the default target:
The widget is added without data to display. The default target is a SQL Server which doesn't have Azure SQL DB data to match the widget:
Select edit on the widget to select a different target for the chart. Configure per the Custom Target instructions under Multiple Targets per Dashboard.
Note: The list of targets and instances provided in the Select Target list will be specific to targets of the same widget type.
Once you have a custom dashboard created, you may be able to save time by using it as a template for additional custom dashboards.
To clone a dashboard:
1. Select Add New from the Dashboards menu.
2. Enter a Dashboard Name.
3. Select Clone Existing from the radio button options.
4. Use the Select Existing drop-down to select the name of the dashboard you want to clone.
5. Select Create Dashboard.
6. The cloned dashboard appears and you can use the edit button in the upper right to configure the options for your cloned dashboard.
While viewing a custom dashboard, select the edit button from the upper right to open Edit Dashboard options and select Delete Dashboard at the bottom to delete the dashboard.