You administer a Microsoft SQL

Server 2012 database named Contoso on a server named Server01.

You need to collect data for a long period of time to troubleshoot wait statistics when querying Contoso. You also need to ensure minimum impact to the server.

What should you create?

A. An Alert

B. A Resource Pool

C. An Extended Event session

D. A Server Audit Specification

E. A SQL Profiler Trace

F. A Database Audit Specification

G. A Policy

H. A Data Collector Set

Explanation:

SQL Server Extended Events has a highly scalable and highly configurable architecture that allows users to collect as much or as little information as is necessary to troubleshoot or identify a performance problem.

Extended Events is a light weight performance monitoring system that uses very few performance resources.

A SQL Server Extended Events session is created in the SQL Server process hosting the Extended Events engine.

References: https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/extended-events