Valid 70-764 Dumps shared by PrepAwayExam.com for Helping Passing 70-764 Exam! PrepAwayExam.com now offer the newest 70-764 exam dumps, the PrepAwayExam.com 70-764 exam questions have been updated and answers have been corrected get the newest PrepAwayExam.com 70-764 dumps with Test Engine here:
You have a query that is used by a reporting dashboard. Users report that the query sometimes takes a long time to run. You need to recommend a solution to identify what is causing the issue. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.
Correct Answer: B
Explanation/Reference: Explanation: Step 1: Turn on the blocked process report. This will look for any blocking taking 20 seconds or longer. - Make sure you don't have any pending changes
Step 2: Set up a trace to capture the blocked process report. Run it as a server side trace.