Other References Manufacturer information inside SQL server Himanshu Patel SQL Server Consultant developer & Administrator – How to use extended events to catch all errors in SQL Server SQL Socket & Core information Get IO warning from log Get TempDB files count How to find SQL Server Cluster information
If plan from a saved file
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 »
Get CPU Utilization History for the last 256 minutes dm_os_ring_buffers
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
OR dm_os_enumerate_fixed_drives
Returns information about the current resource pool state dm_resource_governor_resource_pools
Get information on the location, time, and size of any memory dumps from SQL Server dm_server_memory_dumps
Get System Manufacturer and model number from SQL Server Error log This query will return no results if your error log has been recycled since the instance was started Can also be used to confirm if you are running in a VM Read specific errors using temp table Himanshu Patel SQL Server Consultant developer & …
Scalar UDF Inlining, sql_modules
