4 comments on “Improve SQL performance – Stage 1

    • You should never run a database server (at least a production server) without some type of redundancy. RAID 10 is the recommended RAID setup for running a SQL server. However, allowing SQL to parallelize the read and write operations will increase performance overall. A RAID array may contain multiple drives but it’s still controlled by a single I/O controller. Incorporating a second and dividing up the work should be the goal.

      This scenario requires evaluating your needs and your hardware.

  1. Hey Dustin,
    I would advise you to find some decent profiling software for your server and start there. The cost would probably be far less than what you’re budgeting for the hardware upgrades. While you are correct that the hardware does seem to be limiting, you don’t really know that your server is bottle-necking (is that a verb? :) ) on I/O unless you have a profiler that can tell you.

    In a few of my last jobs the SQL that was written was done by developers who really had no decent experience (or desire) with SQL. In one particular project I replaced the current sql with about 4 lines of optimized code and dropped an end-of-day batch routine from 4 hours to 5 minutes. This particular system ran the Commissary inventory for a single jail in Orange County. After my fix we rolled it out to all 5 facilities. With the 5 hour process they were running before they simply didn’t have the time to roll out the system for the entire department.

    So, I would really recommend the profiler, and if that can pinpoint some pain areas then start with that. Otherwise you’re just shooting in the dark. You may aim well, but it’s still shooting. :)

    Good luck!

  2. Hi, very good article, where can we find your continuity articles (draft 2 & draft 3). I am waiting for those.

    Please let me know the same.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s