150 likes | 437 Views
Danfoss IT and MS SQL. Organization – Danfoss Segments Danfoss and IT – governance Danfoss IT Danfoss IT Server CV – Dieter Nicolaisen Rules & ethics Danfoss IT server - fact sheet Danfoss IT and MS SQL-server History Oracle/MS SQL server at Danfoss MS SQL Status – today
E N D
Danfoss IT and MS SQL • Organization – • Danfoss Segments • Danfoss and IT – governance • Danfoss IT • Danfoss IT Server • CV – Dieter Nicolaisen • Rules & ethics • Danfoss IT server - fact sheet • Danfoss IT and MS SQL-server • History Oracle/MS SQL server at Danfoss • MS SQL Status – today • MS SQL SAP R/3 conversions - soon • MS SQL future projects • Benefits for Danfoss IT • Questions
Organization – Danfoss Segments The Danfoss Group, 17.500 employees worldwide Executive Committee Hans Kirk Executive Vice President & COO Jørgen M. Clausen President & CEO Ole Steen Andersen Executive Vice President & CFO Corporate Functions Danfoss Services Refrigeration & Air Conditioning Heating & Water Motion Controls Refrigeration and A/C Controls • Commercial Compressors • Household Compressors • Appliance Controls • Industrial Controls Comfort Controls • Building Controls • Burner Components • Flow • Water Controls Drives • Gearmotors • Marine Systems
Organization – Danfoss and IT governance Strategy, Demand and Architecture What, When & Why Supply How Executive Committee EC+ Danfoss IT Enterprise Program Management Office IT Ownership Group ITOG User Segment IT Architecture Team Local IT Application Architecture Team Technical Architecture Team Architecture Review Board TAG-IT IT Suppliers
CV – Dieter Nicolaisen,Server & Technique Manager • Born 1955, Tønder • EDP assistant 1975, Odense • Military madness 1976, Odense • NESA, Copenhagen • Programmer – mainframe 1977 • Systemsprogrammer – mainframe 1979 • Danfoss, Nordborg • System consultant – 1983 • Systems programmer – 1985 • IT Manager – Mainframe & Mail – 1994 • + File-server department • + SAP Basis department • Contact: DN@Danfoss.com +45 74883668 • Retireing from Danfoss approx 2020
Rules & Ethics • Think global – act local • Need for speed – but still professional IT • Just enough – just in time • Business driven – but still room for experiments • Service driven – but still yearly COMPASS benchmarking • Planning -> Communicating -> Changing -> Plann…..
Danfoss IT Server – fact sheet • Nordborg Campus: 2 Datacenters, 1 Center for Backup-equipment • Supporting 2 Mainframes, 23 Unix servers and 349 INTEL servers • SAN infrastucture in place, Brocade12000 Director connecting: • 2x MA8000 6,6 TB for file-servers • 2x EMC Symmetrix 6,0 TB for SAP R/3 + file/exchange • 2x HDS 9970 4,8 TB for Mainframe+file-servers • Enterprise servers (MS cluster), backup equipment • MS ActiveDirectory in place • MS Exchange on 104 servers worldwide connecting 10290 mailboxes • 27 SAP R/2 systems mainframe, 64 SAP R/3 systems on INTEL(soon) • 3x TSM Backupsystem, 79 TB of data, 146 mio files, 434 clients • Library:2xSTK9310,IBM3494,ESL9326 , 15000 medias, 21 drives • Total disk on all servers approx. 31,4 TB
History Oracle/MS SQL server • 1994 or earlier: • OS2/Oracle, AIX/Oracle • About 1997: • WebBusinessApplication/Oracle, HP-UX/Oracle, NT3.51/Oracle • SAP R/3 HR implementation NT4/Oracle • About 2000: • No Oracle support longer in Danfoss IT development • About 2001: • Converting R3: NT4/Oracle to W2K/SQL2000 • New installations W2K/SQL2000 • About 2002: • Converting SQL7.0 to SQL2000, including consolidations to SQL-hotel • WebBusinessApplication/Oracle – shutdown
MS SQL status – today • Intranet: • old SQL 7.0: 1 MS cluster 11 GB, 123 databases • old SQL 7.0: SingleServer 5 GB, 34 databases • new SQL2000: 1 MS cluster 10 GB, 16 databases • Extranet: • Old SQL 7.0: 1 MS cluster 10 GB, 8 databases • New SQL2000: 1 MS cluster 7 GB, 34 databases • ADAP-Kool-net: • SQL 2000: 1 MS cluster 20 GB, 5 databases estimated to grow to 1 TB • SAP R/3: • MS Cluster/SQL2000: 13 SAP R3 systems • From 20 GB to 80 GB • SingleServer/SQL2000: 27 SAP R3 systems • From 20 GB to 80 GB • Named instance
MS SQL SAP R/3 conversions - soon • HP-UX Oracle R3 system (P08) • From 402 GB Oracle db to 300 GB SQL (700 GB incl 6 testsystems) • Conversion weekend 42 Hours • Current db-server SAPPS 1812, new (1H2003) 2x3400 SAPS • Current MRP-batch 3:18 H, new MRP-batch 1:52 H • Current full backup 15 H, new full backup 2:10 H • New config 2xDL760/8 8GB RAM, 4xDL580/4 4GB RAM • AIX Oracle R3 system (P12) • From 220 GB Oracle db to 160 GB SQL (260 GB incl 2 testsystems) • Conversion weekend 48 Hours • Current average dialog responsetime 1030ms, databasetime 510ms • New average dialog responsetime expected to be 500 ms • New config 2xDL580/4 4GB RAM • In total we will convert 20 Oracle based R3 systems ASAP
MS SQL future projects • MS SQL Hotels for Intranet, Extranet and RemoteMonitoring on SAN infrastructure, Syncron copy and stretched cluster • All new SAP R/3 projects will run MS SQL server, we still have to convert 27 SAP R/2 systems • Converting production-IT Oracle systems to MS SQL server • Waiting for YUKON
Benefits for Danfoss IT • No or reduced Oracle software cost (named users today 4400) • No or reduced Oracle support cost incl. SystemEngineer know-how • Intel and HP ProLiant server = commodity hardware • Intel and Microsoft roadmap for 64Bit Ithanium+ • Reduced hardware service cost compared to Unix • Microsoft is used for ActiveDirectory,FrontOffice and Backoffice • A large number of SystemEngineers available for MS, few for Unix • Danfoss IT Software vendor strategy: SAP & MicroSoft before all others
Questions ? DN@Danfoss.com