DRAG AND DROP
You administer a Microsoft SQL Server database thatis 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.)
Select and Place:
Answer:
Explanation:
Verified answer as correct.
Reference: http://msdn.microsoft.com/en-us/library/bb630282.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms191246.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms181091.aspx
Generating Alerts with SQL Server Profiler is not possible.
You have to use the Windows System Monitor.
The Windows System monitor is also known as perfmon –
http://msdn.microsoft.com/en-us/library/ms187522.aspx)
How to send an alert by perfmon is described here:
http://blog.jamesrossiter.co.uk/2011/02/23/send-email-alerts-for-low-disk-space-using-perfmon-exe-in-windows-using-bmail-exe/
Testee is Correct – Generating Alerts = Windows System Monitor.
System Monitor replaced PerfMon after WindowsNT 4.0.
We use System Monitor to monitor the utilization of system resources. Collect and view real-time performance data in the form of counters, for server resources such as processor and memory use, and for many Microsoft SQL Server resources such as locks and transactions. It can also be used to:
**Export data from charts, logs, alert logs, and reports to spreadsheet or database applications for further manipulation and printing
**Add system alerts that list an event in the alert log and can notify you by issuing a network alert.
To start System Monitor in Windows: On the Start menu, point to Run, type perfmon in the Run dialog box, and then click OK.