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
C
C
https://books.google.ca/books?id=gQfXAwAAQBAJ&pg=PA553&dq=extended+event+session+sql+wait+statistics&hl=en&sa=X&redir_esc=y#v=onepage&q&f=false