What is the purpose of sys.dm_os_sys_info?

 Posted by Niladri.Biswas on 7/26/2012 | Category: Sql Server Interview questions | Views: 1221 | Points: 40

This DMV returns the information about the SQL Server machine, available resources and the resource consumption.It also provides information like
a) CPU Count: Number of logical CPUs in the server
b) Hyperthread-ratio: Ratio of logical and physical CPUs
c) Physical_memory_in_bytes: Amount of physical memory available
d) Virtual_memory_in_bytes: Amount of virtual memory available
e) Bpool_commited: Committed physical memory in buffer pool
f) OS_Priority_class: Priority class for SQL Server process
g) Max_workers_thread: Maximum number of workers which can be created

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response