SQL Server Performance Steps | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server Performance Steps

I am a SQL Developer & DBA , Can any one give me some guidance to start with Performance tuning steps to be followed. How to find out the queries that are effecting the performance and what are the steps that we can perform to tune that thanks in advance Regards

there are many good articles on this site. did you take a look at them? http://www.sql-server-performance.com/articles_performance.asp
http://www.sql-server-performance.com/articles_audit.asp SqlSpec: a fast and comprehensive data dictionary generator for
SQL Server 2000/2005, Analysis Server 2005, Access 97/2000/XP/2003

you may run Profiler to trace long running queries and then try to improve on it by examining Execution Plan wether it use correct index or not. Refer
http://www.sql-server-performance.com/tips_performance.asp and
http://www.sql-server-performance.com/sql_server_performance_audit.asp and
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp Regards Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
… and if you can try searching on the forums for relevant threads. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.