Poor database performance

  • Thanks a lot.

    I will review a bit!

    Regards

  • ruan.keyser (10/17/2011)


    Thanks a lot.

    I will review a bit!

    Regards

    Fair warning. That article assumes you can do basic tuning. That part we can't give away. It's acquired by 1000s of hours invested in that topic.

    Great & free tuning book if you have the time to read it.

    http://www.sqlservercentral.com/articles/books/65831/

  • After hours of researching and sweating I can safely say that this is an IO issue. I believe the partitioning was done incorrectly.

    I have come upon a VERY interesting link that explains partitioning for Windows Server 2003 should be configured in a specific way for SQL systems.

    I have also run the tool BPA which viewed quite a few interesting points. (Most performance related warnings and errors pointed to the IO subsystem and Windows configurations)

    Have a look at the below link:

    http://sqlserverpedia.com/blog/sql-server-performance-tuning/how-to-improve-application-and-database-performance-up-to-40-in-one-easy-step/

    Regards

  • If you want even more checks than what the BPA does. Not sure if disk part is included in this list, but the author definitely knows about that.

    http://www.brentozar.com/blitz

  • Great stuff!

    Thanks

  • ruan.keyser (10/18/2011)


    Great stuff!

    Thanks

    The whole blog is awesome.... if you can free up a few days (20+ hours of great videos too).

  • ruan.keyser (10/17/2011)


    I would love to have some one's email address, as I believe this is going to be a looooong problem.

    I've been put in an environment that was lacking performance from the beginning. I have managed to improve it a bit (from my perspective) and the BA leader also confirmed this.

    I can send you my contact details. I'm JHB-based and I've tuned systems for years with massive improvements. But if your company isn't willing to spend money, that's just a waste of both out times. I'm not cheap by SA standards.

    p.s. proper disk partition alignment requires re-partitioning and reformating the disks, ie wiping everything on them. It may help, but it's not going to change the fact that your IO subsystem is underpowered.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • ruan.keyser (10/14/2011)


    Avg. Disk sec/Read - 0.005

    Avg. Disk sec/Write - 0.036

    Avg. Disk Queue length - 0.095

    % Disk Time - 3.104

    When did you check those? While the system is under heavy load or while semi-idle? During peak activity or at some other time?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • This was during peak activity.

    I am busy setting up a scheduled monitor for the next week or so to determine this 100%

  • ruan.keyser (10/18/2011)


    This was during peak activity.

    I am busy setting up a scheduled monitor for the next week or so to determine this 100%

    This is a great monitoring software. It comes with two 14 days trials. Should be enough to trace and log evertyhing while you debug this.

    http://www.red-gate.com/products/dba/sql-monitor/

Viewing 10 posts - 31 through 39 (of 39 total)

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