1 / 17

SQL Server Update – May 2010

SQL Server Update – May 2010. Gavin Payne http://blog.gavinpayneuk.com twitter: @GavinPayneUK. Presentation Summary. SQL Server 2008 R2 will be available in May SQL Azure is now available and gaining credibility SQL Server is now scaling massively. Recent Industry Observations from MSFT.

oberon
Download Presentation

SQL Server Update – May 2010

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. SQL Server Update – May 2010 Gavin Paynehttp://blog.gavinpayneuk.com twitter: @GavinPayneUK

  2. Presentation Summary • SQL Server 2008 R2 will be available in May • SQL Azure is now available and gaining credibility • SQL Server is now scaling massively

  3. Recent Industry Observations from MSFT • Current Business TrendsGlobalisation – 24/7 and distributed workloadsCompliance – Information handling under scrutinyBusiness Intelligence – Covered on a further slideAgility – Change, acquisition and mergers now common • Current Technology TrendsVirtualisation– The biggest request of Microsoft right nowCloud– Bleeding edge adoption building concept confidenceHardware– Nehalem technology, 8-core CPU, SSD

  4. SQL Server 2008 R2 – What’s New? Highlights • Client-side Features PowerPivot– Self-service BI through Excel • Server-side FeaturesEnhanced Hyper-V support – virtualisation enablerDatacenter edition – delivering massive scalabilityEnhanced compression – operational I/O reducerSysprep support – simplifying implementation

  5. Why Client-side BI Now? • In the economic downturn BI was a growth market • Marketplaces and their data were changing by the hour • End-users wanted to analyse and report in real time • Data warehouses refreshed too infrequently • And were owned, defined and controlled by IT • Solution – self-service BI tools which IT can still manage

  6. SQL Server 2008 R2 – What’s Changed? Two notable changes in R2: • LicensingEnterprise and Datacenter editions align with Windows- VM usage rights changed • Backup Compression Now available in Standard Edition- Game changer for DBAs and 3rd party backup compression providers

  7. SQL Server 2008 R2 – Product Breadth Reminder of what now comes in the SQL Server box:

  8. SQL Server 2008 R2 Parallel Data Warehouse • Appliance format massive scale data warehouse • Sold with specific hardware as a complete solution • Scales to hundreds of TBs • Deploys multiple centrally controlled database nodes • SQL Server Fast Track methodology for smaller DWs

  9. SQL Azure • Cloud-based SQL Server • Relational database to compliment Windows Azure • Designed to mirror SQL Server 2008’s core functionality • At a price point which cannot be ignored for very long

  10. SQL Azure • Launched in February 2010 • Already a small but notable and increasing user base • Currently aimed at “department sized” applications • 1GB and 10GB offerings today • Designed for HA but no database backup facility yet

  11. SQL Azure • Microsoft aim for Service Updates every 8 weeks • Due soon are:Reporting services and BI functions Spatial data types 50GB database option • Unlike other vendors, Microsoft already have the functionality written, they just need to re-deploy it to the cloud

  12. SQL Azure • Microsoft’s long term aim is to “make cloud irrelevant” • Where your code and data are hosted is based on today’s business requirements, could change at midday • However, in the medium term cloud and on-premise versions of SQL Server may have parallel functionality roadmaps

  13. SQL Server Scalability • SQL Server is now the most demanding application to use Windows Server – everything else scales out • SQL Server can and is now powering the world’s most demanding business application infrastructures • Microsoft’s SQLCAT team focus on delivering these platforms - http://sqlcat.com/ • Their web site is loaded with best practice

  14. SQL Server Scalability In Depth • Windows Enterprise and Datacenter editions can deliver massive computing power to SQL Server • 128 CPU cores, 2TB memory, 200+ TB OLTP databases • Intel’s latest Nehalem CPUs are powering a revolution in X64 server capability • Itanium support has been dropped – no longer required

  15. SQL Server Scalability Tips From The Field • Hyper-threading is back and recommended • NUMA boundaries will become part of daily life • NIC activity is now a workload of its own • Disk alignment maybe simple but is a huge quick win • Centralised SQL Server management will be essential as databases outnumber DBAs

  16. Solid State Devices • SSDs have now arrived, expensive but mainstream • Not all SSDs are the same, some using SATA • FusionIO appearing as a popular brand • Very low latency, very high I/O rates • Not a cure for badly designed schemas or SANs, but will no doubt be used as one

  17. Conclusion • SQL Server 2008 R2 has been released • Some good changes for those motivated to use them • SQL Azure has made a good entrance and will become a no-brainer for some future deployments • Virtualisation and consolidation are today’s biggest activities within IT – SQL Server can be very efficient • SQL Server can also be very powerful

More Related