Reduce Infrastructure Costs Increase Productivity with SQL Server

Reduce Infrastructure Costs & Increase Productivity with SQL Server 2008 Graeme Scott – Technology Solution Professional grscott@microsoft. com

SQL Server 2008: High-value Enterprise Data Platform

SQL Server: Reduce Infrastructure Costs Data Compression Reduce disk storage requirements for SQL databases. Improve performance, I/O throughput and memory usage. Backup Compression Reduce the size of backup files.

SQL Server: Reduce Infrastructure Costs SQL Virtualization n

SQL Server: Increase DBA Productivity Policy Based Management Resource Governor Performance Data Collection

Use Policies for Management Tasks Automate policy enforcement across the enterprise Define policies centrally

SQL Server: Increase DBA Productivity Policy Based Management Resource Governor Performance Data Collection

Resource Management with Resource Governor: SQL Server Backup Executive High Reports OLTP Activity Admin Tasks Med Admin Workload OLTP Workload Ad-hoc Reports Report Workload Max CPU 20% Max Memory 40% Max CPU 80% Max Memory 60% Admin Pool Application Pool Resource pool: A virtual subset of physical database engine resources Provides controls to specify Min Memory % Max Memory % Min CPU % Max DOP Resource monitoring Up to 20 resource pools

SQL Server: Increase DBA Productivity Policy Based Management Resource Governor Performance Data Collection

SQL Server: Increase Developer Productivity Visual Studio Integration with SQL Server Language Integrated Query (LINQ) Policies Enhance developer productivity: Extensive. Net Framework-based application interfaces. Entity Framework, Synchronization Framework & ADO. Net Data Services. Single consistent query language crossing multiple data sources and data formats. Use policies to apply development standards. Support for a wide range of data types XML, hierarchical & spatial. “The mash-up of maps and data that displays the plant locations in Microsoft Virtual Earth was ready in three days at a cost of five developer days in total. The entire application, including comments, is less than 300 lines of code. ” – MARK WHITEHORN, Research Associate, University of Cambridge.

Resources Twelve ways to reduce costs with SQL Server 2008. Learn about SQL Server 2008 R 2. Total economic impact of SQL Server 2008 upgrade. Lower costs with the SQL Server value tool. http: //www. microsoft. com/everybodysbusiness/en/gb/products/sqlserver-2008. aspx

© 2009 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.