dana kaufman sql server appliance engineering
DESCRIPTION
Fast Time to Solution: Introduction to HP Business Decision Appliance and HP Business Data Warehouse Appliance. Dana Kaufman SQL Server Appliance Engineering. Microsoft Business Intelligence Appliance. End-to-end, pre-configured stack quickly enables BI for Excel power users. - PowerPoint PPT PresentationTRANSCRIPT
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 MicrosoftLast Updated: Wednesday, April 19, 2023
FAST TIME TO SOLUTION: INTRODUCTION TO HP BUSINESS DECISION APPLIANCE AND HP BUSINESS DATA WAREHOUSE APPLIANCE
Dana KaufmanSQL Server Appliance Engineering
MICROSOFT BUSINESS INTELLIGENCE APPLIANCE
End-to-end, pre-configured stack quickly enables BI for Excel power users
CURRENTLY BEING OFFERED THROUGH HP *
• Streamlined install of complex BI software stack; up and running with Windows Server, SharePoint, SQL Server and PowerPivot 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 ProLiant DL360 G7 X5650 (1U) 2x Westemere Processor (12 cores) with 96GB
Storage 8 x internal 300 GB SAS disks
Software Windows Server 2008 R2 EE OEM, SQL Server 2008 R2 EE VL, SharePoint 2010 EE VL, PowerPivot SharePoint 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• SharePoint 2007 widely used, no near term upgrade to 2010• 2010 Enterprise wide deployment but enabling PowerPivot on the mid-
tier not feasible short term
STREAMLINED INSTALL: SHAREPOINT 2010 AND SQL SERVER 2008 R2 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 *
• 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 ProLiant DL370 G6 x 5675 (4U) with 2x Westmere processors (12 cores), 96GB
Storage 24 x internal SFF SAS disks with 2 x Smart Array controllers and SAS expander (2.3TB raw user storage)
Software Windows Server 2008 R2 EE OEM, SQL Server 2008 R2 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
Up to 5TB data warehouse in a pre-configured, optimized single enclosure
* 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 < 100mb• …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/HP-bdw.aspx
• HP Business Decision Appliance (BDA):http://www.microsoft.com/sqlserver/en/us/solutions-technologies/Appliances/HP-ssbi.aspx
• White Paper – Disaster Recovery with two BDAhttp://download.microsoft.com/download/0/5/0/0506F126-74B4-491A-969C-2B2448AD5CB1/MSBIApplianceDR-Final.docx
FURTHER. FORWARD. FASTER.
•Learn moreVisit the Microsoft Virtual AcademyFree technical SQL Server training courses
•Get moreDownload SQL Server 2012 Trial Software180-day evaluation of SQL Server 2012
•Do moreParticipate in virtual launch activities and collect points for prizesThe more points you earn, the bigger your prize could be
© 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, 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.
© 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, 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.