Optimizing A SP

• tap_ks

  Valued Member

  Points: 64

  More actions

  October 31, 2002 at 12:27 am

  #79849

  Hi!

  Can anybody helps me how to optimises a SP by using SQL Server profiler? What are the parameters to be taken care?

  Can I get some links on the same.

  Thanks in advance.

  TapKs

  
  TapKs

• Klaas-Jan

  SSCrazy

  Points: 2297

  More actions

  October 31, 2002 at 2:29 am

  #439886

  Hi, i would use the execution plan in query analyser to optimise an sp. Or you can use the index wizzard.

  check also the following link:

  http://www.sql-server-performance.com/

• tap_ks

  Valued Member

  Points: 64

  More actions

  October 31, 2002 at 2:43 am

  #439890

  Hi!

  But how to use it? Which parameters I should check?

  TapKs

  
  TapKs

• Klaas-Jan

  SSCrazy

  Points: 2297

  More actions

  October 31, 2002 at 3:34 am

  #439902

  Hi, Robert Marda has written a great article wherein he explanes how executation plans works.

  http://www.sqlservercentral.com/columnists/rmarda/understandingexecutionplans.asp

• tap_ks

  Valued Member

  Points: 64

  More actions

  October 31, 2002 at 10:15 pm

  #440017

  Thanks a lot.

  TapKs

  
  TapKs