Read Windows Registry from SQL server

EXEC sys.xp_instance_regread N'HKEY_LOCAL_MACHINE'
, N'SYSTEM\CurrentControlSet\services\pvscsi\Parameters\Device'
, N'DriverParameter';

Recommended value for intensive I/O patterns from VMware is: RequestRingPages=32,MaxQueueDepth=254

https://kb.vmware.com/s/article/2053145

-- Get BIOS date from Windows Registry
EXEC sys.xp_instance_regread N'HKEY_LOCAL_MACHINE'
, N'HARDWARE\DESCRIPTION\System\BIOS'
, N'BiosReleaseDate';

Get processor description from Windows Registry 
EXEC sys.xp_instance_regread N'HKEY_LOCAL_MACHINE'
, N'HARDWARE\DESCRIPTION\System\CentralProcessor\0'
, N'ProcessorNameString';

https://www.sqlskills.com/blogs/glenn/processor-selection-for-sql-server/

https://www.cpuid.com/softwares/cpu-z.html