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)
    rohitkochar, Jun 17, 2007
    #2

  2. MohammedU New Member

    MohammedU, Jun 17, 2007
    #2

  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.
    satya, Jun 18, 2007
    #2

Share This Page