search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.58k stars 908 forks source link

Server Reports: Top 10 DB Space Usage graph is empty #8794

Open gregveres opened 4 years ago

gregveres commented 4 years ago

Steps to Reproduce:

  1. I have a SQL database hosted in Azure. (It is a Standard S0 instance).
  2. I connect to the database (I can do all the normal ADS operations like query, edit etc)
  3. I have installed the Server Reports extension (v0.2.1) and when I click Manage then Server Reports, Only the Top 10 DB Buffer Usage is filled in. The other tables on the page are not filled in.

Why won't it show the Top 10 DB Space Usage graph?

I installed Server Reports because I am trying to figure out the size of all the tables in my database since it seems to have jumped in total size recently.

Charles-Gagnon commented 4 years ago

First off - the Server Reports extension doesn't report table space usage. Just database level. So if you're specifically looking for which tables are the largest you'll need to use your own queries for that.

But if you still wanted to see the database size then currently you'll have to use some other method to determine that as the query used isn't compatible with SQL Azure. You can run your own query by following the instructions here though (modifying as desired to show the databases that you're interested in).