0 votes
1 view
in Azure by (41.3k points)

How can I calculate the current size of a SQL Azure Database? (Not the maximum size limit)

Several places (like this) suggest using this SQL:

SELECT SUM(reserved_page_count) * 8192

FROM    sys.dm_db_partition_stats

However, when executing this as the Administrator login I get this error:

Msg 297, Level 16, State 1, Line 1

The user does not have permission to perform this action.

1 Answer

0 votes
by (16.8k points)

This is probably because you're running the query on the master database. If you're using SQL Server Management Studio, choose your database first (not the master database), and execute the query. This should work. Oh and by the way, if you want the size in megabytes, try the following:

SELECT (SUM(reserved_page_count) * 8192) / 1024 / 1024 AS DbSizeInMB

FROM    sys.dm_db_partition_stats

OR You can check your database size and its usage through Windows Azure Management Portal also. 

enter image description here

Source: https://azure.microsoft.com/en-us/documentation/articles/sql-database-monitoring-with-dmvs/

Welcome to Intellipaat Community. Get your technical queries answered by top developers !