Page History: Databases and Their Service Objectives - SQL Azure

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: Tue, Mar 08, 2022, 12:58 PM

Run the following SQL against the MASTER database on a SQL Azure server.

SELECT 
     [Name]     = d.[name]
    ,[State]    = d.state_desc
    ,slo.*
FROM 
    sys.databases d
    INNER JOIN sys.database_service_objectives slo
        ON d.database_id = slo.database_id
order by 
    d.Name