Performance tuning and code optimization.

• joyento.acs

  Valued Member

  Points: 53

  More actions

  July 24, 2012 at 5:04 am

  #278533

  Hello Everyone !

  As a newbie in SQL SERVER, I want to know about the performance tuning and code optimization.

  What are the steps to follow in the field of optimization and tuning... looking for the helping concern, revert me on my needs...

  Plz perform with an example... which will boost up... as well as deeply appreciable....

  Thanks in Advance.

  Joyento/ACS.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  July 24, 2012 at 5:12 am

  #1516719

  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

  http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025

  And lots and lots of practise.

  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

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  July 24, 2012 at 5:14 am

  #1516720

  A good book to start with:

  SQL Server 2012 Query Performance Tuning

  Look around on the web. There are tons of articles, blogs and books written on SQL Server performance.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP