for Hosters

for Hosters Samuel Dupas Hosting Technical Specialist Microsoft CEE

Content • SQL Server 2008 for Hosters • Introducing SQL Server 2008 Web Edition • Comparing SQL Server 2008 editions: which one is right for you? • New in SQL Server 2008 : a quick glance at some of the most exciting features • Policy-Based Management • PowerShell • Performance Data Warehouse • Resource Governor • Transparent Data Encryption and All Actions Auditing • Backup Compression • SQL Server 2008 for Hosters: FAQ • HyperV & SQL Server licensing • Migrations and Upgrades • SQL Server Driver for PHP 2005, DPW

Introducing: Enterprise Data Platform Services Reporting Integration Analysis Synch Entity Data Model Pervasive Insight Query Search FILE RDBMS OLAP XML Dynamic Development Mobile and Desktop Server Cloud Beyond Relational “Enabling customers of all sizes to derive value from ALL data, birth through archival”

Introducing: Enterprise Data Platform Enterprise Data Platform • Secure, trusted platform for your data • Optimized and predictable system performance • Productive policy-based management of your infrastructure Dynamic Development Dynamic Development • Accelerate your development with entities • Synchronize your data from anywhere Beyond Relational Pervasive Insight • Integrate all your data in the Enterprise Data Warehouse • Reach all your users with scalable BI platform • Empower every user with actionable insights Pervasive Insight Beyond Relational • Store and consume any type of data • Deliver Location Intelligence within your applications

Introducing SQL Server 2008 Web Edition

Understanding Edition Choices for Hosters Consider Express Edition for simple, low end dedicated hosting • Free solution for relatively simple and small-scale databases in dedicated environments • Full support for data programmability offered in more advanced SKUs, enabling easy upgrade path • Embrace Web Edition for scalability at competitive price point • Achieve competitive price/performance for low-cost shared hosting using Web Edition on shared servers • Provide Express, Web Edition or Enterprise Edition on dedicated boxes as requested by customers • Leverage Enterprise Edition for Advanced Setups and Value Added Services • Utilize performance and maintainability features of Enterprise Edition to fundamentally change management approach and total cost of management • Package enterprise functionality into ‘value add offerings’, upselling to customers for incremental revenue (e.g., business continuity, information protection/PCI, AS)

Reduced Management Cost:Policy based management, multi-server management Manage single instance Security • Reduce management overhead managing groups of servers • Effortlessly ensure standardization and compliance in environment • Easily apply new or modified policies to groups of servers • Flexible framework allows for various management approaches • Define groups with different policies for different uses • Shared vs. dedicated • PCI compliant vs. open • Different execution modes allow proactive enforcement or manual intervention based on logged violations • Reduce surface area • XPCmdShell ==False • RemoteDAC == False • Secure guest/customer policies • Guest permissions • Guest policies • Password policies • Encryption settings • Service pack and patch coverage • PCI compliance Maintenance • Backup file locations • Backup policies • Last successful backup Manage across server pool Performance • Auto shrink for DB • Blocked process thresholds • Max worker threads • Network packet size • DB size

Reduced Management Cost:Improved support for programming common tasks • SQLCMD • Create batch files • Automate multiple scripts C:\>sqlcmd –I Insert.. • Expanded access to management objects from within scripting environment • Unified approach across the entire Microsoft stack • Server Management Objects (SMO) • Manage SQL Server instances from .NET applications and PowerShell • Powershell • Integrated with Windows management scripting

Reduced Management Cost:Monitor with Insight • Improve management and operations • Balance servers • Identify and isolate problematic apps • Improve customer services • Provide detailed account to customers • Help tune customer databases • Improve customer segmentation • Upsell demanding customers to higher allocations • Performance data collection • OS perf indicators • Performance data • Extensible collection • Low overhead • Central repository • Consolidate information • Open interface • Comprehensive reports • Standard reports • Extensible

Predictable Performance:Managing Mixed Workloads with Resource Governor • Resource Management • Allocate resources • Assign logins to workloads • Map workloads to resources • Offer more predictable performance to customers while increasing density • Define limits to prevent run-away queries from affecting the entire shared environment • Reduce likelihood of impacting individual customers • Prioritize workloads based on nature of tasks or customer class • Offer guaranteed level of service • Allow for predictable and limited impact of maintenance tasks, enabling online maintenance Backup Web or other workload Web or other workload Admin Tasks ‘Standard Shared’ ‘Platinum Shared’ Admin Workload NormalWorkload NormalWorkload PriorityWorkload Max CPU 25% Max CPU x% Min Mem 10% Max Mem 20% Max CPU 20% Min CPU 20% Max CPU 50% Admin Pool App Pool 1 App Pool N Priority Pool

Security: Transparent Data Encryption and All Action Auditing Transparent Data Encryption • Use Policy-Based Management, TDE and Auditing features to offer PCI compliance to your customers • Transparent data encryption keeps your customers’ data safe with little incremental management effort and no app changes • Use auditing for proactive security or to identify and analyze any controversial changes • Encryption/decryption occurs at the database • Applications do not need to handle encryption and decryption of data • No restrictions (FTS, indexes) All Action Auditing • Permits logging of database operations at a granular level • Create an Audit Specification to include server and DB actions in an audit • Ability to send logs to central collection server Encrypted data page Client Application

Predictable Performance:Minimize Downtime with Backup Compression • Minimize impact of backup procedures • Drastically reduce maintenance windows by reducing backup time • Significantly reduce space requirements for backups, decreasing costs or increasing ‘saved window’ • Beneficial to both log-shipping and mirroring setups • Minimize downtime in the event of outage • Reduce time needed to restore backup • Integrated solution lowers costs and management overhead • Standard backup commands and interface • Restore from any SQL Server 2008 Edition • Dynamically add resources (CPU, memory) • Reduce number of tools needed, removing complexity and costs Impact of Backup Compression

SQL Server 2008 Addresses Key Performance and Management Challenges in The Hosting Environment Reduced Management Cost Web Edition Enterprise Edition • Policy based management and multi-server management • Improved support for automation • Improved performance data collection, aggregation and analysis Predictable Performance • Resource governor • Backup compression Improved Support for Web Development • SQL Server Driver for PHP • Database publishing wizard and services • New data types, ADO.NET Data Services Framework Enabling Attached Services in Shared Environments • Business continuity • Resource dedicated tier or ‘utility-lite’ • Information protection and PCI compliance • Reporting Server

SQL Server 2008 for Hosters: FAQ HyperV and SQL Server licensing • SQL Server Enterprise Edition allows any number of deployments in VMs when all physical processors are licensed Upgrades and migrations • More predictable than 2005, usually 10-15% improvement in performance with very few problems reported • Ability to do in-place upgrade on databases with mirroring or log-shipping enabled SQL Server 2005 Driver for PHP • SQL Server 2005 Driver for PHP works for SQL Server 2008; you have to install SQL Server 2005 Native Client as well Database Publishing Wizard (DPW) • DPW and DPS have been updated to support new data types etc., integrated into SSMS and VS 2008

Questions?

for Hosters

for Hosters

Presentation Transcript

ISVs and Hosters – Working Together

GoLive Program for Hosters

IIS 7 for Hosters

for:

Virtualization for Hosters

Rights for for Dads

FOR

for

For Everyone, For All

ISVs and Hosters – Working Together

For

for

for birds  for people  for ever

for:

Benchmarking For utilities? For regulators? For Policies?

for