T-SQL Tuesday #004: IO and Virtualizing SQL

From what I can tell, the SQL-based “meme” T-SQL Tuesday was started by Adam Machanic (industry guru and SQL blogger at SQLblogs.com).  This week’s entry is hosted by the prolific SQL expert Mike Walsh.

The point?

T-SQL Tuesday is the SQL Server blogosphere’s first recurring, revolving blog party. The idea is simple: Each month a blog will host the party, and about a week before the second Tuesday of the month a theme will be posted. Any blogger that wishes to participate is invited to write a post on the chosen topic. The event is called “T-SQL Tuesday”, but any post that is related to both SQL Server and the theme is fair game.

SQL and Disk IO

This weeks topic – IO – definitely caught my eye.  Especially Merrill Aldrich’s entry about using SSD’s with their EMC Symmetrix array.   Merrill wisely cautions about considering fancy storage arrays as the cure-all for all your performance problems but he quotes a few solid improvements to their database performance with a professionally-installed (EMC Professional Services) layout.

I can say that it’s performed really well – the Oracle and SQL Server systems that have SSD storage on the new array definitely saw a net boost in performance. Most of the time, our Oracle DBA’s report that they see about a 2/3 increase in performance, with some exceptions. I am running a data warehouse function on the SSD’s, and I can say we shaved perhaps 25% off of our ETL/load window by moving to the new hardware.

That is just a portion of the good stuff and recommendations.  Please check out his entire article/entry over here.

What I would like to blog about:

Perhaps this is against the rules because it’s not something I’ve written myself.   I did want to share what I thought was an excellent whitepaper that describes 3 SQL Server consolidation options (single instance, multi-instance, and hypervisor) and compares each on the following traits:

  • Cost
  • Ease of Consolidation
  • Ease of Administration
  • Application Performance

It was written by one of our brilliant solution engineers, but is still very digestible and easy to read.  And you will be surprised by the results.  If you are in a hurry, you can skip to page 17 if you just want to see the summary…

Nice job, John on this great SQL Server Consolidation options paper!

Update: Here’s a round-up of all the IO themed T-SQL Tuesday posts.

Advertisements

2 thoughts on “T-SQL Tuesday #004: IO and Virtualizing SQL

  1. Pingback: T-SQL Tuesday #4 - IO, IO It's Off To Disk We Go | SQL Server Blog - StraightPath Solutions

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