//
you're reading...
SQL Server

Underestimating the power of poor I/O

This will be a quick post. For about a year I have been alerting the powers that be of the poor I/O  on one of my production systems. The server seemed constantly poised on the brink of over utilization. Of course the poor I/O wasn’t helping matters but some of the other symptoms of the server, High CPU, CXPACKET waits, blocking etc. must be  a results of the high concurrent access, poor query design, and improper indexing I thought to myself and proceeded down a path of corrective action. I made some progress in these areas and saw some server performance improvements. The average I/O was still  tracking around 50 MB/Sec on average.

I recently migrated the databases to new EVA SAN storage. The resulting I/O was now averaging 250 – 300 MB/Sec. Of course I was eagerly anticipating the improvements to performance but had no idea the real extent of the improvements. Average CPU utilization dropped 25 points, CXPACKET, PAGELATCH, PAGELATCHIO waits virtually disappeared,  Blocking, lock escalations, and application timeouts dropped dramatically to almost nothing.  The results were truly dramatic, the point being is that there may be symptoms of I/O stress that one would not normally associate directly with poor I/O.  Obviously if I/O is poor then database performance is only down hill from there. If you have poor I/O then strive to correct that first before seeking other performance gremlins, it will be time well spent.

Advertisements

About ldgaller

Accomplished Data Warehouse Architect, DBA and Software Architect with over 15 years of professional experience and demonstrated success designing and implementing solutions that improve business functionality and productivity. Highly diverse technical background with proven ability to design, develop and implement technology on an enterprise level. I approach all projects with passion, diligence, integrity, and exceptional aptitude.

Discussion

No comments yet.

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

%d bloggers like this: