What should you create?

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

View Answer

Answer: C