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.
Now Go to Azure Data Studio extensions, Click on install from VSIX option as shown below:
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.
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.