sys.dm_os_host_info vs sys.dm_os_windows_info

With the introduction of Linux support, you will be wanting to move away from sys.dm_os_windows_info and start using sys.dm_os_host_info in multi OS environments.
 
Below shows the difference between the DMVs on a Windows server:
image1
Below shows the difference between the DMVs on a Linux server: image3

Leave a Reply