Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Databases and Their Service Objectives - SQL Azure

RSS
Modified on Thu, Apr 14, 2022, 1:40 PM by Administrator Categorized as SQL Azure, SQL Server System Tables

Getting

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

Changing

Note: "n" is a number between 0 and 9.

alter database [MyDatabase] modify (service_objective='Sn')

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.