Manage servers and databases with detailed utilities in SQL Operations Studio (preview)

Detailed utilities retrieve the Transact-SQL (T-SQL) queries you use to monitor servers and databases, then turn them into visual images.

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:

Manage servers and databases with detailed utilities in SQL Operations Studio (preview) Picture 1

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:

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

Detailed utility queries that define the data set showing numbers, graphs, or charts. Detailed queries of detailed utilities are used to list relevant details in tabular format, in the Insight details panel .

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.

See more:

1. CREATE LOGIN command in SQL Server
2. Grant / Revoke permissions in SQL Server
3. Index in SQL Server