Home » Microsoft » 70-762 » What should you create
You are experiencing performance issues with the database server.
You need to evaluate schema locking issues, plan cache memory pressure points, and backup IO problems.
What should you create
A. a System Monitor report
B. a sys.dm_tran_database_transaction dynamic management view query
C. an Extended Events session that uses Query Editor
D. a Microsoft SQL Profiler trace
Correct Answer: C
Explanation/Reference:
Reference
Extended Events considered as the best way by the SQL Server purists. You can configure Extended Events to find Locking Issues in SQL Server.
Incorrect Answers
D SQL Trace and SQL Server Profiler are deprecated. The Microsoft.SqlServer.Management.Trace namespace that contains the Microsoft SQL Server Trace and Replay objects are also deprecated.
This feature is in maintenance mode and may be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Use Extended Events instead.
References
httpswww.mssqltips.comsqlservertip5752configuring-extended-events-to-find-locking-issues-in-sql-server