question

Felipesilveira-3707 avatar image
0 Votes"
Felipesilveira-3707 asked ·

Automate Azure SQL edition (from Standard to Basic)

Hello, I'm trying to figure it out how to change Azure SQL tier using automation. During the day I will use Standard S0 and during the night I want to reduce to Basic. My question is about parameter perflevel. Edition -> "Basic" PerfLevel -> [EmptyString] ?

azure-sql-databaseazure-automation
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Felipesilveira-3707 avatar image
1 Vote"
Felipesilveira-3707 answered ·

Solved!

Perflevel must be: "Basic"

Edition: "Basic"

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Great to hear you were able to resolve it and shared the answer here. It could benefit others as well.

1 Vote 1 ·
AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered ·

Hi @Felipesilveira-3707, welcome to Microsoft QnA forum.

You can set the perfLevel as any of these S0, S1, S2, S3, P1, P2, P3 etc. You can find the complete list below. Again as per edition we need to select these.

Resource limits for single databases using the DTU purchasing model - Azure SQL Database

Please let us know if this helps.


If answer helps, please mark it 'Accept Answer'




·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Felipesilveira-3707 avatar image
0 Votes"
Felipesilveira-3707 answered ·

Hi @AnuragSharma-MSFT, thanks for the answer.

But my doubt is how to set perflevel of basic tier. I try to leave field empty but doesn't work.


71587-basic.jpg



basic.jpg (48.8 KiB)
·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Felipesilveira-3707 avatar image
0 Votes"
Felipesilveira-3707 answered ·

I receive this erros from the job log:

Cannot validate argument on parameter 'ServiceObjectiveName'. The argument is null or empty. Provide an argument that is not null or empty, and then try the command again. At Set-AzureSqlDatabaseEdition:71 char:71 + + CategoryInfo : InvalidData: (:) [Get-AzureSqlDatabaseServiceObjective], ParameterBindingValidationException + FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.WindowsAzure.Commands.SqlDatabase.Database.Cmdl et.GetAzureSqlDatabaseServiceObjective

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.