Transcript Forrester DBA Task Distribution 2005

ForrTel:
Outsourcing Your Database
Administration? Think Twice
Noel Yuhanna
Senior Analyst
Forrester Research
April 11, 2005. Call in at 12:55 p.m. Eastern Time
Theme
To be successful database
administration outsourcing
requires careful planning and
execution.
Agenda
• What is involved in administrating databases?
• Why outsource database administration?
• What are the challenges faced when outsourcing?
• What tasks can be outsourced?
• What are the types of outsourcing models?
• How do you succeed in outsourcing?
• What is the future of database outsourcing?
Role of operational DBA
• Install, upgrade, and migrations
• Troubleshooting and corrective
actions
• Space and account management
Distribution of time
Backup rec
load/unload
Security planning
License/doc training
5% 5%
Scripting coding
20%
5%
• Database monitoring and reporting
• Performance and tuning
25%
• Backup and recovery
• Capacity planning
• Data load/unload and
synchronization
40%
Performance/
troubleshoot
Install, upgrade,
patch, migration
Role of application DBA
Distribution of time
• Database design and modeling
• Application administration
• Coding — SP, triggers, objects
etc
Backup and security
Coding
and tuning
• Define process and integration
• Documentation
• Backup DBA for operational
systems
5% Doc/training
25%
• New install, upgrade and
migrations
• Backup and recovery
5%
15%
Install,
upgrade, load
50%
Apps admin and
DB design
Database administration challenges
Resource
issues
Security issues
6%
Backup/recovery
Rep/sync
Planning
6%
8%
26%
Perf/troubleshoot
8%
11%
21%
14%
Change mgt.
Forrester survey: 52 Enterprises with $500 or more in revenue, 2004
Patch/upgrade
Why outsource database administration?
• To save money
• Most administration tasks can be managed remotely
• Databases are becoming a commodity
• Other infrastructure components are being outsourced
• Stable environment, with minimal changes
• Free internal resources for other purposes
• Get resources that are not available internally
What are the outsourcing challenges?
• Lack of security
• Poor turnaround time
• Hidden costs
• Minimal cost savings
• Quality of service
• Lack of depth in troubleshooting
• Lack of business knowledge
• Lack of performance metrics
• Communication issues
Do you currently or plan to outsource database
administration?
Yes
Don’t know
16%
15%
69%
No
Source: 52 enterprises surveyed with $500 or more in revenue, 2004
Have you seen the expected savings from offshoring IT?
40%
37%
28%
19%
20%
7%
2%
0%
Too early
to tell
Have seen the
savings that we
expected
Have seen
savings but
not what we
expected
43 North American IT and business executives, Jan. 04
Have not
achieved
any savings
Savings have
exceeded our
expectations
What administration tasks can be outsourced?
Administration tasks
Success rate
Patch deployment
High, except complex patches*
Upgrades
Moderate, avoid large upgrades*
Backup & verification
High
Space management
High
DBMS tuning
High
SQL tuning
High
Proactive monitoring
High
DBMS install
Low, difficult to perform remotely*
Security management
Moderate, avoid*
Object management
Moderate, should be supported internally
HA management
High, except initial setup
DR management
High, except initial setup
Data load/unload
High, can be automated and monitored
Database recovery
Moderate, depends on complexity of environment*
Startup/shutdown DBMS
High, but depends on DBMS support
Auditing
High
* Will change in future
Database administration outsourcing model
Partial outsourcing
Database
Tech Support
Remote Admin
Agents
DB
DB
DB
Users
Company A
Location 1
DB
Admin
Location 2
Database administration outsourcing model
Complete outsourcing
DB
DB
Data center
Remote admin
Users
Company A
Database
tech support
Top database administration outsourcing vendors
Large vendors
Small vendors
» IBM
» DbaDirect
» Oracle
» Ntirety
» EDS
» Pythian
Offshore vendors
» TCS
» Satyam
» Wipro
How to succeed in outsourcing?
• Before making a decision
» Consolidate
» Standardize
» Formalize
» Stabilize
» Secure
• Perform a cost-benefit and impact analysis
• Choose the right vendor
How to select an outsourcing vendor?
• Operational center — Location,
Infrastructure, redundancy
• Tools used — Agents,
frequency
• Expertise — DBMS, apps,
other technology stack layers
• Accountability – How handled
• SLAs — Response time
• Formalize — Steps and
documented procedures
• Hidden costs — What is not
covered?
• Reports provided — Portals,
frequency
• Administrators located —
Geographic locations
• Support coverage — 24x7
• Security infrastructure —
Access to data, VPN
• References — Ask for them
• Communications — Issues,
clarity
DBA to database ratio
• Current ratio:
» A DBA manages up to 1 TB database collectively
» Average 21 databases per DBA
8,000
Databases
50
Databases
40
30
5,000
DB Size
20
2,000
10
0
-1,000
2001 2002 2003 2004 20052006 2007 2008 2009 2010
Source: Forrester Research
(GB) - Collective DB Size
60
Forecast: Database administration challenges
Performance & tuning
Patch/Upgrade
B&R
Security
2002
2003
2004
2005
2006
2007
2008
2009
2010
Database administration cost is declining
($) Administration cost
14000
12000
10000
8000
6000
4000
2000
0
2001 2002 2003 2004 2005 2006 2007 2008 2009 2010
Future of database outsourcing
• Utility-based model
• More aggressive pricing
• More vendors will offer such service
• Complete stack level integrated focus
Recommendations
• Understand the impact on operations/applications
• Determine cost benefits
• Flush out security concerns
• Understand the vendor’s position
• Small companies should look at full outsourcing
Thank you
Noel Yuhanna
[email protected]
www.forrester.com
Entire contents © 2005 Forrester Research, Inc. All rights reserved.