SQL trace configuration - help

• MickyD

  SSCarpal Tunnel

  Points: 4593

  More actions

  January 14, 2016 at 2:21 am

  #307735

  Hi everyone.

  Bit stuck and hope someone can help me out.

  Setting up a trace , got it working on the events I want etc. Now I want to filter out certain databases and only include the ones I specify.

  I have put this together , but not sure I have it correct.

  Using this to exclude database name containing 1234

  exec sp_trace_setfilter @traceid, 35, 0, 7, N'%1234%'

  and using this to include any database name containing ABC

  exec sp_trace_setfilter @traceid, 35, 0, 6, N'%ABC%'

  But do I need to set an exclusion if I am trying to specify certain databases that I only want to capture information on ?

  Is that correct ? Any advice improvements appreciated.

  Been using this for guidance.

  https://msdn.microsoft.com/en-GB/library/ms174404.aspx

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  January 14, 2016 at 6:51 am

  #1851881

  once you specify an include to limit the profiler to just the databases you want, you don't have to specify an exclude as well.

  ---------------------------------------------------------------------