• Jayanth_Kurup (10/2/2012)


    Keep in mind that you could end up getting much more information than you actually need so its usually better to stick with a Server side trace or DMV if your only interested in troubleshooting or basic monitoring.

    For the exact same events in SQL Trace, you will get the same amount of events generated, so using a server-side Trace won't make a difference. This is why you have the ability to create complex predicates in Extended Events to filter the events at the firing point, and reduce the performance impact that diagnostic data collection has on the server, which is not possible for server-side trace, where the filter is applied at the Trace level across all of the events, and only after the event has fired and collected all of the events data.

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]