Skip to content

Migrate costs saver to Az Powershell module #22

@akuryan

Description

@akuryan

Main problem - Elastic pool, provisioned in vCore model will return nothing on pool.Dtu (or 0 in later version of AzureRm):

PS C:\Users\> $elasticPools[0]
ResourceId        : 
ResourceGroupName : RgName
ServerName        : sqlServerName
ElasticPoolName   : poolName
Location          : 
CreationDate      : 5/23/2019 12:01:24 PM
State             : Ready
Edition           : None
Dtu               :
DatabaseDtuMax    : -1
DatabaseDtuMin    : -1
StorageMB         : 102400
Tags              :
ZoneRedundant     : False

Same goes for database itself, as it shows Sku equal to None:

ResourceGroupName             : RgName
ServerName                    : sqlServerName
DatabaseName                  : sqlDbName
Location                      : 
DatabaseId                    : 
Edition                       : None
CollationName                 : 
CatalogCollation              :
MaxSizeBytes                  : 
Status                        : 
CreationDate                  : 
CurrentServiceObjectiveId     : 
CurrentServiceObjectiveName   : 
RequestedServiceObjectiveId   : 
RequestedServiceObjectiveName :
ElasticPoolName               : 
EarliestRestoreDate           : 
ResourceId                    : 
CreateMode                    :
ReadScale                     : 
ZoneRedundant                 : 



PS C:\Users\> $sqlDatabases[1].Edition
None
PS C:\Users\> $currentDbSku = $sqlDatabases[1].Edition
PS C:\Users\> $currentDbSku
None

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingcosts.saverLabel to describe that issue is related to Azure Costs Saver modulehelp wantedExtra attention is needed

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions