1 / 23

Dana Kaufman SQL Server Appliance Engineering

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.

marshall-george
Download Presentation

Dana Kaufman SQL Server Appliance Engineering

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. Fast Time to Solution: Introduction to HP Business Decision Appliance and HP Business Data Warehouse Appliance Dana Kaufman SQL Server Appliance Engineering

  2. Microsoft Business Intelligence Appliance

  3. 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 * HP Business Decision Appliance (BDA)

  4. 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

  5. Streamlined install: SharePoint 2010 and SQL Server 2008 R2 Install – end to end in ~45 mins

  6. SharePoint Starting Page – For End User

  7. Inform end-users of new appliance

  8. SharePoint Starting Page – For IT Users

  9. Appliance Management Console(SharePoint Add-in)

  10. Appliance Information

  11. Appliance Console

  12. System Center Operations Manager: Microsoft BI Appliance Diagram View

  13. Microsoft data warehouse appliance

  14. 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 Currently being offered through HP * Up to 5TB data warehouse in a pre-configured, optimized single enclosure * HP Business Data Warehouse Appliance (BDW)

  15. System Verification

  16. Windows Mount Point Verification

  17. Database Configuration

  18. System Center Operations Manager:MDW Appliance Management Pack • Extents Fragmentation • TOP 20 large tables • Fragmentation Thresholds • Avg Fragment Size in pages > 400 : Green • Avg Fragment Size in pages 300-400: Yellow • 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…

  19. Diagnostic Task and Monitor History- Fragmentation

  20. Diagnostic Task and Monitor History- Fragmentation (Details)

  21. 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

  22. 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

More Related