Big Data. Big Decisions
InformationWeek
Special Coverage Series


DH2i Takes On SQL Server Consolidation Challenge

Startup led by former HP PolyServe staff uses virtualization-like techniques to stack up SQL Server instances on a single host, cutting core-based license costs.

DH2i's Don Boxley, co-founder and CEO of DH2i, says his young firm has solved two persistent problems in database systems management. It can move a running database system around without disrupting operations for end users, and it can encapsulate and stack a set of SQL Servers, each operating independently, on a single server to achieve a higher server utilization rate.

Whichever way you want to look at it, these two things have been difficult to do heretofore, and the enterprise data center still tends to be littered with single servers running one database system at a time, frequently at a low CPU cycle utilization rate.

More Insights

Webcasts

More >>

White Papers

More >>

Reports

More >>

DH2i upgraded its core system Sept. 24, the DxConsole 2012 Release 2, a product that typically retails for $10,000 per CPU, with claims for its added intelligence, greater scalability, and better performance. There's little customer testimony on the record yet for this novel product and no expert reviews.

Nevertheless, Boxley is a former HP product marketing manager in Ft. Collins, Colo., who's taken on the task of establishing DxConsole. His partner, co-founder and CTO of DH2i is O.J. Ngo, the developer behind HP's former PolyServe product, which consolidated SQL Server instances onto fewer servers. PolyServe has been phased out recently by HP, so DH2i has a potential, instant customer base of PolyServe customers looking for someplace to go. Likewise, DxConsole is a revamped PolyServe done right, says Boxley in so many words.

[ Want to learn more about DH2i's purpose? See DH2i Rolls Out Enhanced Application Virtualization, Load Balancing. ]

One key metric to watch when evaluating DxConsole is whether it can save a firm on both the number of physical servers devoted to database operations and the number of operating system and SQL Server licenses required. For example, Microsoft switched its SQL Server pricing model from CPU-based to a per-core basis with SQL Server 2012. If you can run four or eight copies of SQL Server on the same server that currently hosts one copy, you've reduced your Windows and SQL Server licenses accordingly.

DxConsole is actually made up of modules managing different aspects of a running database system to accomplish such a feat. The DxMotion module is the rough equivalent of VMware's vMotion, moving a SQL Server instance while it's running to another physical host. It can do so, says a product demonstration on the DH2i website, "in less than 30 seconds."

Likewise, DxMotion can be used, through an administrative console, to stack instances upon a single server, through a simple drag-and-drop technique. The DxConsole sits atop a shared pool of storage, governed by a single file system, so a given instance's storage can follow it around.

Boxley explained that DxConsole knows how to read the connection stream between, say, an accounting application and the database system and substitute a replacement name for an SQL Server instance in the connection stream. Then when it moves to a new host, it knows how to modify the connection stream to direct its former traffic to the new location.

DH2i calls this maneuver "virtualizating" the database instance, but it's more of a virtualization-like maneuver. There's no virtual machine or hypervisor involved or software-run substitution of the x86 instruction set. Instead, it's a graceful, sleight of hand maneuver, provided it works as advertised.

The DxConsole works with a set of SQL Servers, up to 50 instances, running on a server cluster and providing scale-out capabilities across more server nodes, as well as server consolidation. The DxConsole lets the administrator set policies, such as "move this instance when its traffic uses up more than 70% of the assigned memory," and the underlying system will find a better server in the cluster for it.

Boxley said both PolyServe and DH2i customers "love SQL Server and run an average of 40 instances of it." So an administrative system that works on the principles of pooled storage, shared data, and flexibly placed SQL Server instances has a lot of potential for them.

Then again, DH2i is a young company with seven employees. It's rich in SQL Server expertise, short on customers. It will have about a dozen at the end of 2012, with several of them major users of SQL Server, said Boxley.



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.