|
2 | 2 | title: "Tutorial: Enable the table space usage sample insight widget in SQL Operations Studio (preview) | Microsoft Docs" |
3 | 3 | description: This tutorial demonstrates how to enable the table space usage sample insight widget on the SQL Operations Studio (preview) database dashboard. |
4 | 4 | ms.custom: "tools|sos" |
5 | | -ms.date: "11/15/2017" |
| 5 | +ms.date: "03/19/2018" |
6 | 6 | ms.prod: "sql-non-specified" |
7 | 7 | ms.reviewer: "alayu; erickang; sstein" |
8 | 8 | ms.suite: "sql" |
@@ -36,26 +36,36 @@ This tutorial requires the SQL Server or Azure SQL Database *TutorialDB*. To cre |
36 | 36 | ## Turn on a management insight on [!INCLUDE[name-sos](../includes/name-sos-short.md)]'s database dashboard |
37 | 37 | [!INCLUDE[name-sos](../includes/name-sos-short.md)] has a built-in sample widget to monitor the space used by tables in a database. |
38 | 38 |
|
39 | | -1. Open **User Settings** by pressing **Ctrl+Shift+P** to open *Command Palette*, type *settings* in the search box and select **Preferences: Open User Settings**. |
| 39 | +1. Open *User Settings* by pressing **Ctrl+Shift+P** to open the *Command Palette*. |
| 40 | +2. Type *settings* in the search box and select **Preferences: Open User Settings**. |
40 | 41 |
|
41 | 42 |  |
42 | 43 |
|
43 | 44 | 2. Type *dashboard* in Settings Search input box and locate **dashboard.database.widgets**. |
44 | 45 |
|
45 | 46 |  |
46 | 47 |
|
47 | | -3. To customize the **dashboard.database.widgets** setting, hover over the pencil icon to the left of the **dashboard.database.widgets** text, click **Edit** > **Copy to Settings**. |
| 48 | +3. 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. |
48 | 49 |
|
49 | | -4. Using [!INCLUDE[name-sos](../includes/name-sos-short.md)]'s insight settings IntelliSense, configure *name* for the widget title, *gridItemConfig* for the widget size, and *widget* by selecting **table-space-db-insight** from the drop-down list as shown in the following screenshot: |
| 50 | +4. In the **dashboard.database.widgets** section, add the following: |
50 | 51 |
|
51 | | -  |
| 52 | + ```json |
| 53 | + { |
| 54 | + "name": "Table space usage", |
| 55 | + "gridItemConfig": { |
| 56 | + "sizex": 2, |
| 57 | + "sizey": 1 |
| 58 | + }, |
| 59 | + "widget": { |
| 60 | + "table-space-db-insight": null |
| 61 | + } |
| 62 | + }, |
| 63 | + ``` |
52 | 64 |
|
53 | 65 | 5. Press **Ctrl+S** to save the settings. |
54 | 66 |
|
55 | 67 | 6. Open database dashboard by right-clicking **TutorialDB** and click **Manage**. |
56 | 68 |
|
57 | | -  |
58 | | - |
59 | 69 | 7. View *Space used by tables* as shown in the following screenshot: |
60 | 70 |
|
61 | 71 |  |
|
0 commit comments