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 & …
Recommended value for intensive I/O patterns from VMware is: RequestRingPages=32,MaxQueueDepth=254 https://kb.vmware.com/s/article/2053145 https://www.sqlskills.com/blogs/glenn/processor-selection-for-sql-server/ https://www.cpuid.com/softwares/cpu-z.html
Microsoft help
Gives you some useful information about the composition and relative load on your NUMA nodes Check an equal number of schedulers on each NUMA node Check on a physical or virtual machine with more than four sockets or more than 24 physical cores Microsoft help Other Link https://www.sqlskills.com/blogs/glenn/balancing-your-available-sql-server-core-licenses-evenly-across-numa-nodes/
Microsoft Help
Returns information about the operating system volume (directory) on which the specified databases and files are stored in SQL Server. Use this dynamic management function to check the attributes of the physical disk drive or return available free space information about the directory. sys.dm_os_volume_stats (Transact-SQL)
