Manage servers and databases with Insight widgets in SQL Operations Studio (preview)
Insight widgets take the Transact-SQL (T-SQL) queries you use to monitor servers & databases and turns them into insightful visualizations.
Insights are customizable charts and graphs that you add to server and database monitoring dashboards. View at-a-glance insights of your servers and databases, then drill into more details, and launch management actions that you define.
You can build awesome server and database management dashboards similar to the following example:
To jump in and start creating different types of insight widgets, check out the following tutorials:
- Build a custom insight widget
- Enable built-in insight widgets
SQL Queries
Insight widgets are composed of one or two T-SQL queries:
- Insight widget query is mandatory, and is the query that returns the data that appears in the widget.
- Insight details query is only required if you are creating an insight details page.
An insight widget query defines a dataset that renders a count, chart, or graph. Insight details query is used to list relevant insight detail information in a tabular format in the insight details panel.
The basic idea is to write a T-SQL query in a way so it can be used as a dataset of a count, chart, and graph widget.
Summary
The T-SQL query and its result set determine the insight widget behavior. Writing a query for a chart type or mapping a right chart type for existing query is the key consideration to build an effective insight widget.