Identifying performance issues using Profiler trace

• Suresh Arumugam

  Hall of Fame

  Points: 3370

  More actions

  March 4, 2013 at 2:00 am

  #290151

  Hi All,

  I have been told that I would be given a production profiler trace to figure out the performance issues during application peak time.

  Assuming required properties are chosen while producing trace & SqlServer 2008R2 is the version.

  I am aware of some tuning methologies if I identify the bad performing query (adding indexes, re-write logic). However, I need to start from trace and narrow down to bad performing queries. please help me with some formal way how to progress once I receive the Trace.

  Any steps/docs would help me to kick start pls.

  Thank you all.

  Regards,

  Suresh

  Regards,
  Suresh Arumugam

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 4, 2013 at 2:18 am

  #1592914

  http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

  http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Suresh Arumugam

  Hall of Fame

  Points: 3370

  More actions

  March 4, 2013 at 2:24 am

  #1592916

  Thanks Gail.

  I had a high level look at your posts and they look very promising. I am going to work on your steps to have a hands on.

  Thanks again.

  Regards,
  Suresh Arumugam