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
Answer:A
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
Explanation:sys.dm_os_wait_stats returns information about all the waits encountered by threads that executed. 2. Point out the correct statement :