Advertisements

Conor O'Mahony's Database Diary

Your source of IBM database software news (DB2, Informix, Hadoop, & more)

Archive for the ‘Microsoft SQL Server’ Category

Staffing and Time-to-Market for IBM DB2 and Oracle Database Environments

leave a comment »

Solitaire Interglobal surveyed IT departments about the amount of staffing needed for various database-related activities. When it comes to staffing, Solitaire notes that:

These staffing figures were collected from the actual operation groups measured in the other metric collection efforts, and cover organizations in North and South America, Asia, Europe, Antarctica and Australia. These organizations have reported staffing for 24×7 coverage, rather than single shift.

Antartica… really! Anyway, here’s the staffing information, first for IBM Power Systems environments and then for IBM System x environments:

Database Software Staff for IBM DB2 and Oracle Database in IBM Power Systems Environments
Database Software Staff for IBM DB2 and Oracle Database in IBM System x Environments

Solitare notes that a significant contributor to IBM DB2 requiring less staff are the requirements around the service desk or help desk. They attribute the difference to the number of calls, and the amount of time required to handle those calls. If you read the full report, you will see lots of great information about specific percentage differences for number and duration of calls on each platform.

Another interesting metric for comparing database software is time-to-market. This is the amount of time it takes an IT department to get a system up-and-running, from project inception to having live production systems. Time-to-market is a very important consideration for organizations who want to have agile and responsive IT departments. In this case, Solitaire note that:

The systems tracked for this portion of the study were paired based on either simultaneous comparative development, or function point equivalents and application type. The comparison is intended to be evocative and not quantitative, since other critical success factors can enter into this picture.

Here is the time-to-market comparison, first for IBM Power Systems environments and then for IBM System x environments:

Time-to-Market for Database Software Projects involving IBM DB2 and Oracle Database in IBM Power Systems Environments

Time-to-Market for Database Software Projects involving IBM DB2 and Oracle Database in IBM System x Environments

You can read and download the full Solitaire report at Comparing Real World Database Performance: IBM® DB2® versus Oracle® Database and Microsoft SQL Server®.

Advertisements

Written by Conor O'Mahony

May 11, 2011 at 11:00 am

IBM DB2 Users Report that they are More Satisfied than Oracle Database Users

leave a comment »

Yesterday, I blogged about relative outages for IBM DB2 and Oracle Database, as reported by Solitaire Interglobal. Well, Solitaire also surveyed people in data centers regarding their satisfaction levels with database software. Here is how Solitaire introduce their findings:

The ultimate metric for the success of any product is customer satisfaction. The satisfaction rating is an aggregate result of how well the customer feels that the DBMS provides benefit for the expense, reliability and thought leadership. As such, this rating can be seen as the final accolade of how well a product is doing.

Solitaire report the satisfaction for two groups: the Executives that manage the overall organization, and the Operational Staff that work with the systems on a day-to-day basis. Here are the findings. As you can see, both the Executives and the Operational Staff who work with DB2 report a higher satisfaction than those who work with Oracle Database.

First, here are the satisfaction ratings for environments running IBM Power Systems servers.
Database Software Customer Satisfaction in IBM Power Systems Environments

And here are the satisfaction ratings for environments running IBM System x servers.
Database Software Customer Satisfaction in IBM System x Environments

Not only do customers–both Executive and Operational–have a higher satisfaction rating for DB2, but interestingly the people who are hands-on day-in and day-out have the best satisfaction numbers.

You can read and download the full Solitaire report at Comparing Real World Database Performance: IBM® DB2® versus Oracle® Database and Microsoft SQL Server®.

Written by Conor O'Mahony

May 10, 2011 at 11:00 am

Comparing Outages for IBM DB2 and Oracle Database

leave a comment »

Solitaire Interglobal monitor client data centers around the world. Recently, they analyzed certain performance chartacteristics for database software within those data centers. One of those performance chartacteristics is reliability.

They measured database software reliability from 1,430 Power Systems/AIX production environments. Here is their explanation of the following charts:

…both the planned and unplanned outages affect the overall usability of the total system. The charts below show the number of outages that were recorded during the testing period, as well as, the total number of minutes that those outages consumed. The number of outages has been normalized for a 100-platform operation, with both planned and unplanned outages included.

As you can see, Oracle Database has more outages, and longer outages. Solitaire indicate that most of these are planned outages, with DB2 users reporting easier movement and allocation of resources. The next most significant factor was that Oracle Database requires a greater number of patches and upgrades.

Normalized Outage Count - Planned and Unplanned on IBM Power Systems - IBM DB2 and Oracle Database - Source: Solitaire Interglobal

Normalized Outage Count - Planned and Unplanned on IBM Power Systems - IBM DB2 and Oracle Database - Source: Solitaire Interglobal

Here is the same analysis for database software in IBM System x environments. In this case, the analysis is for 13,927 production environments and the number of outages has been normalized for a 75-platform operation.

Planned and Unplanned Outage Count on IBM System x - IBM DB2, Oracle Database, and Microsoft SQL Server - Source: Solitaire Interglobal

Planned and Unplanned Outage Time on IBM System x - IBM DB2, Oracle Database, and Microsoft SQL Server - Source: Solitaire Interglobal

Over the next few days, I will share more findings from the Solitaire report. You can read and download the full report at Comparing Real World Database Performance: IBM® DB2® versus Oracle® Database and Microsoft SQL Server®.

Written by Conor O'Mahony

May 9, 2011 at 11:59 am

Why Dow Jones Chose DB2…

with 2 comments

Here is an interview from 2008 with Bashir Khan from Dow Jones. In this interview, he tells us why Dow Jones chose DB2 ahead of other database management systems. I especially like the following quote where he indicates that they benchmarked the various vendors and DB2 came out ahead.

After looking at a lot of options, there was only one real option that was left for for us, and that was DB2 for LUW on the Unix platform. Before we made a final decision, we benchmarked some of the key database management systems that includes Oracle, SQL Server, and DB2. We ended up choosing DB2 for several reasons. One was reliability. Second was performance. And perhaps the most important factor was ease of use.

Written by Conor O'Mahony

August 21, 2009 at 4:52 pm

%d bloggers like this: