DAT201企业中的SQLServerSQLServerinth.ppt

DAT201 SQL Server in the Enterprise 企业中的 SQL Server,Agenda What we will cover,SQL Server Overview Feature Highlights 技术要点 SQL Server Momentum in the Enterprise 企業使用趨勢 Enterprise Customer Case Studies (企业用户案例介绍) Korea Telecom 韩国电信 NASDAQ 纳斯达克股票交易市场 Barnes & Noble Questions & Answers,SQL Server Overview,SQL Server Generations History of Innovation,SQL Server 7.0,SQL Server 2005,SQL Server 2000,Lowest TCO Best Developer Platform,Reliability and Security Integrated Business Intelligence,High availability Security Developer productivity Native XML First to include Enterprise ETL and Deep Data Mining,Performance, scalability focus XML support First to include Notification First to include Data Mining & Reporting,Re-architecture of relational server Extensive auto resource management First to include OLAP & ETL,Cross-release objectives,SQL Server 6.0/6.5,Differentiation from Sybase SQL Server Windows integration First to include Replication,1st Generation,2nd Generation,3rd Generation,AlwaysOn: High Availability for enterprise applications Key security and performance features Focus on self manageability and optimization,Integration with Visual Studio and .NET Native XML technology Interoperability via Web Services,Real time decision making: reporting, data mining Rich client and SharePoint solutions Comprehensive ETL solution: up to 600% faster,Express,Standard,Enterprise,Fastest way for developers to learn, build & deploy simple data driven applications,Complete data management & analysis platform for medium businesses and large departments,Fully integrated data management and analysis platform for business critical enterprise applications,Workgroup,Easiest to use & most affordable database solution for smaller departments & growing businesses,2 CPU 3 GB RAM Management Studio Import/Export Limited Replication Publishing Back-up Log-shipping Reporting Server,SQL Server Momentum in the Enterprise,The Database Market Unit Share, Overall and Enterprise,Source:,SQL Server in the Enterprise,Winter Corp Top Ten 2005,Survey of largest databases in the world (Aug 2005) 43 SQL Server entries over 1 TB, 25% of all entries 11 TB+ entries on SQL Server 2005 live by launch 6 winners in Top Ten categories for All Platforms 3rd largest OLTP db by rows, 50 billion rows & 7.8 TB 8th largest DW database in the world, 19.5 TB of data Won & dominated all Windows DB size categories,Top Scale SQL Server Mission Critical OLTP Apps,7.8 TB & 50B rows in single DB, Winter Corp winner 50 TB+ of data total,13,000 customer service reps,GLOSS financial system, Sybase migration 2 TB OLTP instance, 2000 stored procedures,Runs Peoplesoft ERP Suite on SQL Server High intensity OLTP,1000+ TPS application, 1 TB of data, Oracle migration Real-time manufacturing app, runs all WD output,Full range of telecom systems, developed in VS.Net Terabytes of data, Several 64-way HP Superdomes,US Dept of Agriculture runs PeopleSoft ERP Suite 75K employees, 500 GB database, high concurrency,Top Scale SQL Server TB+ Data Warehouse & BI,20 TB European digital payment archive system Unisys Payments Services Archive,13 TB Geospatial DW, to reach 25 TB 4 TB data mart, 2500 field offices, 55 TB storage,1.5 TB DW, plus multiple OLAP data marts Data feeds from JD Edwards ERP system,1 TB DW, Informix migration Heavy concurrent usage on OLAP,1.7 TB DW, 2900 DW users ramping up to 5000 Runs on HP Superdome,6 TB Call Detail Record (CDR) DW, OLAP usage 20-way HP Superdome,Top Scale SQL Server Major SAP Deployments,8 TB SAP R/3, 1500 conc users, Unisys 16-way 3 TB Business Warehouse system,$23 Bil photo products company Worldwide SAP implementation, now on SS2005,38,000 employees, 2 x 32-way Unisys ES7000 1 TB+ db, 5 TB Storage, 2000 concurrent users,Shell Lubricants (+ Penzoil/Quaker State) 2 TB database, 1800 conc user + SQL Server BI,Top computer retailer in USA .5 TB in SAP, SQL Server also as strategic BI platform,China Light & Power runs mySAP suite on SS2005 10 TB of total data, 500 concurrent users,Top Scale SQL Server 2005 Mission Critical Apps Live Today on SQL Server 2005,Runs airline scheduling services operations High intensity OLTP on SQL Server 2005,Fixed Income Trading System running on SS2005 30% performance increase, 1,000 trades / second,Market Data Dissemination System, runs on SS2005 5K transactions / second, 100K queries / day,Web hosted solution Managing 7 million transactions per day,2nd largest Shipping Co in the word, 160 countries 15 Bil transactions per year, 5 TB of data,Worlds largest online grocery retailer Runs web-site on SS2005 and VS.Net 2005,Top SQL Server 2005 TB+ Data Warehouse & BI Live Today on SQL Server 2005,5.3 TB Credit Card DW, 5 Mil card holders 300 users, OLAP, SSIS, SSRS, Office BSM,4 TB Consumer Packaged Goods (CPG) DW 350 users, complex relational query, SSIS & SSRS,5 TB Retail Data Warehouse on HP Superdome Uses SQL Server OLAP, SSIS, SSRS,2 TB DW, originally migrated from Informix 300 users, complex query, OLAP & Data Mining,6 TB retail data warehouse from 700 stores, OLAP, RS 15 TB total across multiple instances,5 TB retail DW, 10 TB storage, data from 1000 stores Largest retailer in African continent, OLAP, RS, DTS,SQL Server Customer Advisory Team,Part of SQL Server product team Senior DB architects each with 10+ years of enterprise development and deployment experience World-wide coverage US, EMEA, Asia Howard Yin APAC Nicholas Dritsas (BI) APAC Ex member - Prakash Sundaresan - APAC Work with largest, most complex SQL Server projects worldwide Architecture and design reviews Project risk mitigation Create and share best practices with community /sqlcat You will see us at PASS & TechEd Drive enterprise requirements back into product,SQL Server Customer Advisory Team,Engagement Profile Last year 10-20 TB databases; 50,000+ transactions/sec; AS with 50+ GBs of cube sizes Currently 20-100 TB databases; 100,000+ transaction/sec; AS with 100+ GBs of cube sizes; 10,000+ reporting service users Sample Active Engagements Major high-speed railway operation environment with 0 downtime and guaranteed execution time Core banking environment with extremely high availability requirements Major stock exchange trading platform,Korean Telecom Enterprise Case Study 韩国电信案例介绍,KT - Customer Profile and Situation,Largest TelCo in South Korea 26 million+ customers residential and business 65,000 employees Diverse product set: Fixed-line, IP, wireless telephony; Wired and wireless internet Web storage, Integrated e-business, Next-generation Network (NGN) Changing Customer Environment Growing Competition Changing Landscape of Services: Wireless, Internet, End-customer (consumer) expects simple, integrated offerings Create new revenue streams, roll out services quickly and reliably Pain-points with previously existing Operations Support System (OSS) Decentralized one system per province Not flexible hard to implement new functions Expensive licensing, maintenance, development costs,KT - Solution,Build a New OSS (NeOSS) solution from scratch Centralize and eliminate per-province systems Modern service-oriented architecture (SOA) Built using a modern application platform: Windows Server 2003 (DataCenter and Enterprise Editions) SQL Server 2000 Enterprise Edition (64-bit) Biztalk Server 2004 Visual Studio.Net 2003 Operations Manager 2005 Windows Mobile 2003 First tier-1 Telco to run core OSS system on 100% Microsoft platform,KT NeOSS Modules,Service Ordering (SO) Integrated service ordering function - manages workflows amongst the network domain and controls Service Assurance (SA) Integrated trouble-ticket reception and processing for customer complaints Facility Management (FM) Manages facility information of all domains: access network, data network, transmission network, switching network, etc. Access Domain Manager (ADM) Service provisioning and maintenance Workforce Management (WM) Schedules work plans, dispatches necessary information to PDAs for repair/installation field engineers Service Level Agreement (SLA) Handles the quality guarantees for various services Network Management (NM) Manages network components,KT NeOSS - Architecture,KT NeOSS Interesting System Facts,Data Size 28 TB of SAN storage 15 TB of system data across all modules Processing 280,000 orders / day 150 million SQL transactions / day 20,000 peak SQL transactions / sec across all modules Logic Application logic split over mid-tier and database tier Close to 10,000 stored procedures total DB Hardware Platform 4 pairs of 64-way, 64-bit, 256 GB RAM HP Superdomes Using MSCS for High-availability Several other pairs of 32-way 64-bit 256 HP Superdomes for smaller modules and Biztalk Server,KT Project Structure and Benefits,Project Structure and Duration Started in January 2003 100 KT engineers, 200 3rd-party system integrator (SI), 20 Microsoft Consulting Services (MCS) resources Local resources, with help from Singapore and Redmond as necessary Development completed in 18 months Phased roll-out across in 6 stages over a period of 12 months Benefits Single, unified OSS system greater agility, more flexibility and reduced management overhead Cost savings of around US$90 million / year Now looking at Data Warehouse solution for Business Insight For more details, see /CustomerEvidence/Common/FileOpen.aspx?FileName=7718_KT_SQL_Server_2000_Case_Study.doc or search for KT on /sql/prodinfo/casestudies,NASDAQ Enterprise Case Study 纳斯达克案例介绍,Enterprise availability Scalability to handle 8 million new rows of data per day Lower total cost of ownership Real-time reporting Developer agility,MDDS: Market Data Dissemination System 5K txs / second, 100K queries / day Running on SQL Server 2005 with database mirroring for high availability,Largest US electronic stock market Replacing aging Tandem systems Wanted to update system for real-time trade summary, risk management, and broker clearing,“The fact that we can move mission critical applications from Tandem to SQL Server 2005 proves that it is enterprise-grade.”,Ken Richmond, Vice President for Software Engineering, NASDAQ,Can You Get Mainframe-like Availability And Low TCO?,NASDAQ Market Data Feed System Customer & Project Profile,Scenario/Business Market Data feed system key component of NASDAQ revenue Part of Super Montage set of services around trading data Data directly from trading system, used for order-display app (TotalView) 90,000 paying feeds (vendors or brokerage houses) Migrated from in-memory design on Tandem, live since July 2002 In 2004 moved second quote system to SQL Server (NQDS) Achieved great cost savings and programming versatility Workload/Architecture 5000-8000 quotes/second design criteria (each a stored proc) 32K inserts design criteria, 12-14K in recent peaks Increasingly more ambitious latency goals (initial goal: 1 sec, now 200 ms) 50-100 GB of data, flushed daily, archived for 14-days 20 million records pass-through/day typical. 6 mil for NQDS. 3-tier processing: app servers DB servers app servers All data passes through both DB systems Scale-out app servers partitioned by security DB Platform: SS2000 on WS2000 on Dell 4-way,NASDAQ SuperMontage Feeds System Architecture,NASDAQ SuperMontage TotalView system architecture (previously named PrimeFeed),Barnes & Noble Enterprise Case Study 连锁书店数据仓库案例介绍,Barnes & Noble Retail DW Customer & Project Profile,Live on SS2005!,Scenario/Business Largest bookseller in the USA, 850 stores, plus online 40K employees, 1.5 mil titles across all stores Retail Data Warehouse End-to-end use of SQL Server BI, DW & AS cubes Moved relational DW to SQL Server 2005 on June CT