SQL Server Profiler Replay execution

• trivedi.nikesh

  Right there with Babe

  Points: 715

  More actions

  August 10, 2010 at 4:42 am

  #225271

  Hello Guys,

  I am willing to create a warmup session for our servers, for this I collected queries through profiler in Replay mode. But now I want to call this replay through batch file. So I can schedule with SQL job, and on each start of working week I run this to warmup my servers.

  Please can you suggest me the way to create this scenario, and please provide some information that how I can execute profiler from batch file.

  Thanks,

• Satish Nagaraja

  SSCrazy

  Points: 2632

  More actions

  August 10, 2010 at 4:48 am

  #1204627

  Try this link to get started

  http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

  Cheers

  Cheer Satish 🙂