MSSQL Instance Insights
This collection of widgets are designed to provide insights into MSSQL Instance to further extend the built-in default widgets.
Where possible all of these widgets will include more detail when you click Show Details from the widget menu.
These widgets have been tested against the following SQL Server versions:
- SQL Server 2016
- SQL Server 2017 (Windows & linux)
If you find any issues using these widgets on these supported SQL Server versions, or any other versions please create an issue as we would like to make these available for as many releases as possible.
We are looking for testers to confirm other environments. So if you find they do work on other releases let me know, and credit will be given.
This Server Dashboard widget includes information on the top 10 waits for the SQL Instance. Information will be shown in the form of a bar chart.
You can access more information about the waits in the detailed fly-out displayed when you select "..." on the widget.
Credit for the query this widget is based on goes to Paul Randal - Tell me where it hurts
To enable this widget add the following json to either your user or workspace settings in the dashboard.server.widgets section.
{
"name": "Top 10 Waits",
"widget": {
"mssql-instance-waits": null
}
}This Server Dashboard widget includes information on the general system performance captured by the Extended Events System Health Session for the SQL Instance. Information will be shown in the form of a line chart. If the System Health Session is stopped or the instance has been restarted will affect the amount of data available for this widget.
You can access more information in the detailed fly-out displayed when you select "..." on the widget.
Credit for the query this widget is based on goes to troubleshootingsql.com
This widget is not currently supported on Azure SQL DB due to lack of support for Extended Events.
To enable this widget add the following json to either your user or workspace settings in the dashboard.server.widgets section.
{
"name": "XEL System Stats",
"widget": {
"mssql-instance-xelsystem": null
}
}This Server Dashboard widget includes information on the IO performance captured by the Extended Events System Health Session for the SQL Instance. Information will be shown in the form of a line chart. If the System Health Session is stopped or the instance has been restarted will affect the amount of data available for this widget.
You can access more information in the detailed fly-out displayed when you select "..." on the widget.
Credit for the query this widget is based on goes to troubleshootingsql.com
This widget is not currently supported on Azure SQL DB due to lack of support for Extended Events.
To enable this widget add the following json to either your user or workspace settings in the dashboard.server.widgets section.
{
"name": "XEL IO Stats",
"widget": {
"mssql-instance-xelio": null
}
}This Server Dashboard widget includes information on the Memory performance captured by the Extended Events System Health Session for the SQL Instance. Information will be shown in the form of a line chart. If the System Health Session is stopped or the instance has been restarted will affect the amount of data available for this widget.
You can access more information in the detailed fly-out displayed when you select "..." on the widget.
Credit for the query this widget is based on goes to troubleshootingsql.com
This widget is not currently supported on Azure SQL DB due to lack of support for Extended Events.
To enable this widget add the following json to either your user or workspace settings in the dashboard.server.widgets section.
{
"name": "XEL Memory Stats",
"widget": {
"mssql-instance-xelmemory": null
}
}