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 area.
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/en-us/library/bb630282.aspx
http://msdn.microsoft.com/en-us/library/ms191246.aspx
http://msdn.microsoft.com/en-us/library/ms181091.aspx
I would choose system monitor for Generating Alerts. Am i wrong?
I am definitely not 🙂
So for Generating Alerts it should be System Monitor?
dennis is right !
* system monitor (perfmon) is able to perform Alerts
* SQL profiler is NOT able !
@see http://www.mssqltips.com/sqlservertip/1067/sql-server-performance-monitoring-tools/
Dennis you are awesome.
system monitor can be used to generate alerts.
https://msdn.microsoft.com/en-us/library/ms175166.aspx
I drop my question here, but can someone confirm that there 461 questions at the 462 exam? About inner joins and views …?