You are a professional level SQL Sever 2008 Database Administrator. After a regular test, you find that performance degradation is experienced by an instance for the three reasons: Excessive CPU…

Question

Options

• ATo finish the task, you should utilize Resource Governor.
• BTo finish the task, you should utilize Database Engine Tuning Advisor.
• CTo finish the task, you should utilize Extended Events.
• DTo finish the task, you should utilize Performance Monitor (SYSMON).

• A
  4% (1)
• B
  11% (3)
• C
  78% (21)
• D
  7% (2)

Explanation

Introducing SQL Server Extended Events SOL Server Extended Events (Extended Events} is a general event-handling system for server systems. The Extended Events infrastructure supports the correlation of data from SOL Server, and under certain conditions, the correlation of data from the operating system and database applications. In the latter case, Extended Events output must be directed to Event Tracing for Windows (ETW) in order to correlate the event data with operating system or application event data. All applications have execution points that are useful both inside and outside an application. Inside the application, asynchronous processing may be enqueued using information that is gathered during the initial execution of a task. Outside the application, execution points provide monitoring utilities with information about the behavioral and performance characteristics of the monitored application. Extended Events supports using event data outside a process, This Etta is typically used - Tracing tools, such as SOL Trace and System Monitor. - Logging tools, such as the Windows event log or the SOL Server error - Users administering a product or developing applications on a

No community discussion yet for this question.