Advertisement
CloudyOne

Scale AzureSql ElasticPool

Jan 14th, 2019
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Connect-AzureRmAccount
  2.  
  3. $subscriptionId = ""
  4. $resourcegroupname = ""
  5. $location = ""
  6. $poolname = ""
  7. $servername = ""
  8.  
  9. Select-AzureRmSubscription -Subscription $subscriptionId
  10.  
  11. $resourcegroup = Get-AzureRmResourceGroup -Name $resourcegroupname -Location $location
  12. $server = Get-AzureRmSqlServer -ResourceGroupName $resourcegroupname -ServerName $servername
  13. $elasticpool = Get-AzureRmSqlElasticPool -ResourceGroupName $resourcegroupname -ServerName $servername -ElasticPoolName $poolname
  14.  
  15. $elasticpool = Set-AzureRmSqlElasticPool -ResourceGroupName $resourcegroupname -ServerName $servername -ElasticPoolName $poolname -VCore 6 -ComputeGeneration Gen4 -Edition GeneralPurpose
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement