Skip to content

Commit 5bd6f43

Browse files
authored
Merge pull request #4954 from pmasl/patch-170
Update sys-dm-tran-version-store-space-usage.md
2 parents 28e9e1a + 52e537d commit 5bd6f43

1 file changed

Lines changed: 3 additions & 3 deletions

File tree

docs/relational-databases/system-dynamic-management-views/sys-dm-tran-version-store-space-usage.md

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -31,9 +31,9 @@ ms.workload: "Inactive"
3131
# sys.dm_tran_version_store_space_usage (Transact-SQL)
3232
[!INCLUDE[tsql-appliesto-ss2017-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2017-xxxx-xxxx-xxx-md.md)]
3333

34-
Returns a table that displays total space in tempdb used by version store records for each database. **sys.dm_tran_version_store_space_usage** is efficient and performant to run as it doesnt navigate through individual version store records and returns aggregated version store space consumed in tempdb per database.
34+
Returns a table that displays total space in tempdb used by version store records for each database. **sys.dm_tran_version_store_space_usage** is efficient and not expensive to run, as it does not navigate through individual version store records, and returns aggregated version store space consumed in tempdb per database.
3535

36-
Each versioned record is stored as binary data together with some tracking or status information. Similar to records in database tables, version-store records are stored in 8192-byte pages. If a record exceeds 8192 bytes, the record will be split across two different records.
36+
Each versioned record is stored as binary data, together with some tracking or status information. Similar to records in database tables, version-store records are stored in 8192-byte pages. If a record exceeds 8192 bytes, the record will be split across two different records.
3737

3838
Because the versioned record is stored as binary, there are no problems with different collations from different databases. Use **sys.dm_tran_version_store_space_usage** to monitor and plan tempdb size based on the version store space usage of databases in a SQL Server instance.
3939

@@ -47,7 +47,7 @@ Because the versioned record is stored as binary, there are no problems with dif
4747
On [!INCLUDE[ssNoVersion_md](../../includes/ssnoversion-md.md)], requires `VIEW SERVER STATE` permission.
4848

4949
## Examples
50-
The following query can be used to determine space consumed in tempdb by version store of each database in a SQL Server instance.
50+
The following query can be used to determine space consumed in tempdb, by version store of each database in a [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] instance.
5151

5252
```sql
5353
SELECT

0 commit comments

Comments
 (0)