Post reply

Where to start - Identify Performance Issue

  • November 21, 2011 at 9:25 am

    #263165

    Hi. I am running SQL 2005 SP2. SQL hosts a single database (third party ERP application). The SQL server is pretty good spec (2 * Xeon Quad Core E5345 + 8GB RAM - 10k SAS drives) and has been configured optimally for SQL

    Users have reported latency issues when requesting features within the ERP application. I would like to monitor using profiler. I am convinced the issue lies with a poorly coded stored procedure or procedures :). Can anyone offer advice on where to begin and what I should be looking for (i.e. how to interpret the results)?

    Kind Regards,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

  • November 21, 2011 at 9:29 am

    #1410839

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2

    I also offer full server quick health check if you think that can help.

    Good luck.

    Edit : Happy hunting. Has nothing to do with luck!

  • November 21, 2011 at 9:39 am

    #1410852

    Thanks for the links, I will take a look. Great response time (unlike the application 🙂 )

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

  • November 21, 2011 at 9:41 am

    #1410857

    2Tall (11/21/2011)

    Thanks for the links, I will take a look. Great response time (unlike the application 🙂 )

    Phil.

    Usually just as fast to find / fix the issue, but that's another story :hehe:.

  • November 21, 2011 at 11:16 am

    #1410939

    Gail's articles will get you started. When you need more, please consider my book (in the signature line).

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply