SQL Server 2008: Advanced Troubleshooting with Extended Events

"SQL Server DBAs the world over have a problem that never seems to go away: troubleshooting—with the vast majority of troubleshooting being done to find a performance problem of some kind."

 

In the January 2009 issue of TechNet Magazine , which is now available online, Paul Randal looks at the new “eventing” mechanism, called SQL Server Extended Events, in SQL Server 2008. Paul explains how you can use Extended Events for monitoring and to perform some sophisticated troubleshooting.