December 2021

Get tempdb version store space usage by database

DB Information / By / /

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. Get TempDB files count Himanshu Patel SQL Server Consultant developer & …

Get tempdb version store space usage by database Read More »

Hardware information from SQL Server

Server Informantion / By /

Gives you some good basic hardware information about your database server Virtual_machine_type_desc of HYPERVISOR does not automatically mean you are running SQL Server inside of a VM. It merely indicates that you have a hypervisor running on your host Soft-NUMA (SQL Server) sys.dm_os_sys_info 

Himanshu Patel SQL server database auditing
db tool - Copy

auxiliary.it.india@gmail.com

Skype @hapatel76

Facebook-f Twitter Linkedin Stack-overflow