What should you use?

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is

independent of the other questions in this series. Information and details provided in a question apply only to that question.

You need to examine information about logins, CPU times, and Disk I/O on a particular database in Microsoft Azure.

What should you use?
A . Activity Monitor
B . Sp_who3
C . SQL Server Management Studio (SSMS) Object Explorer
D . SQL Server Data Collector
E . SQL Server Data Tools (SSDT)
F . SQL Server Configuration Manager

View Answer

Answer: A

Explanation:

Activity Monitor displays information about SQL Server processes and how these processes affect the current instance of SQL Server. Activity Monitor is a tabbed document window with the following expandable and collapsible panes: Overview, Active User Tasks, Resource Waits, Data File I/O, and Recent Expensive Queries.

The Activity User Tasks Pane shows information for active user connections to the instance, including the following column:

* Login: The SQL Server login name under which the session is currently executing. The Recent Expensive Queries Pane shows information about the most expensive queries that have been run on the instance over the last 30 seconds, including the following column:

* CPU (ms/sec): The rate of CPU use by the query

References: https://technet.microsoft.com/en-us/library/cc879320(v=sql.105).aspx