{
  "query": "Which term refers to the built in Windows metrics used to establish a performance baseline for SQL Server?",
  "options": [
    {
      "text": "Azure Monitor Metrics",
      "explanation": "Azure Monitor Metrics are platform metrics collected by Azure for resources and services.",
      "correct": false,
      "selected": false
    },
    {
      "text": "Performance Monitor Counters",
      "explanation": "These are the Windows Performance Monitor counters that provide CPU memory disk and other subsystem metrics.",
      "correct": true,
      "selected": false
    },
    {
      "text": "Perfmon Alert Triggers",
      "explanation": "This refers to alert rules that fire when specific performance counters exceed thresholds rather than the counters themselves.",
      "correct": false,
      "selected": false
    }
  ],
  "answer": "<p>The correct answer is <b>Performance Monitor Counters</b>. These are the built in Windows metrics used to establish a performance baseline for SQL Server.</p><p>Performance Monitor counters are provided by the Windows operating system and by SQL Server as a set of performance objects and counters. You can collect counters such as processor utilization, memory usage, disk queue lengths, and SQL Server buffer and latch metrics to build a baseline and compare later performance.</p><p><i>Azure Monitor Metrics</i> is incorrect because it refers to a cloud monitoring service that captures metrics for Azure resources rather than the native Windows performance counters. Although Azure Monitor can ingest operating system metrics from virtual machines, the term does not describe the built in Windows counters themselves.</p><p><i>Perfmon Alert Triggers</i> is incorrect because alert triggers are rules that fire when counters exceed thresholds and they are not the name of the metrics used to establish a baseline. Alerts act on counters but they are not the counters themselves.</p>",
  "batch_id": "251",
  "answerCode": "2",
  "type": "multiple-choice",
  "originalQuery": "Identify the missing word(s) in the following sentence within the context of Microsoft Azure. The following [?] are a sampling of useful Windows metrics, and can allow you to capture a good baseline for a SQL Server workload: Processor(_Total)% Processor Time Paging File(_Total)% Usage PhysicalDisk(_Total)\\Avg. Disk sec/Read and Avg. Disk sec/Write System\\Processor Queue Length SQLServer: Buffer Manager\\Page life expectancy SQLServer: SQL Statistics\\Batch Requests/sec SQLServer: SQL Statistics\\SQL Compilations/sec and SQL Re-Compilations/sec",
  "originalOptions": "A. Automated Patching Reports<br/>B. Perfmon Alert Triggers<br/>C. Performance Monitor Counters<br/>D. Storage Configuration Dashboards",
  "domain": "Plan and implement data platform resources",
  "hasImage": false,
  "queryImage": "",
  "queryImages": [],
  "deprecatedReference": false,
  "deprecatedMatches": {},
  "qid": "401s",
  "tip": "<p>When a question asks about built in Windows metrics think of the <i>Performance Monitor</i> counters rather than cloud metric services.</p>",
  "references": [
    "<a href=\"https://learn.microsoft.com/en-us/sql/relational-databases/performance-monitor/performance-monitor-counters?view=sql-server-ver16\">Performance Monitor counters for SQL Server - Microsoft Learn</a>",
    "<a href=\"https://learn.microsoft.com/en-us/windows/win32/perfctrs/performance-counters\">Performance Counters - Microsoft Learn</a>",
    "<a href=\"https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/metrics-overview\">Monitor metrics in Azure Monitor - Microsoft Learn</a>",
    "<a href=\"https://learn.microsoft.com/en-us/troubleshoot/windows-server/performance/performance-monitor-alerts\">Performance Monitor alerts - Microsoft Learn</a>"
  ],
  "video_url": "https://certificationation.com/videos/azure/dp-300-database-admin-assoc/azure-the-following-sentence-within-the-exam-401.html",
  "url": "https://certificationation.com/questions/azure/dp-300-database-admin-assoc/azure-the-following-sentence-within-the-exam-401.html"
}