SQL Sentry Portal Custom Charts
Applies to the following products and features: The on-premises SQL Sentry Portal feature for SQL Sentry. See the Getting Started with SQL Sentry Portal article for more details.
Introduction
Custom charts in SQL Sentry Portal allow you to create personalized dashboards with the performance counters, labels, colors, and chart types you select.
Viewing Dashboards
Select Dashboards from the sidebar. If dashboards with custom charts already exist, they will be listed here under the Dashboard Digest. Select a Dashboard to view its contents.
Filter Dashboards
If you have a large number of dashboards, you may want to filter what is displayed in the Dashboard Digest. Start typing in the Filter Dashboards box to filter the dashboard options displayed.
Creating Dashboards with Custom Charts
To create a Custom Dashboard in SQL Sentry Portal, complete the following steps:
- Select Dashboards from the sidebar to open the Dashboard Digest.
- Select the Create Dashboard button.
- Enter a Dashboard Name on the Create a New Dashboard screen. This is how the dashboard will appear on the Dashboard Digest.
- Select a Dashboard Template from the drop-down menu. Use Blank Dashboard to start fresh or choose an existing dashboard name as a starting point for this dashboard.
- Select the Add widgets button to launch the Add Charts options bar.
- Click the + button next to a chart type to add that chart. Use the Customize Chart screen to make changes with the custom chart options (described below) to create a chart.
- Select Save to save your chart and return to the edit dashboard screen.
- Add additional charts or select Save & Exit to complete your dashboard.
Custom Chart Options
Option | Description | ||
---|---|---|---|
Chart preview | The chart preview area displays your chart with the selected options. | ||
Chart Name | A descriptive name for the chart. This is how it will be identified on the Dashboards view and used for filtering. | ||
Target | The name of the monitored target to select metrics from for the custom chart. When building your dashboard, you can include charts for different targets and target types on the same dashboard. Starting with Version 2023.2.9, you can add metrics from multiple targets onto the same custom chart. For example, you could create a custom chart displaying CPU metrics from up to 10 targets in your environment in one custom chart. In the example below, we have added a custom chart with two separate targets displaying the sqlserver.topsql.database.waits metric. Note: Targets types are identified with icons in the Target drop-down list. When you select the Target from the list you will only have access to applicable metrics in the Performance Metrics section below. For example, a Windows target has access the applicable Windows or host metrics and SQL Server or Azure SQL Database targets have access to the applicable SQL Server or Azure metrics. You must be collecting tempdb metrics to have tempdb metrics listed. |
||
Sample Period | Option to include historical metrics for 1 hour, 1 day, or 1 week. | ||
Add Metric | Select the Add Metric button to add another metric to the custom chart. You may add up to 10 metrics per chart. Note: With Versions 2023.2 and later, you can add the same metric for multiple targets in your custom chart. When creating a new custom chart with your desired metric, selecting Add Metric will add a new instance of that metric. You can then change the target for the newly added metric to further customize your chart. If a metric is not available for your selected target type, the metric field will be highlighted with a red (!) icon, notifying you that the metric is invalid for the selected target. |
||
Metric | A drop-down menu of performance counter metrics (host.disk.reads, host.network.in.total, sqlserver.batches, etc.) applicable to the selected Target type. Note: Start typing to filter the available metrics. For example, type cpu to see all CPU-related metrics or tempdb for tempdb-related metrics. |
||
Instance | The instance of the metric (if applicable) such as Average or a specific Node / Core for host.cpu.cores or a specific disk for host.wmi.disk.size. | ||
Legend Label |
The text that appears on the chart legend to associate the metric and color.
|
||
Color |
The color that the metric will use on the chart. Select the dot to open the color palette window. To choose a color, use the color slider and select a shade from the rectangle, enter a HEX value, or enter RGB values for your custom color. |
||
Chart Type | The following chart type options are available:
Note: There's much to debate when it comes to choosing the right type of chart to visualize your data. Keep in mind that:
|
||
Line |
Check the Line box to display the metric as a line on the chart.
|
||
X | Use the X button to remove the metric from the chart. | ||
Custom Time Range | A Custom Time Range allows you to configure a chart to display metrics a defined number of minutes, hours, or days. Note: You can mix charts with custom time ranges and default time ranges on the same dashboard. Charts that use a custom time range will not be affected when a new time period is selected from the date selector in the top navigation bar. |
||
Amount | The numerical value associated with the Units. For example, if you want the past 12 hours displayed, enter 12 in Amount and select Hours from Units. | ||
Units | The following units of time are available:
|
||
Save | Select Save to save the changes to your custom chart, and add it to your Dashboard. | ||
Cancel | Select Cancel to dismiss your custom chart and not save any changes. |
Editing Dashboards
- Select Dashboards from the sidebar.
- On the Dashboard Digest screen you can either:
- Select the options button on the dashboard you want to edit.
- Select the dashboard you want to edit, then select the edit button from the Dashboards screen.
Edit mode allows you to do any of the following:
- Delete the dashboard.
- Rename the dashboard.
- Add additional charts to the dashboard.
- Configure, delete, or copy existing charts on the dashboard.
Remember to select Save & Exit after making your changes, or Cancel to dismiss them.
Organizing Charts
When you are in Edit mode, you can drag and drop the charts to change the order or position on the dashboard. If you want more than one chart per row, drag it into a row that contains another chart to create another chart column.
Editing Custom Charts
Adding charts
Selecting edit on the dashboard allows you to add new charts using the Add Charts option bar. See the Custom Chart Options above to complete adding a chart.
Editing charts
- Select the configure button on the chart you want to edit.
- Edit the options as needed. See the Custom Chart Options above.
- Select Save.
Removing charts
- Select the edit button on the dashboard that contains the chart you want to remove.
- Select the delete button on the chart you want to remove.
- Select Save & Exit to complete the chart deletion.
- Note: Select Cancel if you do not want to delete the chart.
Copying charts
- Select the edit button on the dashboard that contains the chart you want to copy.
- Select the copy button on the chart you want to copy.
- Edit the options as needed. See the Custom Chart Options above.
- Select Save to save your changes.
- Note: Select Cancel if you do not want to copy the chart.
- Select Save & Exit to save the changes to your dashboard.
Deleting Dashboards
An entire dashboard may be deleted from the Dashboard Digest or Dashboard screen.
From the Dashboard Digest screen:
- Select the options button on the dashboard you want to remove.
- Select Delete.
- Select Delete Dashboard on the Delete Dashboard Confirmation screen to complete the dashboard deletion.
- Note: Select Cancel if you do not want to delete the dashboard.
From the Dashboard screen:
- Select the Edit button on the dashboard you want to remove.
- Select the Delete button on the dashboard you want to remove.
- Select Delete Dashboard on the Delete Dashboard Confirmation screen to complete the dashboard deletion.
- Note: Select Cancel if you do not want to delete the dashboard.