1 Reply Latest reply on Mar 9, 2017 1:50 PM by jhynds

    Post MSSQL (2016) Profiler deprecation

    yutznut

      In the cited MSDN article Microsoft discusses the deprecation of the Profiler tool for MSSQL, has anyone been planning for this yet or have any ideas how to get ahead of getting certain auditable events from MSSQL into the LEM post Profiler?  We don't want to pull every MSSQL event into the LEM from all of our SQL boxes, just some select events.

       

      I have a question out to our MS TAM to see what answers I can get there,  I'll share what I can when I get it.

       

      https://msdn.microsoft.com/en-us/library/ms181091.aspx

      Updated: October 24, 2016

      SQL Server Profiler is an interface to create and manage traces and analyze and replay trace results. Events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem.

      IMPORTANT!!
      We are announcing the deprecation of SQL Server Profiler for Database Engine Trace Capture and Trace Replay. These features are available in SQL Server 2016 but will be removed in a later version.