O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Monitoring resource usage with Extended Events

The performance monitoring process requires an event handling system in addition to existing tools such as PERFMON, SQL Profiler, and DMVs. The design and testing of an application system will always have unanticipated problems that require extensive troubleshooting techniques. To avoid any sort of interruption to the performance monitoring, an event-handling system for the server is essential. SQL Server 2008 addresses this situation by providing Extended Events (XE). The XE infrastructure is a lightweight mechanism that supports capturing, filtering, and action on events generated by the server process.

The process of events and data are managed by the internal objects and it is ideal to mention ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required