Skip to content

tutorial-table-space-sql-server.md

Latest commit

 

History

History
75 lines (50 loc) · 3.66 KB

tutorial-table-space-sql-server.md

File metadata and controls

75 lines (50 loc) · 3.66 KB
title Enable the table space usage insight widget in SQL Operations Studio | Microsoft Docs
description This example shows how to enable the table space usage widget on the SQL Operations Studio database dashboard.
keywords
ms.custom tools|sos
ms.date 11/06/2017
ms.prod sql-non-specified
ms.reviewer alayu; erickang; sstein
ms.suite sql
ms.tgt_pltfrm
ms.topic tutorial
author erickangMSFT
ms.author erickang
manager craigg
ms.workload Inactive

Monitor Table Space Usage with [!INCLUDEname-sos]

In this tutorial, we will walk through how to enable an insight widget on Dashboard to get an at-a-glance view about the space usage for all tables in a database. After following through this tutorial, you will learn how to:

[!div class="checklist"]

  • 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

Prerequisites

  • Follow [Get Started with [!INCLUDEname-sos]](./get-started-sql-server.md) to a SQL Server 2017 instance and TutorialDB database.

Turn on a management insight on [!INCLUDEname-sos]'s database Manage dashboard

[!INCLUDEname-sos] has a built-in sample widget to monitor the space used by tables in a database.

  1. Open User Settings by pressing 'F1' to open Command Palette, type in 'settings' in the command search input box and select 'Preferences: Open User Settings' command.

    Open user settings command

  2. Type 'dashboard' in Settings Search input box to search "dashboard.database.widgets" in Settings.

    Search settings

  3. Click 'Copy to Settings' to copy "dashboard.database.widgets" settings to customize.

  4. Using [!INCLUDEname-sos]'s insight settings IntelliSense, configure 'name' for the widget title, 'gridItemConfig' for the widget size, and 'widget' by selecting 'table-space-database-insight' from the drop-down list as shown in the screenshot below:

    Insight settings

  5. Press 'CTRL + S' to save the user's settings file.

  6. Open Database dashboard by navigate to 'TutorialDB' in Servers viewlet, and click 'Manage' in the context menu.

    Open dashboard

  7. View 'Space used by tables' as shown in the screen shot below:

    Widget

Working with insight chart

[!INCLUDEname-sos]'s insight chart provides filtering and mouse-hover detail view functionality. To try out follow the steps below:

  1. Click and toggle 'row_count' legend on the chart. [!INCLUDEname-sos] shows and hides data series as user toggle on or off a legend.

  2. Hover the mouse pointer over a chart. [!INCLUDEname-sos] shows more information about the data series label and its value as shown on the screenshot.

    chart toggle and legend

Next steps

In this tutorial, you learned how to:

[!div class="checklist"]

  • 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, see [Build a custom insight widget]](tutorial-build-custom-insight-sql-server.md).