jeudi 12 mars 2015

Whats the syntax to change the performance level (SLO) of a SQL Azure database?


The MSDN page


states



-- Azure SQL Database Syntax
ALTER DATABASE database_name
{
MODIFY NAME =new_database_name
| MODIFY ( <edition_options> [, ... n] )
| COLLATE collation_name
| SET { <set_database_options> }
}

<edition_options> ::=
{
MAXSIZE = { 100 MB | 500 MB |1 | 5 | 10 | 20 | 30 … 150 … 500 } GB
| EDITION = { 'web' | 'business' | 'basic' | 'standard' | 'Premium' }
| SERVICE_OBJECTIVE = { 'shared' | 'basic' | 'S0' | 'S1' | 'S2' | 'P1' | 'P2' | 'P3' }
}

<set_database_options> ::=
<db_update_option>
<db_update_option> ::=
{ READ_ONLY | READ_WRITE }
[;]


I tried the following, however they are all failing with syntax errors



ALTER DATABASE SCRATCH1
{
MODIFY (EDITION = 'STANDARD' , SERVICE_OBJECTIVE = 'S0')
};

ALTER DATABASE SCRATCH1
{
MODIFY (EDITION = 'STANDARD' | SERVICE_OBJECTIVE = 'S0')
};

ALTER DATABASE SCRATCH1
MODIFY (EDITION = 'STANDARD' , SERVICE_OBJECTIVE = 'S0');

ALTER DATABASE SCRATCH1
MODIFY (EDITION = 'STANDARD' | SERVICE_OBJECTIVE = 'S0');


Clearly I'm misinterpreting the MSDN doc, so, what is the correct syntax?





Aucun commentaire:

Enregistrer un commentaire