What permissions must a user have in order to view data in Activity Monitor?  What happens if the user runs the tool but lacks sufficient permissions?

What will be an ideal response?


To view data in Activity Monitor, a user must either be a system administrator on the SQL Server instance or be granted the VIEW SERVER STATE server-level permission. If a user lacks permission, he or she will still be able to launch the tool but the text  "No Data" will display in red in each section.

Computer Science & Information Technology

You might also like to view...

In Excel 2010, there is really no way to tell what a print-out will look like until you print it

Indicate whether the statement is true or false

Computer Science & Information Technology

To select an entire document ____.

A. double-click it B. triple-click it C. press [Ctrl] [A] D. press [Ctrl] [S]

Computer Science & Information Technology

The FIRST step in planning a macro is to record it.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

?System documentation always is up-to-date.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology