nerdexam
Microsoft

70-473 · Question #114

You have a Microsoft Azure SQL database. Users report that queries to the database take longer than expected to complete. You need to identify the amount of CPU resources that the database used…

The correct answer is B. Query the sys.dm_os_performance_counters dynamic management view. To identify the amount of CPU resources used by an Azure SQL database, querying sys.dm_os_performance_counters provides access to granular, real-time CPU performance metrics from the database engine.

Monitor and manage an Azure data platform solution

Question

You have a Microsoft Azure SQL database. Users report that queries to the database take longer than expected to complete. You need to identify the amount of CPU resources that the database used during the last week. What should you do?

Options

  • AUse the Azure portal to view the monitoring details of the Azure SQL database.
  • BQuery the sys.dm_os_performance_counters dynamic management view.
  • CReview the performance metrics by using Microsoft System Center.
  • DUse Performance Monitor to connect to the Azure SQL database.

How the community answered

(28 responses)
  • A
    4% (1)
  • B
    86% (24)
  • C
    7% (2)
  • D
    4% (1)

Why each option

To identify the amount of CPU resources used by an Azure SQL database, querying `sys.dm_os_performance_counters` provides access to granular, real-time CPU performance metrics from the database engine.

AUse the Azure portal to view the monitoring details of the Azure SQL database.

While the Azure portal provides a user-friendly interface to view historical CPU usage trends, the question implies a more direct method of identifying the underlying resource usage, which is done by querying the database engine's performance counters. The portal itself relies on collecting these metrics from the database.

BQuery the sys.dm_os_performance_counters dynamic management view.Correct

The `sys.dm_os_performance_counters` dynamic management view exposes real-time performance counters within the SQL Server engine, including various metrics for CPU usage. While it provides current values, these counters are the foundational data points that must be collected and aggregated over time to analyze CPU resource consumption trends, such as usage over the last week.

CReview the performance metrics by using Microsoft System Center.

Microsoft System Center is a suite of management products, not a direct tool for querying an Azure SQL database's performance metrics; it would rely on agents or connectors that, in turn, query DMVs or Azure Monitor.

DUse Performance Monitor to connect to the Azure SQL database.

Performance Monitor (Perfmon) is a Windows-based tool primarily for monitoring local or remote Windows servers and cannot directly connect to and monitor an Azure SQL database, which is a platform-as-a-service offering.

Concept tested: Azure SQL Database performance counter monitoring

Source: https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-performance-counters-transact-sql

Topics

#Azure SQL Database#performance monitoring#CPU utilization#DMVs

Community Discussion

No community discussion yet for this question.

Full 70-473 Practice