On budget with Websphere SQL Server Type 5 JDBC connectivity in virtualized environments

On budget with Websphere SQL Server Type 5 JDBC connectivity in virtualized environments

January 27, 2012 0 Comments

As a certified IBM Consultant working exclusively on data connectivity for Progress DataDirect, I have learned a couple tricks of the trade.  The most compelling of which is the cost savings story on virtualization that fellow consultants and prospects have shared with me.  They found running Progress DataDirect Type 5 JDBC drivers in virtual environments greatly reduces the amount of resources required to run application servers.  With heavy production loads, up to 90% of processing power can be spent in drivers alone.  If a project has budget of x dollars and the estimated costs are now running over, you need to get creative to deliver the goods.

So what is this creative approach to keep projects on budget?

Benchmark your load testing with type 5 drivers from Progress DataDirect and see how many virtual processors and servers you can reduce to meet your budget requirements.  And IBM continues to recommend our JDBC connectivity in their data source configurations.

The same story applies to DataDirect Connect for ODBC drivers with other applications.

What kind of cost savings can we expect with Websphere Application Server using Type 5 DataDirect Connect for JDBC SQL Server drivers?

I am seeing a wave of Websphere Application Server upgrades.  The pattern for successful cost savings has been in intensive data driven enterprise applications; and these are realized in two specific areas: hardware and licensing.

1. Hardware (Virtual)

We ran some independent tests to help confirm this story.  Here is what we found when testing logical resource requirements on Amazon EC2 virtual machines.    We found our drivers had lower memory utilization and better CPU utilization compared to an alternate driver allowing us to achieve 2.6x* increase in throughput on the same machine hosted on EC2.  Based on increased throughput, fewer virtual resources are required to do the same work.  Let's say this efficiency required four fewer production application servers.

*Average throughput calculated from series of DataDirect Performance Lab tests.

Below are Amazon EC2 pricing used to calculate virtual hardware costs:

Linux/UNIX Usage Windows Usage
Standard On-Demand Instances
Small (Default) $0.085 per hour $0.12 per hour
Large $0.34 per hour $0.48 per hour
Extra Large $0.68 per hour $0.96 per hour

Servers * Hourly Cost * Hours / Year * 1 Years

4 * $0.96 * 8760 * 1

Total Annual Savings $33,638.40

2. Licensing

If the virtual machine or logical partition running your application servers require x number of virtual processors * Processor Value Units (PVUs), and running type 5 drivers allow your infrastructure to run with y fewer virtual processors; you can expect a cost savings of ( (x-y) * price per virtual processor ) * number of servers.  For this case, we will look at AIX and assume similar throughput was achieved from EC2 testing.  Disclaimer: The following figures ONLY serve as an indication; and list prices are taken from IBM's catalog.

120 PVU (IBM Power System) * $50.75 - IBM WebSphere Application Server Processor Value Unit (PVU) License + SW Subscription & Support 12 Months

Cost per virtual processor: $6,090.00

Refer to IBM's site for additional details on sub capacity (virtualization) licensing.

Let's say you have 4 production servers saving 2 virtual processors each - (x-y is 2) * $6090 * 4

Total Annual Savings $48,720.00

Are you suggesting that I will save $247,074.00 over 3 years?

The calculations are from different environments, and the figures only serve as an indication of hidden costs in database middleware not optimized for virtualization.  These are based on our internal weekly performance tests to measure throughput and resource utilization in response to what we have learned from consultants and customers.  There is no substitute for testing in your own environment against a production load, and I encourage you to download a free 15 day trial to find out how much you can save.

Get started today with a 15 day trial:

1 . Install Progress DataDirect Connect for JDBC using the instructions in the Progress DataDirect Connect for JDBC Installation Guide.  You can download a free, 15-day trial of the Progress DataDirect SQL Server JDBC driver (including DB2, Oracle, Sybase, MySQL and Salesforce).

2. Follow our Type 5 JDBC Websphere Application Server tutorial.

3. Or call 1-800-876-3101 to speak with a live Solutions Consultant to learn more about the EC2 virtualization testing and the DataDirect performance lab.

Sumit Sakar

Sumit Sarkar

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.

Comments are disabled in preview mode.
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
2020 Progress Data Connectivity Report
2020 Progress Data Connectivity Report
Read More
Getting Ahead of the Hybrid Data Curve
Read More
570x321__Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Read More