You administer a Microsoft SQL Server 2016 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