620 likes | 764 Vues
Day1, SQL Server 2008 R2 Overview. SQL Server 2008 R2.
E N D
Day1, SQL Server 2008 R2 Overview SQL Server 2008 R2 Mit SQL Server 2008 R2 kommeneinigeneue Features. In dieser Session gebenwirIhneneinenÜberblickübersämtlicheNeuerungenimBereichSkalierbarkeit, Verwaltbarkeit, Self Service Business Intelligence mitPowerPivot, sowieVerbesserungen in den Reporting Services. SieerhaltenebenfallseinenÜberblicküber die neuenEditionen und KomponentenwieStreamInsight (Complex Event Processing) sowie Master Data Services. Overview Michael Epprecht Microsoft (Schweiz) GmbH michael.epprecht@microsoft.com Roger Breu Microsoft (Schweiz) GmbH roger.breu@microsoft.com
Agenda • What‘s New Overview 25‘ • SQL Server 2008 R2 Scalability 10‘ • BI Overview 25‘
* ~Data rate: <5000 events/sec, ~Latency: >5 s, embedded in ISV Apps/on the Edge ** ~Data rate: >5000 events/sec, ~Latency: <5 s, DataCenter Server Setups *** Procs are physical sockets Capabilities by Core Editions
Similar to Windows SysPrep Difference from Windows SysPrep: We do not fully configure SQL Server and then remove the configuration settings during Windows SysPrep SysPrep supported for Relational Engine and Reporting Services Rolling Upgrades for Service Packs since SQL Server 2008 SysPrep in SQL Server 2008 R2
Database Management Trends Underutilized hardware • Customer Profiles • Hundreds of small databases • Most DBs have one data file • Average DB size < 4 GB • Reactive management – fix it when get a phone call • Difficult for developers and DBAs to manage app lifecycle • Time to problem resolution keeps shrinking Hardware capacity Number of databases Overburdened administrators Number of DBAs 2000 Future 2010
Multi-Server Management DO NOT ERASE!
The SQL Server Utility Managed Instances SQL02 • Central point of reasoning for multi-server management • Simple to setup and use - a key advantage over competitors SQL01 SQL03 SQL04 DBA SQL05 UCP Management Studio
Measure Data Visualization CPU Utilization Storage Utilization
Health State Visualization Dashboard List View Detail View
DEVELOP DEPLOY MANAGE SQL Server Management Studio 5 Handoff to Dev 6 3 Make Changes, Create policies SQL Server Management Studio DBA 9 4 Deploy / Upgrade DAC 8 Reverse Engineer DAC Hand-off to DBA Visual Studio 2010 Create Control Point, Control Point DBA Control Point 1 Compile + Build DBA 7 2 Enroll Instances, Register DACs Developer Finance Finance Managed Server Group .dacpac Managed Server Group
What is CEP? Event Complex Event Processing (CEP) is the continuous and incremental processing of event streams from multiple sources based on declarative query and pattern specifications with near-zero latency. request output stream input stream response
Scenarios for Event Processing StreamInsight Scenarios Relational Database Applications Months Days Operational Analytics Applications, e.g., Logistics, etc. Minutes • Data Warehousing Applications Latency Web Analytics Applications Seconds Manufacturing Applications 100 ms Monitoring Applications • Financial Trading Applications < 1ms 0 10 100 1,000 10,000 100,000 ~1million Aggregate Data Rate (Events/sec.)
Overview: CEP Platform from Microsoft Event Event Event Event Event Event Event Event Event Development experience with .NET, C#, LINQ and Visual Studio 2008 CEP Application Development CEP platform from Microsoft to build event-driven applications Event targets Event sources Event-driven applications are fundamentally different from traditional database applications: queries are continuous, consume and produce streams, and compute results incrementally CEP Engine Standing Queries Output Adapters Input Adapters Flexible adapter SDK with high performance to connect to different event sources and sinks The CEP platform does the heavy lifting for you to deal with temporal characteristics of event stream data Static reference data
Microsoft’s CEP Solution Data Sources, Operations, Assets, Feeds, Sensors, Devices Input Data Streams OutputData Streams Input Data Streams CEP Engine Monitor & Record Mine & Design Manage & Benefit f(x) f'(x) g(y) h(x,y) Results Deploy History Operational Data Store & Archive CEP Engine f(x) g(y) f'(x) h(x,y)
Lightweight embedded engine StreamInsight is available as a set of DLLs StreamInsight can be included into your applications Low footprint, small overhead Facilitates deployments close to the data source StreamInsight Windows service Runs the engine as a Windows service Applications can share incoming streams Well-suited for more centralized deployments Installation Small, lightweight MSI Installs in 2 minutes StreamInsight Deployment
SQL Server Scalability New Max Specs TPC Benchmarks
Single-system scalability Improved performance (parallelization) Industry trend – soon industry standard servers with 8CPU will have 128 logical processors Increased flexibility in deployment (Single vs. Multiple Instance) We have customers who really need to scale up! Why scale up?
Large Scale customer implementations 1 petabyte 1 million transactions per day Astronomical database mapping the sky Global Online Gaming Company Deploying 100 Terabytes database 5000 concurrent users PLM Software supports 5,000 Users with SQL Server 2008; 50 % data compression 2.5 billion articles RSS Aggregator NewsGator Manages 2.5 Billion Articles with SQL Server 2008; high availability with database mirroring > 1 petabyte Avatar’s digital image library built on SQL Server
Benefit from Scalable and Predictable Performance for Physical Servers • Improved scalability with up to 256 logical processors (determined by operating system maximum) • Support for memory in excess of 2TB • Support for Solid State disks • Improved I/O performance with UCS-2 Unicode and non-Unicode data compression • Faster, smaller backups with backup compression • Resource utilization management with Resource Governor and Windows System Resource Manager
SQL Server performance demonstrated in TPC–E benchmarks TPC-E most accurately reflects typical workloads World record TPC-E benchmark, November 2009 Support for up to 256 CPUs with SQL Server 2008 R2 Datacenter Edition * Source: www.tpc.org, As of November 23, 2009
A new world-record TPC-E benchmark result Unisys ES7000 Model 7600R Enterprise Server Windows Server 2008 R2/SQL Server 2008 R2 DC x64 performance record of 2,012 tpsE (transactions per second for the TPC-E benchmark) 96-core Xeon platform same Unisys server achieved 102,778 QphH (queries per hour) on the TPC-H 3TB benchmark, showing data warehousing performance 70 percent higher than the previous record on Windows. A Microsoft Dynamics CRM benchmark run on IBM System x3650 M2 servers with Intel Solid State Drives demonstrated 20,000 concurrent users across 20 xRM applications on Microsoft Dynamics CRM with an average response time of 0.10 seconds. TPC Benchmarks
Unisys SQL PowerRack • Extremely balanced architecture • Intel Xeon 7400 Series 6-Core or 4-core processors • Up to 16 sockets / 96 cores • Up to 1TB memory • Up to 56 PCIe slots • Truly useable hot-plug PCIe • >99.995% availability; Enterprise-class RAS • ES7000 is integrated with a powerful DSI3600 disk SAN Storage subsystem • Up to 3-GB/sec, and 250,000 IOPS per unit • up to 10 units per PowerRack • Windows Server 2008R2/SQL Server 2008 R2
New Fast Track Data Warehouse 3.0 References will be anounced… • Software: • SQL Server 2008/R2 Enterprise • Windows Server 2008/R2 • Configuration guidelines: • Physical table structures • Indexes • Compression • SQL Server settings • Windows Server settings • Loading • Hardware: • Tight specifications for servers, storage and networking • ‘Per core’ building block
SQL Server Parallel Data WarehouseA data warehouse appliance with massive scalability • High Scalability from 10s to 100s of TB • High scale through Massively Parallel Processing (MPP) system • Choice of hardware vendor • Low cost through commodity hardware • Deep integration with Microsoft BI
Wikipedia Master data management (MDM) comprises a set of processes and tools that consistently defines and manages the non-transactional data entities of an organization. What is Master Data Management?
Master Data Challenges Conflicting Views of Product, Customer Location, etc No single, trusted source of the truth No dimension maintenance capability Inability to enforce data stewardship processes No system to maintain attributes Multiple stakeholders for the same record Inconsistencies cost – mistakes, incorrect reports
Stewardship Portal Data Steward CrUD experience Master Data Administration Modeling Model Documentation Import & Export
Stewardship Process MDS Item Create ERP 1 Stewardship Portal Create Notification Attribute Change Master Data Services Layer Approval Request Change Notification ERP 2 Master Data Database Layer Data Warehouse Bulk Extract
Master Data Platform MDS Opportunities • Create Domain-specific models • Business model consulting • Extend platform into existing processes Any Domain Model Deployment API Supports all Operations
Microsoft Confidential—Preliminary Information Subject to Change Add-in for Excel 2010
Microsoft Confidential—Preliminary Information Subject to Change Import From Many Data Sources
Microsoft Confidential—Preliminary Information Subject to Change Import Many Rows
Microsoft Confidential—Preliminary Information Subject to Change Use Standard Excel Functions
Microsoft Confidential—Preliminary Information Subject to Change Use Standard Excel Formulas … plus some others
Microsoft Confidential—Preliminary Information Subject to Change Import Data Feeds from Reports
Microsoft Confidential—Preliminary Information Subject to Change Build PivotTables
Microsoft Confidential—Preliminary Information Subject to Change Relationships Detected
Microsoft Confidential—Preliminary Information Subject to Change Analytic Application Created
Microsoft Confidential—Preliminary Information Subject to Change Analytic Application Created …
Microsoft Confidential—Preliminary Information Subject to Change … and Published …