performance tuning

• trinamjose23

  Valued Member

  Points: 63

  More actions

  January 29, 2012 at 8:42 pm

  #254436

  can any one provide me sample quires to practise performance tuning on sample databases.

  plz i am much confused and i want to practice more to understand well...

• poojari045

  SSChasing Mays

  Points: 654

  More actions

  January 29, 2012 at 9:02 pm

  #1439820

  Check this link.

  http://www.sommarskog.se/query-plan-mysteries.html

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  January 30, 2012 at 6:54 am

  #1439958

  trinamjose23 (1/29/2012)

  ---

  can any one provide me sample quires to practise performance tuning on sample databases.

  plz i am much confused and i want to practice more to understand well...

  You cannot practice something that you don't yet know how to do. You need to lots of books, blog posts and best of all get some MENTORING to be TAUGHT how to do performance tuning first.

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 30, 2012 at 7:04 am

  #1439966

  Start with these

  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/

  Then buy this: http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/ref=sr_1_2?ie=UTF8&qid=1327932227&sr=8-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