How to get Azure SQL database size
'There are multiple ways to achieve this and there are also some storage types you should be aware
There is a good doc about this at https://docs.microsoft.com/en-us/azure/sql-database/sql-database-file-space-management
Understanding the following storage space quantities are important for managing the file space of a database.
-
Data space used
-
The amount of space used to store database data in 8 KB pages. Generally, space used increases (decreases) on inserts (deletes). In some cases, the space used does not change on inserts or deletes depending on the amount and pattern of data involved in the operation and any fragmentation. For example, deleting one row from every data page does not necessarily decrease the space used.
-
-
Data space allocated
-
The amount of formatted file space made available for storing database data. The amount of space allocated grows automatically, but never decreases after deletes. This behavior ensures that future inserts are faster since space does not need to be reformatted.
-
-
Data space allocated but unused
-
The difference between the amount of data space allocated and data space used. This quantity represents the maximum amount of free space that can be reclaimed by shrinking database data files.
-
-
Data max size
-
The maximum amount of space that can be used for storing database data. The amount of data space allocated cannot grow beyond the data max size.'...
-
https://blogs.msdn.microsoft.com/azuresqldbsupport/2019/02/08/how-to-get-azure-sql-database-size/
Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt