Performance Tuning ...

• dastagirid

  SSCommitted

  Points: 1810

  More actions

  October 20, 2008 at 1:36 am

  #194768

  hello ,

  I am working on the Profiler and increase performance of

  the queries.

  "A QUERY IS SAID TO A GOOD QUERY"

  HOW MUCH MINIMUM TIME DURATION IT NEED".....

  THANKS,

  DASTAGIRI.D

  Thanks
  Dastagiri.D

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  October 20, 2008 at 2:19 am

  #886999

  Sorry, I don't understand. What's the question?

  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

• Clive Strong

  SSChampion

  Points: 11222

  More actions

  October 20, 2008 at 4:08 am

  #887029

  dastagirid (10/20/2008)

  ---

  hello ,

  I am working on the Profiler and increase performance of

  the queries.

  "A QUERY IS SAID TO A GOOD QUERY"

  HOW MUCH MINIMUM TIME DURATION IT NEED".....

  THANKS,

  DASTAGIRI.D

  I think you are stating that the query is well written and that you are asking how long should it take to run? Please correct me if I am wrong on those assumptions.

  If that is your question, the answer is how long is a piece of string?

  The duration of a query is down to a number of factors. Size of the table(s), indexes, statistics and good optimized code. Also, the load on the server in terms of CPU, memory, disk IO etc can play an important part.

  It would be ideal if you could send some more information, such as the query, table/index ddl and the duration you are seeing.

• Jeff Moden

  SSC Guru

  Points: 1004356

  More actions

  October 25, 2008 at 7:34 pm

  #889700

  A query is said to be a good query... until someone finds a way for it to run faster. 😀

  In truth, if the query contains RBAR of any sort, it's not usually a good query because it usually CAN be written to be faster and more scalable while using fewer resources. 😉

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)