Which action should you take?

You are a database developer for a large automobile manufacturer. Users accessing a large partitioned table in the Prod database complain that their queries take a long time to complete.
You run a SQL Server Profiler trace including the Lock:Escalation event, and notice that an excessive number lock escalations are occurring for the table. You would like to force SQL Server to take partition-level locks when possible to see if this improves query response time.
Which action should you take?
A. Set the READ_COMMITTED_SNAPSHOT database option to OFF.
B. Use sp_configure to set the locks option to a lower value.
C. Use trace flag 1211 to configure lock escalation.
D. Issue an ALTER TABLE statement to set the table’s LOCK_ESCALATION to AUTO.

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.