Backup Storage Cost for Azure SQL

Azure SQL provides up to 200% of max provisioned database storage as backup and that also at no additional cost at all. However admins should be aware that there is a limitation according to the tier for the log size. eg for P1 it is 150GB.

I encourage admins to keep an eye on the log size by using below command. Some automation could be created to log this info in one SQL table every half an hour and finalize some alert on this table.

SELECT FILEPROPERTY (name, ‘SpaceUsed’)/128 UsedDBSize_MB
,max_size/128 MaxDBSize_MB
FROM sys.database_files
WHERE type_desc = ‘LOG’

Advertisements

One comment

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s