Thursday, October 28, 2010

An Overview of Extended Events in SQL Server 2008

As a DBA, we are faced with performance problems which we need to diagnose, trace and troubleshoot. Although there are several different tracing and troubleshooting mechanisms (DBCC, SQL Trace, Profiler, etc...) available but none of these tools provide deep levels of tracing/troubleshooting, like identifying page splits, high CPU utilization, etc... So how can we diagnose, trace and troubleshoot these kinds of performance problems in SQL Server 2008. In this tip I talk about Extended Events of SQL Server 2008 and how it is different from earlier tracing and troubleshooting methods, for more details click here.

No comments:

Post a Comment