SQL Server Performance

sql2005 performance tools

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by vbdotnewbie, May 8, 2006.

  1. vbdotnewbie New Member

    I'm running an sql2005 (SSEE) server on my network, and have noticed that the %processor often spikes to 100%. I'm looking for some tools and/or tutorials that will help me troubleshoot this issue. I've not been able to find any information on sql2005 performance audits, and was hoping someone could point me in the right direction. I'm new to the DBA side of things so any information would be appreciated.

    thanks.
    vbdotnewbie
  2. Luis Martin Moderator

    You have to run Performance Monitor and Profiler.
    This article apply to 2000, but is usefull for 2005 also.

    http://www.sql-server-performance.com/sql_server_performance_audit.asp



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  3. satya Moderator

    http://sqljunkies.com/Article/7F8518F9-FDAA-4FF3-8FC5-25E8946C8D0C.scuk will also help you.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. dineshasanka Moderator

  5. Luis Martin Moderator

    Done.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page