Replaying SQL Profiler session

• Peter D-251663

  Ten Centuries

  Points: 1010

  More actions

  January 20, 2007 at 10:45 pm

  #69576

  Running SQL 2000.  I've captured a SQL Profiler Trace of Production.  I'd like to replay that same trace in a clone of the environment I captured.  Is this doable?  I do know the database ID# would probably be different in the cloned environment.  I'm trying to see if I can make some index changes that may elimate a possible deadlock.

  Appreciate insight.

   

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 21, 2007 at 1:03 am

  #684554

  Yes it doable...

  Read the topics..."Requirements for Replaying Traces" and "Replaying Traces on a Different Server" from the following article...

  http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c10ppcsq.mspx

   

  MohammedU
  Microsoft SQL Server MVP