performance related question

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  February 13, 2013 at 5:56 am

  #289279

  Hi All,

  I have a question on performance tuning approach and where should i start and what should be my approach on below.

  All of sudden, all of my queries started performing very slow. What can i do even before going to profiler tracing..

  Looking for more inputs.

  Thanks in advance.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  February 13, 2013 at 6:09 am

  #1587404

  Index & Statistics maintenance would be my first port of call then look at tuning the queries.

  Ola has a very comprehensive script which will do the index and statistics maintenance for you, there is a link in my signature.

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  February 13, 2013 at 9:12 am

  #1587535

  Thanks very much for the pointer.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 13, 2013 at 9:30 am

  #1587546

  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/

  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

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  February 13, 2013 at 9:35 am

  #1587551

  Thanks Gail for sharing those links. Thank you.:-)