{"push_id":661099514,"size":1,"distinct_size":1,"ref":"refs/heads/enable_sta_hint","head":"59483927202e463f80de3c048026b9be147ab921","before":"cd51d8f5f3d2fd9fe795cd2e0474f6eec2322cf8","commits":[{"sha":"59483927202e463f80de3c048026b9be147ab921","author":{"email":"6d8a4d9fe0fa387c03f1d22128138e6992695f69@gmail.com","name":"milosevic81"},"message":"-- DO NOT MERGE --\n\nThis changeset adds commandlets needed to support automatic upgrade scenario\n\nOverview\n\nUsing WI powershell commandlets user can get recommended mapping of his databases to elastic pools and database tiers. This can be used in conjunction with Start-AzureSqlServerUpgrade to automatically migrate and update all database on server to recommended v12 editions, and also with Start-AzureSqlServerTierUpdate to update database tier to recommended values.\n\nService Tier Advisor\n\nGet recommendations for all databases on server\nGet-AzureSqlServiceTierAdvisor -ResourceGroupName RG1 -ServerName SRV1\n\nGet recommendations for specific database\nGet-AzureSqlServiceTierAdvisor -ResourceGroupName RG1 -ServerName SRV1 -DatabaseName DB1\n\nGet recommendation for databases that are not recommended for elastic pool\nGet-AzureSqlServiceTierAdvisor -ResourceGroupName RG1 -ServerName SRV1 -ExcludeEPCandidates true\n\nReturns collection of\nMicrosoft.Azure.Management.Sql.Models.RecommendedDatabaseProperties\n\tName - Name of database\n\tTargetEdition - Target edition\n\tTargetServiceLevelObjective - Target SLO\n\nRecommended Elastic Pool\n\nGet elastic pool recommendations for server\nGet-AzureSqlElasticPoolRecommendations -ResourceGroupName RG1 -ServerName SRV1\n\nReturns collection of UpgradeElasticPoolProperties\n\t\tDatabaseCollection\n\t\tDatabaseDtuMin: DTU guarantee for database in elastic pool\n\t\tDatabaseDtuMax: DTU cap for database in elastic pool\n\t\tDtu: DTU gurantee for elastic pool\n\t\tEdition: Edition for elastic pool\n\t\tIncludeAllDatabases: Flag to indicate that include all databases in server in the elastic pool.\n\t\tName: name of elastic pool\n\t\tStorageMb: Storage limit in Mb for elastic pool.\n\n\tWhere DatabaseCollection is collection of RecommendedElasticPoolDatabaseProperties\n\t\tName: name of database\n\t\tDtuMin\n\t\tDtuMax\n\nExample: Start-AzureSqlServerUpgrade\n\nUsing this commandlet user can upgrade server to new version Upgrade and Cancel: Powershell\n\n$elasticPools =  Get-AzureSqlElasticPoolRecommendations -ResourceGroupName RG1 -ServerName SRV1\n$databases  = Get-AzureSqlServiceTierAdvisor -ResourceGroupName RG1 -ServerName SRV1 -ExcludeEPCandidates true\nStart-AzureSqlServerUpgrade -ResourceGroupName RG1 -ServerName SRV1 -Version 12.0 -DatabaseCollection $databases -ElasticPoolCollection $elasticPools","distinct":true,"url":"https://api.github.com/repos/milosevic81/azure-powershell/commits/59483927202e463f80de3c048026b9be147ab921"}]}