worst performing queries in sql 2000

• bodhilove

  SSCarpal Tunnel

  Points: 4035

  More actions

  June 18, 2009 at 5:47 pm

  #73223

  How can you find the worst performing queries in sql 2000?

  It seems like a bit of a mission because you don't have access to the dmvs like in 2005.

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  June 18, 2009 at 5:56 pm

  #1012126

  You have the profiler traces and execution plan but I always used profiler, it is best to run it in a test because it takes a lot of resources.

  Kind regards,
  Gift Peddie

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 19, 2009 at 3:24 am

  #1012242

  Server-side trace. Far less impact than profiler and you can schedule it with SQL Agent.

  There's a section on creating a server side trace here - http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

  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

• bodhilove

  SSCarpal Tunnel

  Points: 4035

  More actions

  June 23, 2009 at 6:40 pm

  #1014363

  thanks Gail- that was quite informative.