Developing SQL Databases — Question 85

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. an Activity Monitor session in Microsoft SQL Management Studio.

Correct answer: D

Explanation

Creating an Activity Monitor session in Microsoft SQL Management Studio provides real-time insights into the performance of the database, including locking issues and memory pressure. The other options, while useful for specific tasks, do not offer the comprehensive overview needed to evaluate all the mentioned performance aspects effectively.