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.
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:
- 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!