Valid 70-462 Dumps shared by ExamDiscuss.com for Helping Passing 70-462 Exam! ExamDiscuss.com now offer the newest 70-462 exam dumps, the ExamDiscuss.com 70-462 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-462 dumps with Test Engine here:
You administer a Microsoft SQL Server 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?
Correct Answer: D
Explanation/Reference: Explanation: The Blocked Process Report event class indicates that a task has been blocked for more than a specified amount of time. This event class does not include system tasks or tasks that are waiting on non deadlock- detectable resources. To configure the threshold and frequency at which reports are generated, use the sp_configure command to configure the blocked process threshold option, which can be set in seconds. By default, no blocked process reports are produced. References: https://docs.microsoft.com/en-us/sql/relational-databases/event-classes/blocked-process- report-event-class?view=sql-server-2017