86.3k views
0 votes
You have to examine information about CPU times, logins, and Disk I/O on a particular database in Microsoft Azure. What should you use?

A. SSDT
B. SSMS Object Explorer
C. SQL Server Data Collector
D. Activity Monitor

User Spoonraker
by
7.0k points

1 Answer

3 votes

Final answer:

To examine CPU times, logins, and Disk I/O on a database in Azure, use the Activity Monitor within SSMS. This tool provides real-time system metrics vital for database monitoring and troubleshooting.

Step-by-step explanation:

If you need to examine information about CPU times, logins, and Disk I/O on a particular database in Microsoft Azure, you should use the Activity Monitor in SQL Server Management Studio (SSMS).

Activity Monitor provides a comprehensive overview of various system metrics in real-time, enabling database administrators to view current, past, and cumulative activity on the SQL Server. Through Activity Monitor, you can observe processes, resource waits, data file I/O, and recent expensive queries, which would be crucial for performance monitoring and troubleshooting. Option B (SSMS Object Explorer) allows you to view and manage objects in your SQL Server, whereas option A (SSDT) is a tool to develop SQL Server relational databases in a visual studio environment. Option C (SQL Server Data Collector) is more for collecting data for monitoring and tuning purposes but not specifically focused on the real-time observation as is provided by Activity Monitor.

User Ashely
by
8.0k points