SQL Server Performance

performance tuning tools

Discussion in 'T-SQL Performance Tuning for Developers' started by rohitkochar, Jun 17, 2007.

  1. rohitkochar New Member

    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)
  2. MohammedU New Member

  3. satya Moderator

    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.

Share This Page