![]() If objname is omitted, the value of oneresultset is 1, and include_total_xtp_storage is 1, the following single result set is returned to provide current database size information. This is the disk space used for checkpoint files that are awaiting cleanup, once log truncation happens. Total size of checkpoint files with state WAITING_FOR_LOG_TRUNCATION, in KB. This is the disk space actively used for data in memory-optimized tables. Total size of checkpoint files with states UNDER CONSTRUCTION, ACTIVE, and MERGE TARGET, in KB. Counts towards the unallocated space in the database as a whole. Total size of checkpoint files with state PRECREATED, in KB. The following result set is returned ONLY IF the database has a MEMORY_OPTIMIZED_DATA filegroup with at least one container: Column name Space used by tables in the database: (this resultset does not reflect memory-optimized tables, as there is no per-table accounting of disk usage) Column name If the database has a MEMORY_OPTIMIZED_DATA filegroup, this includes the total on-disk size of the checkpoint files with state PRECREATED in the filegroup. Space in the database that has not been reserved for database objects. If the database has a MEMORY_OPTIMIZED_DATA filegroup, this includes the total on-disk size of all checkpoint files in the filegroup. database_size includes both data and log files. Size of the current database in megabytes. The following result sets are returned detailing on-disk database size information. This is the default mode, when no parameters are specified. Total amount of space reserved for objname but not yet used. Total amount of space used by indexes in objname. Total amount of space used by data in objname. ![]() Total amount of reserved space for objname. If the object specified is a Service Broker queue, this column indicates the number of messages in the queue. If the schema name is required, use the sys.dm_db_partition_stats or sys.dm_db_index_physical_stats dynamic management views to obtain equivalent size information. The schema name of the object is not returned. Name of the object for which space usage information was requested. If objname is specified, the following result set is returned for the specified object. If objname is omitted and the value of oneresultset is 1, the following single result set is returned to provide current database size information. Total amount of space reserved for objects in the database, but not yet used. Total amount of space allocated by objects in the database. If objname is omitted and the value of oneresultset is 0, the following result sets are returned to provide current database size information. The default value is 0, that is, by default (if the parameter is omitted) the XTP columns are not included in the resultset. When the parameter determines whether the single resultset includes columns for MEMORY_OPTIMIZED_DATA storage. [ 'include_total_xtp_storage' Applies to: SQL Server 2017 (14.x), SQL Database. Oneresultset is bit, with a default of 0. When = null or is not specified, a single result set is returned. When is null or is not specified, two result sets are returned. The oneresultset argument can have the following values: Value Indicates whether to return a single result set. Mode is varchar(11), with a default of N'ALL'. The provisioning of the remote data archive returned a status of Success, but in fact it failed. The user has manually dropped the remote table. In this case, the remote table does not yet have a schema. The table is enabled for Stretch, but you have never enabled data migration. This option raises an error when one of the following conditions is true: Returns the storage statistics of only the remote portion of the object or database. If the object or database is not Stretch-enabled, returns the same statistics as when = ALL. Returns the storage statistics of only the local portion of the object or database. Returns the storage statistics of the object or database including both the local portion and the remote portion. The mode argument can have the following values: Value Avoid using this feature in new development work, and plan to modify applications that currently use this feature. This feature will be removed in a future version of Microsoft SQL Server. ![]() Stretch Database is deprecated in SQL Server 2022 (16.x).
0 Comments
Leave a Reply. |