Get your server hardware information via DM_OS_SYS_INFO in SQL Server 2005/2008/Denali

DMV(Dynamic Management View) is very powerful tool given my Microsoft in SQLServer 2005+ version; you can get much crucial information from it. Today I amgoing to show you “sys.dm_os_sys_info” which will reveal some of the hardwareinformation of the server which you are using for your SQL Server instance. 
SELECT
      cpu_count asTotal_Logical_CPU_In_Server
      ,HyperThread_Ratio
      ,cpu_count/HyperThread_Ratio asphysical_CPU_In_Server
      –converting bytes of physical memoryto MB
      ,(physical_memory_in_bytes/1024)/1024 as Total_Memory_Of_Server_In_MB
      ,(Virtual_memory_in_bytes/1024)/1024 as Current_Usage_Of_Memory_SQLServer_In_MB
      –following fields will work only inSQL Server 2008+
      –if you are using SQL Server 2005,comment following field.
      ,sqlserver_start_time
     
FROM
      sys.dm_os_sys_info
Reference: Ritesh Shah

http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles butexamples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com
Ask me any SQL Server related question at my “ASK Profile
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: