shahid mohammed eme database team manager july 21, 2006
TRANSCRIPT
![Page 1: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/1.jpg)
Shahid Mohammed
EME Database Team Manager
July 21, 2006
![Page 2: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/2.jpg)
Marsh 2
About Me
Many years experience in database & information management in operational environments
Currently EME Database Manager & Global Database Architecture Co-ordinator for Marsh (Insurance & Risk)
Also worked in the eCommerce, New Media and Telecoms
![Page 3: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/3.jpg)
3
Scenario 2003
Problems• Business Continuity• Capacity
• New Projects• Business Growth
• Supportability• Maintenance
• Return On Investment
Application Servers
Database Servers+Storage
![Page 4: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/4.jpg)
4
Scenario 2003
Batch Processes
OLTP Web
Dev/QA Data Warehouse
ENTERPRISE
4500
Sun
SunENTERPRISE
450
Ultra
ENTERPRISE
4500
Sun
Sun 2 2 0R
ENTERPRISE
Site2Site 120% 45% 15%
5% 65%
20% 0% 0%
0%Overall ROI = 19% Utilisation of £m Database assets.
Batch Processes
OLTP Web
Dev/QA Data Warehouse
ENTERPRISE
4500
Sun
SunENTERPRISE
450
Ultra
ENTERPRISE
4500
Sun
Sun 2 2 0R
ENTERPRISE
![Page 5: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/5.jpg)
5
Scenario 2003
Factors:• Cope with growth• Respond better to Project requirements• Consolidate databases (and hence data)• Better ROI• Maintain BCP• Improve manageability
![Page 6: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/6.jpg)
6
Scenario 2003
Possible Apps/Database Solutions:
• Buy one mega (high end) SMP server
• Buy smaller servers and create a “grid”
![Page 7: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/7.jpg)
7
Grid Solution
Solutions:• Consolidate Storage to Network
Attached• Consolidate Application Platform
(Java)• Consolidate Database Platform (Oracle
10 RAC)
![Page 8: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/8.jpg)
8
Grid Solution
RAC SIG 2004
Contact Vendors
Set Criteria
Trial PlanInfrastructure
Learning
Business Plan
Trials Results More Plans
PurchaseGrid 2005
Trials
![Page 9: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/9.jpg)
9
Grid Solution
Problems• Business Continuity• Capacity
• New Projects• Business Growth
• Supportability• Maintenance
• Return On Investment
Application Servers
Database Servers+Storage
![Page 10: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/10.jpg)
10
Grid Solution
Application Servers
Database Servers
Storage
![Page 11: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/11.jpg)
11
Grid Solution
Application Servers
Database Servers
Storage
![Page 12: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/12.jpg)
12
Grid Solution
Application Servers
Database Servers
Storage
Dev/QANon Essential
Failover
![Page 13: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/13.jpg)
13
Grid Solution
Grid Solution:
• Application server grid
• Storage grid
• Site grid
• Database grid
![Page 14: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/14.jpg)
14
Grid Solution
• Aiming for ROI > 70%
• Dynamic resource allocation
• Projects pay for capacity, not hardware
• Lower cost for capacity
• Dev/Qa more realistic
• Easier maintenance
![Page 15: Shahid Mohammed EME Database Team Manager July 21, 2006](https://reader030.vdocuments.us/reader030/viewer/2022020921/56649cec5503460f949b9671/html5/thumbnails/15.jpg)
15
Grid Solution
End