Will Profiler Capture all data feeds/applications accessing SQl Server

• gs1975

  Ten Centuries

  Points: 1057

  More actions

  September 10, 2012 at 9:00 am

  #281415

  My manager wants all data feeds to be captured for a number of SQL Servers.

  This is because all reports, SSIS Packages and anything else relevant need to be repointed to a new server at some stage. Nobody really knows what accesses what.

  I am using Profiler to do this. Is Profiler likely to capture everything accessing or using a sql server, or are there better 3rd party tools out there to do this?

  Cheers,

  George

• bpportman 52825

  SSC Eights!

  Points: 870

  More actions

  September 10, 2012 at 9:39 am

  #1535774

  Profiler is your tool. It will capture every database call, based on the events you select. You definately need RPC:Completed and SQL:BatchCompleted.

• Ignacio A. Salom Rangel

  SSC-Insane

  Points: 20443

  More actions

  September 10, 2012 at 10:45 am

  #1535817

  Profiler will help you to accomplish what you mant, but it causes overhead on your Server. You may find this link interesting http://www.sqlskills.com/blogs/jonathan/category/Extended-Events.aspx

  ---

  
  
  My blog