Hosted by
Case Study: How the Scotts Company Increase Systems Performance
Jeannie ShimerDirector, Platform ServicesThe Scotts Company
Hosted by
The world’s leading producer and marketer of products for do-it-yourself lawn care and gardening and professional horticulture.
Brand include Scotts, Miracle-Gro, Ortho, Roundup, Osmocote and Hyponex.
Core business (North America- United States & Canada): Consumer Lawns & Growing Media Consumer Gardens & Controls Professional Nursery/Greenhouse
Scotts LawnService (U.S. only) Lawn Care, Tree & Shrub Care, Disease and Pest Control
Europe and Rest-of-world Consumer Lawns, Growing Media, Gardens & Controls Professional Nursery/Greenhouse
The Scotts Company Overview
Hosted by
Major Project Initiatives for 2002 for Scotts
Replacement of all Sun Systems with new Sparc III technology
Upgrade from R/3 4.0B to 4.6C - Production
4.6C European Implementation
Upgrade from BW 2.1C to 3.1C – In process, SAP Ramp-up Program
HR/IS 4.6C on Decoupled System – In Process
EBP 3.5 – SRM Ramp-up Program – In Process
CRM 3.0 – CRM Analyticals – Blueprint Stage
EP 5.0 – Enterprise Portal to support all SAP Systems
EDI Gentran Upgrade
Manugistics Implementation
Hosted by
SAP R/3 Production Environment before migration
2 SUN Enterprise 6500’s. DB 16x16. CI 12x12. Veritas Cluster for
High Availability.
2 SUN Enterprise 4500’s, Application Servers
4 SUN Enterprise 420R’s, Application Servers
13 Total Application Instances
SAP 4.0B 64bit
Oracle 8.1.7.3 64bit
Solaris 8
Gigabyte Backbone
Hosted by
SAP R/3 Production Environment after migration
2 SUN Fire 4800’s. DB 8x16. CI 8x16. Veritas Cluster for High
Availability.
3 SUN Fire V880’s Application Servers
4 SUN Enterprise 420R’s, Application Servers
13 Total application instances
SAP 4.6C, 64Bit
Oracle 8.1.7.3, 64bit
Solaris 8 – Upgrading to Solaris 9 in 1st Qtr 2003.
Gigabyte Backbone
Hosted by
BW Production Environment
1 SUN Fire V880 Server. 8x16. DB/CI on same physical
box. configured as an application server. No HA
2 SUN Fire V880’s, Application Servers.
4 application instances total.
BW 2.1C > 3.1C
Oracle 8.1.7.3 64bit
Solaris 8 – Upgrading to Solaris 9 in 1st Qtr 2003.
Gigabyte backbone
Hosted by
BW 2.1C Upgrade to 3.1C(In Process)
Technical/Functional Upgrade
Separate Upgrade Landscape
3 Month Project – Partner SAP
3.0B Practice Upgrade. 3.1C available mid-November
Global Business Intelligence• Web Based
• Enhanced Reporting Options
• Foundation for Collaborative solutions E- Procurement (SRM) Mobile Sales and Analytics (CRM)
Activation of New Business Content
Hosted by
SAP 4.0B to 4.6C Upgrade Technical Upgrade with limited new functionality
5 Month Project – Partners; SAP, Rapidign, and Sun
Separate Upgrade Landscape
Upgrade process was 14 hours for 1.2TB DB. We performed 6 practice
upgrades. We reduced overall upgrade time from avg of 30 hours. Adding
additional Indexes to large tables prior helped.
Performance – 20% additional overhead with 4.6C on old Sun. Migration to
new Sun Infrastructure reduced load from 65% to 35% utilization of
systems.
Increased performance in DB and Transactional Response times. Avg
Response time is <1.0, decrease in I/0 waits. Users noticed improvements.
Hosted by
SAP 4.0B to 4.6C Upgrade
SAP GUI was upgraded to 6.20. Check PC hardware. Memory was
added to many machines to support.
Security Model was a total rewrite.
Ensure adequate storage for upgrade. Do not use SAP
recommendation, go beyond.
Food – Provide a wide variety for both Technical and Functional
areas. In certain cases take personal requests.