What should you create?

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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *