PrepAway - Latest Free Exam Questions & Answers

You administer a Microsoft SQL Server 2012 database name…

You administer a Microsoft SQL Server 2012 database name

d 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