You are a professional level SQL Sever 2008 Database Administrator. It is reported by the customers that the server performance degraded due to a newly implemented process. Dynamic Management Views…

Question

Options

• ATo finish the task, Data Collector should be utilized.
• BTo finish the task, the SQLdiag.exe utility should be utilized.
• CTo finish the task, SQL Server Profiler and the tracerpt.exe utility should be utilized.
• DTo finish the task, SQL Server Profiler and System Monitor should be utilized.

• A
  5% (1)
• B
  5% (1)
• C
  10% (2)
• D
  80% (16)

Explanation

SOL Server profiler displays data about a large number of SOL Server events. Whereas Windows System Monitor graphically displays information about the server internals. You can merge the two sets of information and walk through a scenario viewing both perspectives using SQL Server Profiler. To set up the dual-perspective experience, you need to simultaneously capture server performance using both Performance Monitor's Counter Logs and SOL Server Profiler. The steps to do this are listed below: 1. Configure System Monitor with the exact counters you want to view later. Be sure to get the scale and everything just right. Set up the Counter Log to the exact same configuration. 2. Configure Profiler with the right set of trace events. They must include the start and end time data columns so that Profiler can integrate the two logs later. Save the profiler and close profiler. 3. Manually start the Counter Log. Open SOL Profiler trace code to start the server--side trace. 4. When the test is complete, stop both the counter Log and the server side trace. You need to stop the SQL Profiler which is a negative point in this. 5. Open profiler and open the saved trace file. 6. Use the Files> Import Performance Data menu command to import the Counter Log. You have the option of selecting only the important counters from the performance monitor. There will be performance issues if you select too many counters. performance.com/faq/How_to_Integrate_Performance_Monitor_and_SOL_Profiler_p1.aspx

No community discussion yet for this question.