You need to gather more data to be able to determine which processes are being blocked and to identify the root cause

You administer a Microsoft SQL Server 2012 database named Orders.
Users report that during peak usage periods, certain operations are taking more time than expected.
Your initial analysis suggests that blocking is the cause.
You need to gather more data to be able to determine which processes are being blocked and to
identify the root cause.
What should you do?

You administer a Microsoft SQL Server 2012 database named Orders.
Users report that during peak usage periods, certain operations are taking more time than expected.
Your initial analysis suggests that blocking is the cause.
You need to gather more data to be able to determine which processes are being blocked and to
identify the root cause.
What should you do?

A.
Schedule A SQL Agent job to run every 60 Seconds and insert the results of executing the
SP_who2 stored procedure table

B.
Use System Monitor to catch the Lock Wait Time event

C.
Use Sp_Configure to set the blocked process threshold. Start a Trace using SQL Server Profiler to
catch the Blocking Pro-Report event.

D.
Start a Trace using SQL Server Profiler to catch the Lock: Timeout event



Leave a Reply 2

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