Manage Servers and Databases with Detailed Utilities in SQL Operations

This guide covers manage servers and databases with detailed utilities in SQL operations with practical context and easy-to-follow details. Use it to understand the subject and apply the information confidently.

Detailed utilities are customizable graphs and charts, which you add to the dashboard page to monitor the server and database. Take a look at the detailed utilities of your server and database, then see more details and launch management actions that you define.

You can build dashboard pages to manage servers and excellent databases, similar to the following example:

SQL Query

SQL Operations Studio (preview) tries to avoid introducing another heavy language or user interface, and trying to use T-SQL as much as possible with the minimum JSON configuration. Configure detailed utilities with T-SQL, take advantage of the countless useful T-SQL query sources that are currently available and can be turned into really useful utilities.

Detailed utilities include one or two T-SQL queries:

• The Insight widget query Is required and the query returns data that appears in the widget.
• Insight details query is Only required if you are creating a detailed information page inside.

SQL Operations Studio (preview) performs detailed utility queries and maps the query result set to the chart's data set, then displays it. When the user opens the details of the detailed utility, it will perform a detailed query about that detailed utility and print the result in a grid view in the dialog box.

The basic idea is to write a T-SQL query, in such a way that it can be used as a data file of counting utilities, charts and graphs.

Its T-SQL query and result set determine the behavior of the detailed utility. Writing a query for a chart type or mapping an appropriate chart type for an existing query is the main consideration for building an effective detailed utility.