DRAG DROP
You administer a Microsoft SQL Server database that is used by an application.
Users of the application report performance issues.
You need to choose the appropriate tool for performance-tuning of SQL Server databases.
Which tool or tools should you use? (To answer, drag the appropriate tool or tools to their
corresponding task or tasks in the answer are
A.
Each tool may be used once, more than once, or not at all. You may need to drag the split bar
between panes or scroll to view content.)
Explanation:
http://msdn.microsoft.com/enus/library/bb630282.aspx
http://msdn.microsoft.com/enus/library/ms191246.aspxhttp://msdn.microsoft.com/en-us/library/ms181091.aspx
SYSTEM MONITOR
SQL PROFILER
XEVENTS
XEVENTS
Renata’s answer is correct
System monitor (https://msdn.microsoft.com/en-us/library/ms175166(v=sql.110).aspx)
Sql Profiler (https://msdn.microsoft.com/en-us/library/ms189604(v=sql.110).aspx)
XEvents
I missed one more XEvents
Alex
I missed the last one, but when I think again
Renata’s replay is correct