Answer:
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