Version Store Space Usage in Tempdb(sys.dm_tran_version_store_space_usage)

Version Store Space Usage in Tempdb(sys.dm_tran_version_store_space_usage)

With SQL Server 2017, a new dmv named sys.dm_tran_version_store_space_usage was announced to find out which database uses how much space due to row versioning in tempdb.

Especially if you are using Read Committed Snapshot (RCSI) or SNAPSHOT Isolation levels, this dmw will help you a lot to manage the size of temdb.

You can query as follows.

dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply