Search notes:
PowerShell cmdLet get-azSqlServerServiceObjective
PS: C:\Users\rene> get-azSqlServerServiceObjective -location switzerlandNorth
ServiceObjectiveName SkuName Edition Family Capacity CapacityUnit Enabled
-------------------- ------- ------- ------ -------- ------------ -------
System System System 0 DTU False
System0 System System 0 DTU False
System1 System System 0 DTU False
System2 System System 0 DTU False
System3 System System 0 DTU False
System4 System System 0 DTU False
System2L System System 0 DTU False
System3L System System 0 DTU False
System4L System System 0 DTU False
Free Free Free 5 DTU True
Basic Basic Basic 5 DTU True
S0 Standard Standard 10 DTU True
S1 Standard Standard 20 DTU True
S2 Standard Standard 50 DTU True
S3 Standard Standard 100 DTU True
S4 Standard Standard 200 DTU True
S6 Standard Standard 400 DTU True
S7 Standard Standard 800 DTU True
S9 Standard Standard 1600 DTU True
S12 Standard Standard 3000 DTU True
P1 Premium Premium 125 DTU True
P2 Premium Premium 250 DTU True
P4 Premium Premium 500 DTU True
P6 Premium Premium 1000 DTU True
P11 Premium Premium 1750 DTU True
P15 Premium Premium 4000 DTU True
DW100c DataWarehouse DataWarehouse 900 DTU True
DW200c DataWarehouse DataWarehouse 1800 DTU True
DW300c DataWarehouse DataWarehouse 2700 DTU True
DW400c DataWarehouse DataWarehouse 3600 DTU True
DW500c DataWarehouse DataWarehouse 4500 DTU True
DW1000c DataWarehouse DataWarehouse 9000 DTU True
DW1500c DataWarehouse DataWarehouse 13500 DTU True
DW2000c DataWarehouse DataWarehouse 18000 DTU False
DW2500c DataWarehouse DataWarehouse 22500 DTU False
DW3000c DataWarehouse DataWarehouse 27000 DTU False
DW5000c DataWarehouse DataWarehouse 45000 DTU False
DW6000c DataWarehouse DataWarehouse 54000 DTU False
DW7500c DataWarehouse DataWarehouse 67500 DTU False
DW10000c DataWarehouse DataWarehouse 90000 DTU False
DW15000c DataWarehouse DataWarehouse 135000 DTU False
DW30000c DataWarehouse DataWarehouse 270000 DTU False
DS100 Stretch Stretch 750 DTU True
DS200 Stretch Stretch 1500 DTU True
DS300 Stretch Stretch 2250 DTU True
DS400 Stretch Stretch 3000 DTU True
DS500 Stretch Stretch 3750 DTU True
DS600 Stretch Stretch 4500 DTU True
DS1000 Stretch Stretch 7500 DTU True
DS1200 Stretch Stretch 9000 DTU True
DS1500 Stretch Stretch 11250 DTU True
DS2000 Stretch Stretch 15000 DTU True
GP_S_Gen5_1 GP_S_Gen5 GeneralPurpose Gen5 1 VCores True
GP_Gen5_2 GP_Gen5 GeneralPurpose Gen5 2 VCores True
GP_S_Gen5_2 GP_S_Gen5 GeneralPurpose Gen5 2 VCores True
GP_Gen5_4 GP_Gen5 GeneralPurpose Gen5 4 VCores True
GP_S_Gen5_4 GP_S_Gen5 GeneralPurpose Gen5 4 VCores True
GP_Gen5_8 GP_Gen5 GeneralPurpose Gen5 8 VCores True
GP_S_Gen5_8 GP_S_Gen5 GeneralPurpose Gen5 8 VCores True
GP_Gen5_16 GP_Gen5 GeneralPurpose Gen5 16 VCores True
GP_S_Gen5_16 GP_S_Gen5 GeneralPurpose Gen5 16 VCores True
GP_S_Gen5_20 GP_S_Gen5 GeneralPurpose Gen5 20 VCores True
GP_Gen5_24 GP_Gen5 GeneralPurpose Gen5 24 VCores True
GP_S_Gen5_24 GP_S_Gen5 GeneralPurpose Gen5 24 VCores True
GP_Gen5_32 GP_Gen5 GeneralPurpose Gen5 32 VCores True
GP_S_Gen5_32 GP_S_Gen5 GeneralPurpose Gen5 32 VCores True
GP_S_Gen5_40 GP_S_Gen5 GeneralPurpose Gen5 40 VCores True
GP_Gen5_80 GP_Gen5 GeneralPurpose Gen5 80 VCores True
BC_Gen5_2 BC_Gen5 BusinessCritical Gen5 2 VCores True
BC_Gen5_4 BC_Gen5 BusinessCritical Gen5 4 VCores True
BC_Gen5_8 BC_Gen5 BusinessCritical Gen5 8 VCores True
BC_Gen5_16 BC_Gen5 BusinessCritical Gen5 16 VCores True
BC_Gen5_24 BC_Gen5 BusinessCritical Gen5 24 VCores True
BC_Gen5_32 BC_Gen5 BusinessCritical Gen5 32 VCores True
BC_Gen5_80 BC_Gen5 BusinessCritical Gen5 80 VCores True
HSPS_1 HSPS_1 Hyperscale 1 VCores False
HSPSSmall_Gen4_1 HSPSSmall_Gen4 Hyperscale 1 VCores False
HS_Gen4_1 HS_Gen4 Hyperscale Gen4 1 VCores False
HSPSMini_Gen4_1 HSPSMini_Gen4 Hyperscale Gen4 1 VCores False
HSPS_2 HSPS_2 Hyperscale 2 VCores False
HSPSSmall_Gen4_2 HSPSSmall_Gen4 Hyperscale 2 VCores False
HSPSSmall_Gen5_2 HSPSSmall_Gen5 Hyperscale 2 VCores False
HSPSSmallMF_Gen5_2 HSPSSmallMF_Gen5 Hyperscale 2 VCores False
HSPS_Gen5_2 HSPS_Gen5 Hyperscale 2 VCores False
MIPS2G5 Hyperscale Hyperscale 2 VCores False
HSXLOG_2 HSXLOG_2 Hyperscale 2 VCores False
MIXL4G5 Hyperscale Hyperscale 2 VCores False
HS_Gen4_2 HS_Gen4 Hyperscale Gen4 2 VCores False
HS_Gen5_2 HS_Gen5 Hyperscale Gen5 2 VCores False
HSPSMini_Gen4_2 HSPSMini_Gen4 Hyperscale Gen4 2 VCores False
HSPSMini_Gen5_2 HSPSMini_Gen5 Hyperscale Gen5 2 VCores False
HSPSMiniMF_Gen5_2 HSPSMiniMF_Gen5 Hyperscale Gen5 2 VCores False
HSXLOG_Gen5_2 HSXLOG_Gen5 Hyperscale Gen5 2 VCores False
HSLR_Gen5_2 HSLR_Gen5 Hyperscale Gen5 2 VCores False
HSPSSmall_Gen5_4 HSPSSmall_Gen5 Hyperscale 4 VCores False
HSPS_Gen5_4 HSPS_Gen5 Hyperscale 4 VCores False
MIPS4G5 Hyperscale Hyperscale 4 VCores False
HSXLOG_4 HSXLOG_4 Hyperscale 4 VCores False
MIXL8G5 Hyperscale Hyperscale 4 VCores False
HS_Gen4_4 HS_Gen4 Hyperscale Gen4 4 VCores False
HS_Gen5_4 HS_Gen5 Hyperscale Gen5 4 VCores False
HSPSMini_Gen5_4 HSPSMini_Gen5 Hyperscale Gen5 4 VCores False
HSXLOG_Gen5_4 HSXLOG_Gen5 Hyperscale Gen5 4 VCores False
HSLR_Gen5_4 HSLR_Gen5 Hyperscale Gen5 4 VCores False
HSPS_Gen5_8 HSPS_Gen5 Hyperscale 8 VCores False
HSXLOG_8 HSXLOG_8 Hyperscale 8 VCores False
HS_Gen4_8 HS_Gen4 Hyperscale Gen4 8 VCores False
HS_Gen5_8 HS_Gen5 Hyperscale Gen5 8 VCores False
HSXLOG_Gen5_8 HSXLOG_Gen5 Hyperscale Gen5 8 VCores False
HSLR_Gen5_8 HSLR_Gen5 Hyperscale Gen5 8 VCores False
HSPS_Gen5_16 HSPS_Gen5 Hyperscale 16 VCores False
MIPS16G5 Hyperscale Hyperscale 16 VCores False
HSXLOG_16 HSXLOG_16 Hyperscale 16 VCores False
HS_Gen4_16 HS_Gen4 Hyperscale Gen4 16 VCores False
HS_Gen5_16 HS_Gen5 Hyperscale Gen5 16 VCores False
HSXLOG_Gen5_16 HSXLOG_Gen5 Hyperscale Gen5 16 VCores False
HSLR_Gen5_16 HSLR_Gen5 Hyperscale Gen5 16 VCores False
HS_Gen5_20 HS_Gen5 Hyperscale Gen5 20 VCores False
HSXLOG_Gen5_20 HSXLOG_Gen5 Hyperscale Gen5 20 VCores False
HS_Gen4_24 HS_Gen4 Hyperscale Gen4 24 VCores False
HS_Gen5_24 HS_Gen5 Hyperscale Gen5 24 VCores False
HSXLOG_Gen5_24 HSXLOG_Gen5 Hyperscale Gen5 24 VCores False
HS_Gen5_32 HS_Gen5 Hyperscale Gen5 32 VCores False
HSXLOG_Gen5_32 HSXLOG_Gen5 Hyperscale Gen5 32 VCores False
HS_Gen5_40 HS_Gen5 Hyperscale Gen5 40 VCores False
HSXLOG_Gen5_40 HSXLOG_Gen5 Hyperscale Gen5 40 VCores False
HS_Gen5_48 HS_Gen5 Hyperscale Gen5 48 VCores False
HSXLOG_Gen5_48 HSXLOG_Gen5 Hyperscale Gen5 48 VCores False
HS_Gen5_80 HS_Gen5 Hyperscale Gen5 80 VCores False
HSXLOG_Gen5_80 HSXLOG_Gen5 Hyperscale Gen5 80 VCores False
See also
ServiceObjectiveName
might be used in the
new-azSqlDatabase
cmdLet for the
-requestedServiceObjectiveName
parameter.