Tutorial: Enable the table space usage sample insight widget using SQL Operations Studio (preview)

This tutorial demonstrates how to enable an insight widget on the database dashboard, providing an at-a-glance view about the space usage for all tables in a database. During this tutorial, you learn how to:

  • Quickly turn on an insight widget using a built-in insight widget example
  • View the details of table space usage
  • Filter data and view label detail on an insight chart

Prerequisites

This tutorial requires the SQL Server or Azure SQL Database TutorialDB. To create the TutorialDB database, complete one of the following quickstarts:

Turn on a management insight on SQL Operations Studio (preview)'s database dashboard

SQL Operations Studio (preview) has a built-in sample widget to monitor the space used by tables in a database.

  1. Open User Settings by pressing Ctrl+Shift+P to open the Command Palette.
  2. Type settings in the search box and select Preferences: Open User Settings.
  3. Type dashboard in Settings Search input box and locate dashboard.database.widgets.

  4. To customize the dashboard.database.widgets settings you need to edit the dashboard.database.widgets entry in the USER SETTINGS section (the column in the right side). If there is no dashboard.database.widgets in the USER SETTINGS section, hover over the dashboard.database.widgets text in the DEFAULT SETTINGS column and click the pencil icon that appears to the left of the text and click Copy to Settings. If the pop-up says Replace in Settings, don't click it! Go to the USER SETTINGS column to the right and locate the dashboard.database.widgets section and advance to the next step.

  5. In the dashboard.database.widgets section, add the following:

         {
             "name": "Space Used by Tables",
             "gridItemConfig": {
                 "sizex": 2,
                 "sizey": 1
             },
             "widget": {
                 "table-space-db-insight": null
             }
         },
    

    The dashboard.database.widgets section should look similar to the follwing image:

    Search settings

  6. Press Ctrl+S to save the settings.

  7. Open database dashboard by right-clicking TutorialDB and click Manage.

  8. View the table space insight widget as shown in the following image:

    Widget

Working with the insight chart

SQL Operations Studio (preview)'s insight chart provides filtering and mouse-hover details. To try out the following steps:

  1. Click and toggle the row_count legend on the chart. SQL Operations Studio (preview) shows and hides data series as you toggle a legend on or off.

  2. Hover the mouse pointer over the chart. SQL Operations Studio (preview) shows more information about the data series label and its value as shown in the following screenshot.

    chart toggle and legend

Next steps

In this tutorial, you learned how to:

  • Quickly turn on an insight widget using a built-in insight widget sample.
  • View the details of table space usage.
  • Filter data and view label detail on an insight chart

To learn how to build a custom insight widget, complete the next tutorial: