ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam
Go to Exam

Exam 70-764 topic 1 question 254 discussion

Actual exam question from Microsoft's 70-764
Question #: 254
Topic #: 1
[All 70-764 Questions]

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.

  • A. Set the blocked process threshold, and then run SQL Server Profiler.
  • B. Set the blocked process threshold, and then create an alert.
  • C. Enable trace flag 1204, and then create an alert.
  • D. Create a job that queries the sys.dm_os_waiting_tasks dynamic management view.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
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.
by msamm at Oct. 12, 2019, 4 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
msamm
Highly Voted 5 years, 9 months ago
The correct answer is A - Blocked process Threshold and then Create SQL Profiler Trace. Even the explanation mentions that.
upvoted 10 times
Iva10
5 years, 5 months ago
Profiler is to much impact on server if it monitoring all time. Better solution is alert, so the best answer is B
upvoted 1 times
V_karag
5 years, 1 month ago
We must identify what caused the blocking. The alert can indicate the time where a blocking event happened. i thing this is possible via profiler
upvoted 2 times
...
...
...
Cococo
Most Recent 4 years, 8 months ago
Seems like A - https://www.red-gate.com/simple-talk/sql/sql-tools/how-to-identify-blocking-problems-with-sql-profiler/
upvoted 1 times
...
TheSwedishGuy
5 years, 6 months ago
Configure the Threshold for when a Process is deemed Blocked.
upvoted 1 times
...
TheSwedishGuy
5 years, 6 months ago
Blocked process threshold = Configure the consideration time for when a process is deemed to be blocked or not.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel