FAST TIME TO SOLUTION INTRODUCTION TO HP BUSINESS

FAST TIME TO SOLUTION: INTRODUCTION TO HP BUSINESS DECISION APPLIANCE AND HP BUSINESS DATA WAREHOUSE APPLIANCE Dana Kaufman SQL Server Appliance Engineering This document has been prepared for limited distribution within Microsoft. This document contains materials and information that Microsoft considers confidential, proprietary, and significant for the protection of its business. The distribution of this document is limited to those solely involved with the program described within. Confidential and Proprietary © 2011 Microsoft Last Updated:

MICROSOFT BUSINESS INTELLIGENCE APPLIANCE

CURRENTLY BEING OFFERED THROUGH HP * End-to-end, pre-configured stack quickly enables BI for Excel power users • Streamlined install of complex BI software stack; up and running with Windows Server, Share. Point, SQL Server and Power. Pivot in under an hour • Optimized software and hardware based on best practices for performance and security • Easy manageability with appliance specific management dashboard • Built-in backup capabilities and factory reset, quickly return appliance to known state SKUs Components Server HP Pro. Liant DL 360 G 7 X 5650 (1 U) 2 x Westemere Processor (12 cores) with 96 GB Storage 8 x internal 300 GB SAS disks Software Windows Server 2008 R 2 EE OEM, SQL Server 2008 R 2 EE VL, Share. Point 2010 EE VL, Power. Pivot Share. Point Integration Infrastructure No physical (install in rack), Active Directory, DHCP required Services Software technical support * HP Business Decision Appliance (BDA)

APPLIANCE USE CASES • Small and Medium Size Companies • Enterprise Departmental Deployments • Share. Point 2007 widely used, no near term upgrade to 2010 • 2010 Enterprise wide deployment but enabling Power. Pivot on the mid-tier not feasible short term

STREAMLINED INSTALL: SHAREPOINT 2010 AND SQL SERVER 2008 R 2 INSTALL – END TO END IN ~45 MINS 5

SHAREPOINT STARTING PAGE – FOR END USER

INFORM END-USERS OF NEW APPLIANCE

SHAREPOINT STARTING PAGE – FOR IT USERS

APPLIANCE MANAGEMENT CONSOLE (SHAREPOINT ADD-IN) 9

APPLIANCE INFORMATION

APPLIANCE CONSOLE

SYSTEM CENTER OPERATIONS MANAGER: MICROSOFT BI APPLIANCE DIAGRAM VIEW

MICROSOFT DATA WAREHOUSE APPLIANCE

CURRENTLY BEING OFFERED THROUGH HP * Up to 5 TB data warehouse in a pre-configured, optimized single enclosure • Makes DW widely accessible without need for dedicated resources • Up and running with SQL Server in approximately 10 mins • Automated db creation/load apps remove complexity • Optimized software and hardware based on best practices for performance and security • Fast Track DW 3. 0 RA configuration SKUs Components Microsoft DW Appliance Server HP Pro. Liant DL 370 G 6 x 5675 (4 U) with 2 x Westmere processors (12 cores), 96 GB Storage 24 x internal SFF SAS disks with 2 x Smart Array controllers and SAS expander (2. 3 TB raw user storage) Software Windows Server 2008 R 2 EE OEM, SQL Server 2008 R 2 EE VL, HP Quick Deployment Tool, HP Business Data Warehouse DDL and Data Load Wizard Infrastructure Only requirements - Active Directory, DHCP Services Software technical support * HP Business Data Warehouse Appliance (BDW)

SYSTEM VERIFICATION

WINDOWS MOUNT POINT VERIFICATION

DATABASE CONFIGURATION

SYSTEM CENTER OPERATIONS MANAGER: MDW APPLIANCE MANAGEMENT PACK • Extents Fragmentation • TOP 20 large tables • Fragmentation Thresholds o Avg Fragment Size in pages > 400 : Green o Avg Fragment Size in pages 300 -400: Yellow o Avg Fragment Size in pages <300: Red • Critical State added to the monitor's states • Show Extents Fragmentation diagnostic task in Monitor's history • Show Extents Fragmentation task in Knowledge Base link and in State • Adverse configuration changes • • • Lock Pages in memory Startup Option Even growth DB files in Filegroup Increase Extents Number in Database Autogrow increment <5% or < 100 mb …more…

DIAGNOSTIC TASK AND MONITOR HISTORY - FRAGMENTATION

DIAGNOSTIC TASK AND MONITOR HISTORY - FRAGMENTATION (DETAILS)

ADDITIONAL INFORMATION • SQL Server Appliances: www. microsoft. com/appliances • HP Business Data Warehouse Appliance (BDW): http: //www. microsoft. com/sqlserver/en/us/solutions-technologies/Appliances/HPbdw. aspx • HP Business Decision Appliance (BDA): http: //www. microsoft. com/sqlserver/en/us/solutions-technologies/Appliances/HPssbi. aspx • White Paper – Disaster Recovery with two BDA http: //download. microsoft. com/download/0/5/0/0506 F 126 -74 B 4 -491 A-969 C 2 B 2448 AD 5 CB 1/MSBIAppliance. DR-Final. docx

FURTHER. FORWARD. FASTER. • Learn more Visit the Microsoft Virtual Academy Free technical SQL Server training courses • Get more Download SQL Server 2012 Trial Software 180 -day evaluation of SQL Server 2012 • Do more Participate in virtual launch activities and collect points for prizes The more points you earn, the bigger your prize could be

© 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U. S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.