PrepAway - Latest Free Exam Questions & Answers

You need to examine information about logins, CPU times…

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?

PrepAway - Latest Free Exam Questions & Answers

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

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
https://technet.microsoft.com/en-us/library/cc879320(v=sql.105).aspx

3 Comments on “You need to examine information about logins, CPU times…

  1. Caspar says:

    Ok but can sp_who3 also show information about Disk I/O? I can’t find any information about that. But Disk I/O is mentined in the question.
    Indeed it seems that Activity Monitor is not supported for Azure. Perhaps Azure Monitor is meant in the answer.




    0



    0

Leave a Reply