SQL Server Performance Forum – Threads Archive
performance tuning toolsHI ,
please tell me some inbuilt tools to tune T-Sql in SqlServer-2005
apart from execution plan analsys??
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
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
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.