SQL Server Performance Forum – Threads Archive

performance tuning tools

HI ,
please tell me some inbuilt tools to tune T-Sql in SqlServer-2005
apart from execution plan analsys??
Rohit Kochar
MCP .Net(Web and SqlServer)

---

Profiler, DMVs and DTA etc… https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032290643&EventCategory=5&culture=en-US&CountryCode=US
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/performance_tuning_waits_queues.mspx
http://www.sql-server-performance.com/bm_performance_dashboard_2005.asp
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

Don’t forget SYSMON (PERFMON), PROFILER, Database Tuning Advisor in addition to the above.
I believe SQL 2005 Books online (updated) is good to go from here to see for such information. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

]]>