SQL Server Performance

Sporadic performance problem

Discussion in 'General DBA Questions' started by Diggers, Feb 5, 2006.

  1. Diggers New Member

    Hi,

    I have an application that runs on SQL Server 2000. Mostly the application runs fine but under heavy usage some queries can take upto 7 seconds to run when normally they run in miliseconds. how can I go about troubleshooting this, I guess with profiler, but what should I be looking for? Any help would be greatly appeaciated.

    Thanks
  2. Luis Martin Moderator

    Run Profiler to identiy those queries and copy/paste into Query Analyzer to find out execution plan.
    Also, with Profiler, try to find looks.



    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