Big Data. Big Decisions
InformationWeek
Special Coverage Series

Commentary

George Crump

Throw Hardware At The Problem

Sometimes you have to fix a performance problem quickly. Solid state storage can help you do that, if you consider these tips.

In a recent column, titled How To Maximize Your SSD Investment, I discussed the importance of discovering the performance profile of your environment so you could make a better decision about which solid state drive (SSD) devices are the best choice for your data center. Research and planning are the best way to tackle a problem, but sometimes you don't have the luxury of time. You have to "fix it now" and you have to perform triage using solid state storage.

I think that eventually most data centers will end up with flash SSD solutions throughout the data center stack (servers, network, and storage), but when you are in triage mode you need to move quickly to fix an immediate performance problem. In this situation, we are going to risk throwing hardware at the problem at the expense of accuracy, and, while the purists will raise their eyebrows, taking a best guess instead of waiting a few weeks for data to be analyzed is reality sometimes.

More Insights

Webcasts

More >>

White Papers

More >>

Reports

More >>

We do want to do a quick check to ensure we can make a strong educated guess that our performance problem is related to storage. The quickest way to do that is to look at the CPU utilization of the attached server or servers hosting the application. If that utilization is relatively low (below 30%) then, in almost every case I have seen, there is a problem related to storage.

The next step is to decide which of the various flavors of SSD will most help your performance. Since we are typically breaking away from a set SSD strategy, this project may not be a budget item, so keeping cost down is also important. We want to implement something that is as inexpensive as possible, as non-disruptive as possible, for as little money as possible. Since a brand new storage system is probably not an option, so we are going to be looking for something that we can add to an existing setup.

[ For more storage performance tips see The Storage Problem Technology Can't Solve. ]

This is an ideal situation to look to server-side SSD, especially if our performance problem is isolated to a single application on a single server (or a small number of servers). PCIe is quickly becoming the default solution for these situations. Most database applications support PCIe for caching, and there are several operating system-level software-caching products available. As we discussed in a recent article, though, all PCIe SSDs are not created equal, and it is important to know what each PCIe SSD can really do for you--as well as what level of software support exists for the boards. A stumbling block to implementing PCIe SSD may be a space problem. In that case, you may want to look at SSD-DIMMS or drive-form-factor SSDs.

If the performance problem is affecting multiple servers, then a network-based SSD solution may be better. The value of these solutions is that they can provide performance enhancements to multiple servers or hosts and to multiple storage systems (even different brands of systems). A few can be implemented with no disruption to current operations. These devices may be able to become the foundational core of broader SSD strategy and eliminate the performance sprawl problem we discussed in a recent article.

When users are pounding on IT's door complaining about performance, there may not be enough time available to undertake a complete project that includes a deep interrogation of the performance challenges the environment is facing. Triage leverages your knowledge of the environment and the near-zero latency of SSD to provide a quick remedy. After triage is complete, you should open up a project to design a complete SSD strategy.

Follow Storage Switzerland on Twitter

George Crump is lead analyst of Storage Switzerland, an IT analyst firm focused on the storage and virtualization segments. Storage Switzerland's disclosure statement.

From thin provisioning to replication to federation, virtualization options let you reclaim idle disks, speed recovery, and avoid lock-in. Get the new, all-digital Storage Virtualization Guide issue of Network Computing. (Free registration required.)



Related Reading




Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

BYTE encourages readers to engage in spirited, healthy debate, including taking us to task. However, BYTE moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing/SPAM. BYTE further reserves the right to disable the profile of any commenter participating in said activities.

Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.

Follow InformationWeek

By The Numbers

What Are Your Primary Concerns About Using Big Data Software?

Base: 417 respondents at organizations using or planning to deploy data analytics, BI or statistical analysis software
Data: InformationWeek 2013 Analytics, Business Intelligence and Information Management Survey of 541 business technology professionals, October 2012

What Do You Think?

What's your attitude about SQL analysis on top of Hadoop?
We want fast, standard SQL analysis capabilities on Hadoop ASAP
Hadoop is for unstructured data; SQL is for relational databases
We'll give SQL on Hadoop a try, but relational DBs will remain the mainstay
Given strong SQL support on Hadoop, we'd nix the data warehouse
We're not interested in Hadoop
No opinion



Related Content

From Our Sponsor

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Business leaders often need a visual snapshot of data to quickly grasp and use it. This paper identifies five challenges in presenting data and how visual analytics can resolve them. Solutions are suggested to overcome the challenges of: speed, data clarity, data quality, displaying meaningful results, and dealing with outliers.

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Today's competitive advantage requires a deeper understanding of your business, your market and your customers. As an IT executive, you can drive that knowledge transformation. In this white paper, learn how to make decisions as a strategic business leader and three steps to begin an analytics initiative within your enterprise.

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

High-performance data visualization turns sophisticated analyses into meaningful graphics, leading to faster and smarter decision making. In this white paper, learn how visual analytics can transform big data, with additional features such as real-time functionality, mobile compatibility, robust applications for technical groups and accessibility for nontechnical users.

Big Data: Lessons from the Leaders

Big Data: Lessons from the Leaders

Financial performance, competitive advantage, operational efficiency, strategic decision making - every business goal can extract value from big data, and the time for doubt or inaction has long passed. In this Economist Intelligence Unit report, in-depth interviews with data pioneers reveal the link between the effective use of big data and the bottom line among other results.

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Which came first, the data or the decision? This white paper makes the case for having a decision in mind, then tailoring big data's volume, variety and velocity to achieve business results such as overcoming customer dissatisfaction or creating well-informed strategies in real time.

Informationweek Reports

Research: The Big Data Management Challenge

Research: The Big Data Management Challenge

The challenge of big data is real, but most organizations don't differentiate 'big data' from traditional data, and nearly 90% of respondents to our survey use conventional databases as the primary means of handling data. We'll help you understand what constitutes big data (it's not just size) and the numerous management challenges it poses.