SQL Server Performance

• Ranga N

  SSChasing Mays

  Points: 642

  More actions

  September 30, 2003 at 11:37 am

  #65491

  which knobs to turn??

  I am not a SQL Guru, but experienced enough to do most of the things in SQL. I have to fix a poorly performing SQL Server. I am just wondering how i should start looking for potential problems....Please let me know if you have links for articles on this subject..

  Thanks!

• ray_higdon

  SSCarpal Tunnel

  Points: 4589

  More actions

  September 30, 2003 at 5:48 pm

  #476465

  Try these:

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

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

  http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itcommunity/chats/trans/sql/pass1124.asp

  http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itcommunity/chats/trans/SQL/sql0513.asp

  http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itcommunity/chats/trans/SQL/SQL1023.asp

  HTH

  Ray Higdon MCSE, MCDBA, CCNA

  ------------
  
  Ray Higdon MCSE, MCDBA, CCNA