Home Forums SQL Server 2014 Administration - SQL Server 2014 Replayable Extended Events? RE: Replayable Extended Events?

  • January 3, 2018 at 8:46 pm

    #1974388

    SQL Guy 1 - Wednesday, January 3, 2018 11:43 AM

    TheSQLGuru: that sounds encouraging. The only reason why our managers don't want to run trace (not Profiler but script-based tracing) is that it has greater impact than X.E. and can hamper production performance.

    B.T.W., while I was reading your post I thought that you are going to retire in 17 years from now.🙂

    GilaMonster: tried to google it but unfortunately could not find anything like that.

    I have run traces to local disk on multiple systems with many thousands of SQL batches per second with VERY little overhead. Most benchmarks I have seen do stupid tracing, including collecting numerous BLOATED fields. My profiler trace has just 9 fields. TextData is the only bloated one, but that's the queries so you got to have it. There is one datetime, and the rest are various numeric types. 

    I love what I do too much to retire I think. 😀

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service