This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have a database with the following setup (2vCores and 500GB max size)
I want to increase the allocated max size from say 500GB to 600GB but, before performing that operation I would like to check if there is enough space for it.
I can get the existing maximum storage size (500GB) with the property "MaxSizeBytes" from the cmdlet Get-AzSqlDatabase.
Get-AzSqlDatabase -ServerName <server-name> -DatabaseName <database-name> -ResourceGroupName <resource-group-name>
how do I get the allowed maximum storage capacity using the PowerShell for the same 2vCores which is 1024GB? Is there any specific metric which from which I can get this information instead of from the portal?
Hi @Rushikesh Gaidhani I am checking to see if you got a chance to look into the below response. Please let me know if you have any further questions.
If this answers your question, please consider accepting the answer by hitting the Accept answeras it helps the community look for answers to similar questions.
Regards
Geetha
Hi
The document does mention about the data size limit but, I'm still looking for an API or powershell cmdlet to get the max data size information dynamically for a service level objectives.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
I believe you can check from the portal -- Overview page of SQL Database and you can find used, remaining, allocated and max storage details.
You can also use below powershell command and get the MaxSizeBytes details.
Get-AzSqlDatabase -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName
Thank you!
Hi @RahulRandive
I am interested in the how much maximum data size (underlined in attached image 1) I can have for my database. I can get that information from the portal but, is there any way I can get that metric from any cmdlet or az cli?
for example, in this case for a 2vCore setup currently I've allocated 500GB but, I can increase my data allocation to a maximum of 1024GB. Is there any way I can get this allowed max data size information?
Hi Rushikesh Gaidhani •
The table below can provide you with information about the allowed maximum data size based on vCores.
Example GP_Gen5_2vCore- max data size in 1024 GB and 8vCore-2048 GB etc.
Here is a reference document
Hope this helps!
Thank you!
Thanks @RahulRandive this helps!
But, is there any REST api/az cli/Powershell cmdlet which I can use to get the same above information?
