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.
https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/extended-events