1 / 61

SQL Server 2008 R2

Day1, SQL Server 2008 R2 Overview. SQL Server 2008 R2.

nirav
Download Presentation

SQL Server 2008 R2

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

  2. Agenda • What‘s New Overview 25‘ • SQL Server 2008 R2 Scalability 10‘ • BI Overview 25‘

  3. New in SQL Server 2008 R2

  4. * ~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

  5. SysPrep

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

  7. Application and Multiserver Management

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

  9. Multi-Server Management DO NOT ERASE!

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

  11. Measure Data Visualization CPU Utilization Storage Utilization

  12. Health State Visualization Dashboard List View Detail View

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

  14. SQL Server StreamInsight

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

  16. 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.)

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

  18. 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)

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

  20. SQL Server Scalability New Max Specs TPC Benchmarks

  21. 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?

  22. Top statistics for SQL Server

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

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

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

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

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

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

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

  30. Demo Session Tomorrow

  31. Master Data Services

  32. 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?

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

  34. MDS Capabilities

  35. Stewardship Portal Data Steward CrUD experience Master Data Administration Modeling Model Documentation Import & Export

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

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

  38. PowerPivot

  39. Microsoft Confidential—Preliminary Information Subject to Change Add-in for Excel 2010

  40. Microsoft Confidential—Preliminary Information Subject to Change Import From Many Data Sources

  41. Microsoft Confidential—Preliminary Information Subject to Change Import Many Rows

  42. Microsoft Confidential—Preliminary Information Subject to Change Use Standard Excel Functions

  43. Microsoft Confidential—Preliminary Information Subject to Change Use Standard Excel Formulas … plus some others

  44. Microsoft Confidential—Preliminary Information Subject to Change Import Data Feeds from Reports

  45. Microsoft Confidential—Preliminary Information Subject to Change Build PivotTables

  46. Microsoft Confidential—Preliminary Information Subject to Change Relationships Detected

  47. Microsoft Confidential—Preliminary Information Subject to Change Analytic Application Created

  48. Microsoft Confidential—Preliminary Information Subject to Change Analytic Application Created …

  49. Share with the rest of the Team

  50. Microsoft Confidential—Preliminary Information Subject to Change … and Published …

More Related