How-to find out reserved and available Disk Space on SQL MI

Published Aug 11 2021 09:07 AM 1,689 Views
Microsoft

In the previous blog posts we have shared the scripts on how to determine your SQL Managed Instance Service Tier type, computing (CPU vCores) and memory (RAM) parameters.

If you are interested in other posts on how-to discover different aspects of SQL MI - please visit the http://aka.ms/sqlmi-howto, which serves as a place holder for the series.
As indicated in the previous post, in this how-to post we shall dive into the reserved and available disk spaces for the SQL MI.

 

There are a couple of important aspects related to the disk reserved & used space:

  • The total reserved disk space. This parameter is controlled outside of the SQL Managed Instance running environment, with the help of the Azure Portal or any of the supported command interfaces, such as CLI & PowerShell, but the reserved values and used values can be observed with the help of T-SQL. 
  • The total available and used space for the local SSD drives on General Purpose service tier of SQL MI, which is not included into the previous parameter.

Total Reserved & Used Disk Space

The total amount of reserved disk space means the total addressable space for data and log files that SQL MI can use. For the General Purpose (GP) service tier, the amount of space that is available for the TempDB is different, because it is not included in the total – giving you potentially an extra couple of hundreds of GBs of local SSD storage (the exact number will depend on selected configuration and the hardware generation).

The information about the total reserved space can be found in the master.sys.server_resource_stats DMV (currently exclusive for Azure SQL DB & Azure SQL MI), under the column [reserved_storage_mb] and the respective used amount of storage is located in the same DMV in the [storage_space_used_mb] column. As in previous how-to articles, we need to obtain the latest available timestamp by sorting descending on the [end_time] column in order to obtain the latest information about the space.
The query below extracts this information together with the calculation of the overall used percentage.
Warning: it does not mean that all of the underlying space was actually occupied by data, it means that your database data and log files have reserved this amount by growing their respective size.

 

 

SELECT TOP 1 reserved_storage_mb, storage_space_used_mb, CAST( (storage_space_used_mb * 100. / reserved_storage_mb) as DECIMAL(9,2)) as [ReservedStoragePercentage]
       FROM master.sys.server_resource_stats
       ORDER BY end_time DESC;

 

 

NikoNeugebauer_0-1628692662020.pngOn my small test SQL Managed Instance I have 262144 MB (256 GB) of the reserved space and I have currently used (created data & log files) that occupy 261062 MB (254.96 GB), representing 99.59% of the available reserved space. 
This is one of the key monitoring and troubleshooting aspects that needs to be payed attention to.
The owner is in the control of the reserved space and we are not automatically increasing it, since such change would represent a monetary impact on our customers - and such changes must be approved and executed by the customers.

 

Reserved space for TempDB on General Purpose (GP) service tier:

A well documented fact in Resource limits - Azure SQL Managed Instance | Microsoft Docs is that on the General Purpose (GP) service tier, all storage for user databases is a remote one, with only [TempDB] database being located on the fast local SSD for providing the best possible performance of the SQL MI. This space on the local SSD is not not included in the total reserved space and is not exposed in the master.sys.server_resource_stats DMV.  Limited to 24 GB/vCore (96 - 1,920 GB) and currently available instance storage size, this space provides huge opportunity 

On Business Critical (BC) service tier, since all storage is local and this is definitely not applicable - meaning that we are giving SQL MI on GP a kind of a great bonus.

 

 

IF ( (SELECT TOP 1 SKU
		FROM [sys].[server_resource_stats] 
			ORDER BY end_time DESC) = 'GeneralPurpose' )
BEGIN
	SELECT vs.volume_mount_point as VolumeMountPoint,
		   CAST(MIN(total_bytes / 1024. / 1024 / 1024) AS NUMERIC(9,2)) as LocallyUsedGB,
		   CAST(MIN(available_bytes / 1024. / 1024 / 1024) AS NUMERIC(9,2)) as LocallyAvailableGB,
		   CAST(MIN((total_bytes+available_bytes) / 1024. / 1024 / 1024) AS NUMERIC(9,2)) as LocallyTotalGB
	FROM sys.master_files AS f
		CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) vs
	WHERE UPPER(vs.volume_mount_point) like 'C:\%' 
	GROUP BY vs.volume_mount_point;
END

 

 

NikoNeugebauer_1-1628694814578.png

On my test SQL MI with just 4 CPU vCores, I have received 96 GB of the local space for TempDB and currently used just around 0.19 GB, leaving 95.81 GB still available. Keep in mind that this reserved space is applicable for the whole TempDB database, including Log File, which is currently limited to 120 GB at maximum.


Joining the information about the reserved remote storage (256 GB) and the local SSD (96 GB) gives the final value of 352 GB, you can use the following query to find it out on General Purpose (GP) service tier:

 

 

SELECT SUM(TotalGB) as TotalSpaceGB
	FROM (
	SELECT vs.volume_mount_point as VolumeMountPoint,
		   CAST(MIN(total_bytes / 1024. / 1024 / 1024) AS NUMERIC(9,2)) as UsedGB,
		   CAST(MIN(available_bytes / 1024. / 1024 / 1024) AS NUMERIC(9,2)) as AvailableGB,
		   CAST(MIN((total_bytes+available_bytes) / 1024. / 1024 / 1024) AS NUMERIC(9,2)) as TotalGB
	FROM sys.master_files AS f
		CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) vs
	GROUP BY vs.volume_mount_point) fsrc;

 

 

NikoNeugebauer_2-1628696500271.png


As we progress improving SQL MI, some of the details might change in the future, but the path for discovery with the help of T-SQL should remain valid.

%3CLINGO-SUB%20id%3D%22lingo-sub-2636930%22%20slang%3D%22en-US%22%3EHow-to%20find%20out%20reserved%20and%20available%20Disk%20Space%20on%20SQL%20MI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2636930%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20previous%20blog%20posts%20we%20have%20shared%20the%20scripts%20on%20how%20to%20determine%20your%20SQL%20Managed%20Instance%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-sql%2Fhow-to-find-out-the-sql-mi-service-tier-basic-details-with-t-sql%2Fba-p%2F2520706%22%20target%3D%22_self%22%3EService%20Tier%20type%3C%2FA%3E%2C%20computing%20(%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-sql%2Fhow-to-find-out-the-sql-mi-number-of-cpu-vcores%2Fba-p%2F2594971%22%20target%3D%22_self%22%3ECPU%20vCores%3C%2FA%3E)%20and%20memory%20(%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-sql%2Fhow-to-find-out-the-sql-mi-total-amount-of-ram%2Fba-p%2F2596376%22%20target%3D%22_self%22%3ERAM%3C%2FA%3E)%20parameters.%3C%2FP%3E%0A%3CP%3EIf%20you%20are%20interested%20in%20other%20posts%20on%20how-to%20discover%20different%20aspects%20of%20SQL%20MI%20-%20please%20visit%20the%20%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fsqlmi-howto%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttp%3A%2F%2Faka.ms%2Fsqlmi-howto%3C%2FA%3E%2C%20which%20serves%20as%20a%20place%20holder%20for%20the%20series.%20%3CBR%20%2F%3EAs%20indicated%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-sql%2Fhow-to-find-out-the-sql-mi-total-amount-of-ram%2Fba-p%2F2596376%22%20target%3D%22_self%22%3Eprevious%20post%3C%2FA%3E%2C%20in%20this%20how-to%20post%20we%20shall%20dive%20into%20the%20reserved%20and%20available%20disk%20spaces%20for%20the%20SQL%20MI.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere%20are%20a%20couple%20of%20important%20aspects%20related%20to%20the%20disk%20reserved%20%26amp%3B%20used%20space%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EThe%20total%20reserved%20disk%20space.%20This%20parameter%20is%20controlled%20outside%20of%20the%20SQL%20Managed%20Instance%20running%20environment%2C%20with%20the%20help%20of%20the%20Azure%20Portal%20or%20any%20of%20the%20supported%20command%20interfaces%2C%20such%20as%20CLI%20%26amp%3B%20PowerShell%2C%20but%20the%20reserved%20values%20and%20used%20values%20can%20be%20observed%20with%20the%20help%20of%20T-SQL.%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3EThe%20total%20available%20and%20used%20space%20for%20the%20local%20SSD%20drives%20on%20General%20Purpose%20service%20tier%20of%20SQL%20MI%2C%20which%20is%20not%20included%20into%20the%20previous%20parameter.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CH3%20id%3D%22toc-hId-2115157040%22%20id%3D%22toc-hId-2115157074%22%3ETotal%20Reserved%20%26amp%3B%20Used%20Disk%20Space%3C%2FH3%3E%0A%3CP%3EThe%20total%20amount%20of%20reserved%20disk%20space%20means%20the%20total%20addressable%20space%20for%20data%20and%20log%20files%20that%20SQL%20MI%20can%20use.%20For%20the%20General%20Purpose%20(GP)%20service%20tier%2C%20the%20amount%20of%20space%20that%20is%20available%20for%20the%20TempDB%20is%20different%2C%20because%20it%20is%20not%20included%20in%20the%20total%20%E2%80%93%20giving%20you%20potentially%20an%20extra%20couple%20of%20hundreds%20of%20GBs%20of%20local%20SSD%20storage%20(the%20exact%20number%20will%20depend%20on%20selected%20configuration%20and%20the%20hardware%20generation).%3C%2FP%3E%0A%3CP%3EThe%20information%20about%20the%20total%20reserved%20space%20can%20be%20found%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fsystem-catalog-views%2Fsys-server-resource-stats-azure-sql-database%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Emaster.sys.server_resource_stats%3C%2FA%3E%20DMV%20(currently%20exclusive%20for%20Azure%20SQL%20DB%20%26amp%3B%20Azure%20SQL%20MI)%2C%20under%20the%20column%20%5B%3CSTRONG%3Ereserved_storage_mb%3C%2FSTRONG%3E%5D%20and%20the%20respective%20used%20amount%20of%20storage%20is%20located%20in%20the%20same%20DMV%20in%20the%20%5B%3CSTRONG%3Estorage_space_used_mb%3C%2FSTRONG%3E%5D%20column.%20As%20in%20previous%20how-to%20articles%2C%20we%20need%20to%20obtain%20the%20latest%20available%20timestamp%20by%20sorting%20descending%20on%20the%20%5B%3CSTRONG%3Eend_time%3C%2FSTRONG%3E%5D%20column%20in%20order%20to%20obtain%20the%20latest%20information%20about%20the%20space.%3CBR%20%2F%3EThe%20query%20below%20extracts%20this%20information%20together%20with%20the%20calculation%20of%20the%20overall%20used%20percentage.%20%3CBR%20%2F%3EWarning%3A%20it%20does%20not%20mean%20that%20all%20of%20the%20underlying%20space%20was%20actually%20occupied%20by%20data%2C%20it%20means%20that%20your%20database%20data%20and%20log%20files%20have%20reserved%20this%20amount%20by%20growing%20their%20respective%20size.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-sql%22%3E%3CCODE%3ESELECT%20TOP%201%20reserved_storage_mb%2C%20storage_space_used_mb%2C%20CAST(%20(storage_space_used_mb%20*%20100.%20%2F%20reserved_storage_mb)%20as%20DECIMAL(9%2C2))%20as%20%5BReservedStoragePercentage%5D%0A%20%20%20%20%20%20%20FROM%20master.sys.server_resource_stats%0A%20%20%20%20%20%20%20ORDER%20BY%20end_time%20DESC%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22NikoNeugebauer_0-1628692662020.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F302371i4F73C926F5C9A1B1%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22NikoNeugebauer_0-1628692662020.png%22%20alt%3D%22NikoNeugebauer_0-1628692662020.png%22%20%2F%3E%3C%2FSPAN%3EOn%20my%20small%20test%20SQL%20Managed%20Instance%20I%20have%20262144%20MB%20(%3CSTRONG%3E256%20GB%3C%2FSTRONG%3E)%20of%20the%20reserved%20space%20and%20I%20have%20currently%20used%20(created%20data%20%26amp%3B%20log%20files)%20that%20occupy%20261062%20MB%20(%3CSTRONG%3E254.96%20GB%3C%2FSTRONG%3E)%2C%20representing%20%3CSTRONG%3E99.59%25%3C%2FSTRONG%3E%20of%20the%20available%20reserved%20space.%26nbsp%3B%3CBR%20%2F%3EThis%20is%20one%20of%20the%20key%20monitoring%20and%20troubleshooting%20aspects%20that%20needs%20to%20be%20payed%20attention%20to.%3CBR%20%2F%3EThe%20owner%20is%20in%20the%20control%20of%20the%20reserved%20space%20and%20we%20are%20not%20automatically%20increasing%20it%2C%20since%20such%20change%20would%20represent%20a%20monetary%20impact%20on%20our%20customers%20-%20and%20such%20changes%20must%20be%20approved%20and%20executed%20by%20the%20customers.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-307702577%22%20id%3D%22toc-hId-307702611%22%3EReserved%20space%20for%20TempDB%20on%20General%20Purpose%20(GP)%20service%20tier%3A%3C%2FH3%3E%0A%3CDIV%3EA%20well%20documented%20fact%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fmanaged-instance%2Fresource-limits%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EResource%20limits%20-%20Azure%20SQL%20Managed%20Instance%20%7C%20Microsoft%20Docs%3C%2FA%3E%26nbsp%3Bis%20that%20on%20the%20General%20Purpose%20(GP)%20service%20tier%2C%20all%20storage%20for%20user%20databases%20is%20a%20remote%20one%2C%20with%20only%20%5B%3CSTRONG%3ETempDB%3C%2FSTRONG%3E%5D%20database%20being%20located%20on%20the%20fast%20local%20SSD%20for%20providing%20the%20best%20possible%20performance%20of%20the%20SQL%20MI.%20This%20space%20on%20the%20local%20SSD%20is%20not%20not%20included%20in%20the%20total%20reserved%20space%20and%20is%20not%20exposed%20in%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fsystem-catalog-views%2Fsys-server-resource-stats-azure-sql-database%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Emaster.sys.server_resource_stats%3C%2FA%3E%20DMV.%26nbsp%3B%26nbsp%3B%3CSPAN%3ELimited%20to%20%3CSTRONG%3E24%20GB%2FvCore%3C%2FSTRONG%3E%20(96%20-%201%2C920%20GB)%20and%20currently%20available%20instance%20storage%20size%2C%20this%20space%20provides%20huge%20opportunity%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FDIV%3E%0A%3CP%3EOn%20Business%20Critical%20(BC)%20service%20tier%2C%20since%20all%20storage%20is%20local%20and%20this%20is%20definitely%20not%20applicable%20-%20meaning%20that%20we%20are%20giving%20SQL%20MI%20on%20GP%20a%20kind%20of%20a%20great%20bonus.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-sql%22%3E%3CCODE%3EIF%20(%20(SELECT%20TOP%201%20SKU%0A%20%20FROM%20%5Bsys%5D.%5Bserver_resource_stats%5D%20%0A%20%20%20ORDER%20BY%20end_time%20DESC)%20%3D%20'GeneralPurpose'%20)%0ABEGIN%0A%20SELECT%20vs.volume_mount_point%20as%20VolumeMountPoint%2C%0A%20%20%20%20%20CAST(MIN(total_bytes%20%2F%201024.%20%2F%201024%20%2F%201024)%20AS%20NUMERIC(9%2C2))%20as%20LocallyUsedGB%2C%0A%20%20%20%20%20CAST(MIN(available_bytes%20%2F%201024.%20%2F%201024%20%2F%201024)%20AS%20NUMERIC(9%2C2))%20as%20LocallyAvailableGB%2C%0A%20%20%20%20%20CAST(MIN((total_bytes%2Bavailable_bytes)%20%2F%201024.%20%2F%201024%20%2F%201024)%20AS%20NUMERIC(9%2C2))%20as%20LocallyTotalGB%0A%20FROM%20sys.master_files%20AS%20f%0A%20%20CROSS%20APPLY%20sys.dm_os_volume_stats(f.database_id%2C%20f.file_id)%20vs%0A%20WHERE%20UPPER(vs.volume_mount_point)%20like%20'C%3A%5C%25'%20%0A%20GROUP%20BY%20vs.volume_mount_point%3B%0AEND%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22NikoNeugebauer_1-1628694814578.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F302378iF8A341ADBADAF361%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22NikoNeugebauer_1-1628694814578.png%22%20alt%3D%22NikoNeugebauer_1-1628694814578.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EOn%20my%20test%20SQL%20MI%20with%20just%20%3CSTRONG%3E4%20CPU%20vCores%3C%2FSTRONG%3E%2C%20I%20have%20received%20%3CSTRONG%3E96%20GB%3C%2FSTRONG%3E%20of%20the%20local%20space%20for%20TempDB%20and%20currently%20used%20just%20around%200.19%20GB%2C%20leaving%2095.81%20GB%20still%20available.%20Keep%20in%20mind%20that%20this%20reserved%20space%20is%20applicable%20for%20the%20whole%20TempDB%20database%2C%20including%20Log%20File%2C%20which%20is%20currently%20limited%20to%20120%20GB%20at%20maximum.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EJoining%20the%20information%20about%20the%20reserved%20remote%20storage%20(256%20GB)%20and%20the%20local%20SSD%20(96%20GB)%20gives%20the%20final%20value%20of%20352%20GB%2C%20you%20can%20use%20the%20following%20query%20to%20find%20it%20out%20on%20General%20Purpose%20(GP)%20service%20tier%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-sql%22%3E%3CCODE%3ESELECT%20SUM(TotalGB)%20as%20TotalSpaceGB%0A%20FROM%20(%0A%20SELECT%20vs.volume_mount_point%20as%20VolumeMountPoint%2C%0A%20%20%20%20%20CAST(MIN(total_bytes%20%2F%201024.%20%2F%201024%20%2F%201024)%20AS%20NUMERIC(9%2C2))%20as%20UsedGB%2C%0A%20%20%20%20%20CAST(MIN(available_bytes%20%2F%201024.%20%2F%201024%20%2F%201024)%20AS%20NUMERIC(9%2C2))%20as%20AvailableGB%2C%0A%20%20%20%20%20CAST(MIN((total_bytes%2Bavailable_bytes)%20%2F%201024.%20%2F%201024%20%2F%201024)%20AS%20NUMERIC(9%2C2))%20as%20TotalGB%0A%20FROM%20sys.master_files%20AS%20f%0A%20%20CROSS%20APPLY%20sys.dm_os_volume_stats(f.database_id%2C%20f.file_id)%20vs%0A%20GROUP%20BY%20vs.volume_mount_point)%20fsrc%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22NikoNeugebauer_2-1628696500271.png%22%20style%3D%22width%3A%2088px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F302382i329F4944458EFFC8%2Fimage-dimensions%2F88x38%3Fv%3Dv2%22%20width%3D%2288%22%20height%3D%2238%22%20role%3D%22button%22%20title%3D%22NikoNeugebauer_2-1628696500271.png%22%20alt%3D%22NikoNeugebauer_2-1628696500271.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EAs%20we%20progress%20improving%20SQL%20MI%2C%20some%20of%20the%20details%20might%20change%20in%20the%20future%2C%20but%20the%20path%20for%20discovery%20with%20the%20help%20of%20T-SQL%20should%20remain%20valid.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2636930%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22NikoNeugebauer_0-1628692662020.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F302371i4F73C926F5C9A1B1%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22NikoNeugebauer_0-1628692662020.png%22%20alt%3D%22NikoNeugebauer_0-1628692662020.png%22%20%2F%3E%3C%2FSPAN%3EDiscover%20how-to%20find%20out%20the%20total%20reserved%20and%20available%20space%20on%26nbsp%3BAzure%20SQL%20Managed%20Instance%20with%20the%20help%20of%20T-SQL.%20Uncover%20the%20size%20and%20the%20potential%20of%20of%20the%20local%20SSD%20that%20is%20given%20for%20TempDB%20usage%20outside%20of%20the%20reserved%20space%20for%20General%20Purpose%20service%20tier%20on%20SQL%20MI.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2636930%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20SQL%20Managed%20Instance%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Aug 30 2021 06:51 AM
Updated by: