Listing Windows Azure SQL Database User Table Sizes & Row Counts

June 28, 2013 — 1 Comment

In an attempt to identify anomalies cause by modifications to my Cloud Services, I decided to monitor the size of the tables I created in Windows Azure SQL Database. And since I have a rough estimate of the number of records that each table is supposed to contain, I can raise alerts when they start growing out of control.

The following query produces a list of non-system tables along with their size in gigabytes and the number of records they contain.

SELECT  AS [table_name],
      sum(p.reserved_page_count) * 8.0 / 1024 / 1024 AS [size_in_gb],
      p.row_count AS [records]
      sys.dm_db_partition_stats AS p,
      sys.objects AS o
      p.object_id = o.object_id
      AND o.is_ms_shipped = 0
GROUP BY , p.row_count

Trackbacks and Pingbacks:

  1. SQL Azure Table Size – Explosive Insight - August 2, 2018

    […] size just kept growing.  To find out the culprit, I wanted to know the size of each table.  This post from Alexandre Brisebois did just what I needed.  My only tweak was to Order By the […]


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.