Microsoft Azure Data Studio – MSSQL DB Insights

Hello Friends,

In Microsoft Ignite 2018 Conference, Microsoft announced GA release of Azure Data Studio. In preview, this tool was known as SQL Operations Studio. Today we will see a new extension – MSSQL DB Insights.

Open Azure Data Studio and go to Extension. Search MSSQL and click on Install for MSSQL DB Insights.  This will open a Github link and download VSIX of the release you want.

Microsoft Azure Data Studio - MSSQL DB Insights 1

Microsoft Azure Data Studio - MSSQL DB Insights 2

Now Go to Azure Data Studio extensions, Click on install from VSIX option as shown below:

Microsoft Azure Data Studio - MSSQL DB Insights 3

Now just Click on Reload for MSSQL DB Insight. Connect SQL Server Instance.

This will open a new tab for MSSQL DB Insights. On this tab, we can get lot of information about Sessions – Database Sessions Count Graph based on Session Status and Resource Consumption based on Session Status.

Microsoft Azure Data Studio - MSSQL DB Insights 4

To get more information about database health, click on DB Health section and it will provide lot of information about Database space used and free (for complete database and for individual file level as well). This will also provide information about active and inactive VLFs. If you don’t have any idea about VLF’s and want to learn then click here.

Microsoft Azure Data Studio - MSSQL DB Insights 5

HAPPY LEARNING!

Regards:
Prince Kumar Rastogi
Follow Prince Rastogi on Twitter | Follow Prince Rastogi on FaceBook

Leave a Reply

Your email address will not be published. Required fields are marked *