Question

Which of the following requires VIEW SERVER STATE permission on the server?

(a) sys.dm_os_states

(b) sys.dm_os_wait_stats

(c) sys.dm_os_wait_states

(d) none of the mentioned

This question was addressed to me at a job interview.

I would like to ask this question from Wait States in section Monitoring and Auditing of SQL Server

Answer 1

The correct option is (b) sys.dm_os_wait_stats

For explanation I would say: sys.dm_os_wait_stats returns information about all the waits encountered by threads that executed.