Developing SQL Databases — Question 157

You are experiencing performance issues with the database server.
You need to evaluate schema locking issues, plan cache memory pressure points, and backup I/O problems.
What should you create?

Answer options

• 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

Creating an Extended Events session that uses Query Editor allows for detailed monitoring and analysis of various database events, including schema locking and plan cache issues. The other options, while useful for monitoring, do not provide the same level of targeted analysis for the specific performance issues mentioned.