1 / 15

Danfoss IT and MS SQL

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

verdad
Download Presentation

Danfoss IT and MS SQL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. 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

  3. 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

  4. Organization – Danfoss IT

  5. Organization – Danfoss IT - Server

  6. 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

  7. 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…..

  8. 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

  9. Danfoss IT Server – fact sheet

  10. 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

  11. 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

  12. 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

  13. 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

  14. 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

  15. Questions ? DN@Danfoss.com

More Related