《DAT201企业中的SQLServerSQLServerintheenterprise.ppt》由会员分享，可在线阅读，更多相关《DAT201企业中的SQLServerSQLServerintheenterprise.ppt（36页珍藏版）》请在三一文库上搜索。
1、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 Overvi
2、ew,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 Minin
3、g,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 W
4、indows 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 Intero
5、perability 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 &
6、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 Studi
7、o 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 S
8、erver 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,To
9、p 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
10、 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
11、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 mig
12、ration 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
13、 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
14、 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
15、 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
16、, 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, c
17、omplex 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 ret
18、ail 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 Y
19、in 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 http:/ You will see us at PASS & TechEd Drive enterprise requi
20、rements 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
21、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,Larg
22、est 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 L
23、andscape 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 im
24、plement 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 an
25、d 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 -
26、 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, et
27、c. 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 (N
28、M) 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 lo
29、gic 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 Structu
30、re 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
31、 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 http:/ or search for KT on http:
32、/ 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 mi
33、rroring 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 enterpri
34、se-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 arou
35、nd 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 programmin
36、g 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 p
37、ass-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
38、 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
39、 Warehouse End-to-end use of SQL Server BI, DW & AS cubes Moved relational DW to SQL Server 2005 on June CTP First went live with SQL Server Integration Services in 2004 Loading Data from mostly Oracle sources Workload/Architecture 2 TB sales & inventory data warehouse on SQL Server 2000 Currently h
40、olds 3 years of transactions, will build up to 5 years SSIS using Slowly Changing Dimension transforms & lookups SS2005 Reporting Services used for primary reporting AS2005 Data Mining prediction using Decision Trees AS2K OLAP: Store sales/inventory, Distribution Center inventory Key Dim: Store, Ite
41、m, Time, Demographic, Buyer, Vendor, Customer DB Platform Windows Server 2003 64-bit HP Superdome w/20 CPU partition for DW, 20 TB EMC SAN,Barnes & Noble Retail DW Production Environment,Barnes & Noble Retail DW Data Warehouse Architecture,Oracle IMM database,Oracle SRS database,Sales,IS,Staging dat
42、abase,Relational data warehouse,IS,Store inventory,Distr. Center inventory,Strategy,Inventory deltas,Dimension Updates,POS transactions,Proclarity interactive reports,Reporting Services reports,Inserts / Updates,Live on SS2005!,Question & Answers,Related Session,DAT100 微软的数据平台构想 DAT313 SQL Server 永不停顿技术：构架稳定，可恢复和可靠系统的最佳实践 DAT323 微软新武器挑战数据的价值极限 DAT414 SQL Server 永不停顿技术：针对人为错误的灾难恢复策略 DAT330 快速简便地从 Oracle，Sybase 迁移到 SQL Server DAT211 SQL Server 永不停顿技术：选择正确的高可用性解决方案 DAT321 端到端商业智能 DAT201 企业中的 SQL Server,