Session Details -
Eventing in SQL Server 2008
|
|
SQL Server has always had the ability and tools to monitor server state and diagnose issues inside SQL Server (for example, SQL Trace and performance monitors). SQL 2005 introduced the ability to use the tracing capabilities within the operating system—Event Tracing for Windows (ETW). SQL Server 2008 builds upon this with Extended Events (EE), a general event-handling infrastructure. Extended Events is by far the most flexible and efficient event engine available within SQL Server. We look at the architecture of EE, the various components that EE introduces and also how we can use EE together with ETW to correlate event data from inside SQL Server with data from the operating system.
|
|
|
Niels Berglund
|
|
|
|
Niels Berglund is a member of DevelopMentor's technical research, curriculum development and teaching staff. He specializes in the .NET system software and database areas, and is author of DevelopMentors database courses.
Niels speaks regularly at various industry conferences. He writes technical articles for the trade press and is co-author of the first book released for SQL Server 2005; "A First Look at SQL Server 2005 for Developers".
Before joining DevelopMentor Niels worked as a consultant, specializing in design and development of distributed applications to mainly the financial industry.
|