Nutanix 超融合最佳实践指南之-SQL Server 数据库

1、Nutanix 超融合最佳实践指南 之 SQL Server 数据库SQL Server Databases Run on NutanixOpportunities for SQLCustomer Case StudyWhy SQL on NutanixSQL Server Mobility Service2Gartner Operational Database Magic Quadrant31、跨平台，2017年中旬发布Since the announcement, Numoto says that roughly 8,000 companies, including about 25%

2、of the Fortune 500, have registered to try the preview version of SQL Server on Linux. And he says that anecdotally, lots of Oracle customers are looking for a way out.2.免授权MICROSOFT IS ATTEMPTINGto lure companies to SQL Server 2016 by offering free licences, but customers need to be part of Microso

3、fts Software Assurance licencing scheme.3.性能、价格内存表、列存储columnstore功能4.BI 报表功能微软收购了Datazen，专注于移动 BI 和数据可视化领域，并且它的基本部署与配置架构都是基于SQL Server 的。在SQL Server 2016中，这一功能已经集成在Reporting Servers中，并进行改进与加强，这意味着用户可以使用Power BI或Excel 2016将报表发布至iphone，Android手机及Windows手机，除了移动能力外，用户还将获得自助服务BI能力。因为这些功能都是通过内建功能实现，因此无需在购

4、买其他任何产品SQL Server 授权方式4Opportunities for Over 50% of new workloads on Nutanix are enterprise applicationsBusiness critical databases and applications drive business (=spend)Over provisioning for performanceMeet availability (uptime and data protection) SLA in budgetComplexity of management from infr

5、astructure silosNeed to lower SQL licensing costsMeasured a 20 x performance increase for production SQL databases98% fewer occurrences of unplanned downtime Zero downtime for Bauer Built Cost reductions: Cut server administration by over 50%, colo rackspace by 45% and electrical by 33%Agility: Redu

6、ced development build times by 72%PAIN POINTSNUTANIX VALUESQL Server Solutions SOCOMSOCOM Special Operations CommandTightly knit organization, broad IT footprint, range of workloadsYet to virtualize SQLData centers:2 main data centers with 75k users10 regional data centers worldwide with 8k users ea

7、ch Exchange, SharePoint, SQL 50 remote data centers worldwide primary services like AD, security, basic office apps, filesStrategic & Tactical Tips from the Field:Scott RagsdaleTu McLendonProving SQL Support Critical to Growing the DealCountered FUD were not enterprise-ready for heavy workloadsBuilt

8、 confidence that we could handle the scale, performance and availability requiredLots of good resources available for complex dealsServices can help remove risk and increase comfort levelEnterprise Databases meet Web-ScaleValue for Transactional Databases (OLTP)High performance and low latency becau

9、se of localized I/O for random read/writesData is automatically tiered depending on usage using storageChoice of CPU/Memory and storage options (including all flash)Value for Analytical Databases (OLAP/DSS)Excellent sequential write/read throughput because of ability to identify IO typeScalable perf

10、ormance and capacity without having to redesign the architectureMix OLTP and OLAP workloads on the same system avoiding silosHave large amounts of active data avoiding performance bottlenecksDeal with colder data transparentlyFlash delivers maximum performance and minimum latency regardless of worki

11、ng set sizeAll-Flash SolutionPerformance for enterprise applicationsMust for all your Tier-0 and Tier-1 databases and applications proposalsVirtual Machine/Virtual DiskServer 1Server 2Server NDistributed Storage FabricDSFVMVMVMVMVMVM122+ Nutanix AdvantageStart small and scalePredictable performanceT

12、ransactions and analytics togetherFor illustrative Purposes onlyNutanix Performance for Upgraded SQLHot tip: Ask about SQL Upgrade Plans, as can often be a trigger for infrastructure changeSQL 2016 SP1 released in NovemberSQL 2008 Extended support only for 2 more yrsSQL 2012 Mainstream support ends

13、in JulySQL 2014 Mainstream support for 2 more yrsWeb ServersApp ServersiSCSIABSSupport Physical MS SQL Server InstancesDB ServersInvestment protection for existing serversConsolidate bare metal and physical workloads on NutanixHigh Performance & Highly AvailableBetter price-performance than purpose

14、built All Flash systemsEliminate traditional SAN ComplexityEfficient and Easy Dev / Test EnvironmentsVM clonesGive developers their own high performance environmentMaster / productionVMQuickly spin up local or remote VM clones for QA testingVM clones or replicasBenefit from a VM-centric approach to

15、development and testing.From Self Healing Systems to -0- RPOSelf-healing from disk failureRedundancy of key componentsHardwareNode failure resiliencyNon-disruptive upgradesNodeTunable redundancyTransparent consistent checksDataVM-centric ProtectionEco-system integration (Commvault)VMMulti-site repli

16、cationCloudConnectMetro AvailabilitySiteSetup SLA at the application level SQL Server Mobility ServiceOne-click migration of SQL Server with best practices14ScanDeployDesignMigrate1-Click SQL Server MigrationNEWSLQ Server Mobility Service (SSMS)SQLSQLConfig DataPerfDataScanDeployDesignMigrate1-Click

17、 SQL Server MigrationNEWSQLSQLConfig DataPerfDataDesignTemplateScanDeployDesignMigrateBest PracticesSizingStorage DesignNetworkSecurity1-Click SQL Server MigrationNEWSQLSQLSQLSQLScanDeployDesignMigrate1-Click SQL Server MigrationNEWDesignTemplateSQLSQLSQLSQLScanDeployDesignMigrate1-Click SQL Server

18、MigrationNEW1-Click SQL Server MigrationSQLSQLSimpleFastAutomatedNEWWhy should your customer use SSMS?SQL optimized with best practices = peace of mindRemove carryover of past bad design/implementationAutomation for consistency at scaleNear-zero downtime cutoverWhere you should pitch SSMSHelp custom

19、er with Discovery and Assessment of SQL ServersAny SQL migration, virtual or bare metal, to ESXi on NTNXLot of DBs and needs to apply best practices at scaleRe-apply best practices to poorly performing SQL ServersHow to use SSMS to help enhance and close dealsEnsures terrific PoC ExperienceOpens doo

20、r to talking to DB and App teamsAudit and discovery of customers SQL DatabasesHigh-quality, automated sizingSQL Server Discovery and AnalysisDB-Level InsightsDeployment AutomationSingle Nutanix Fabric Across All WorkloadsSQL is One App But Many More to TargetGet Started on SQL OpportunitiesEnterpris

21、e Applications eBookSQL Server Solution Web PageMicrosoft SQL Server Best Practices GuideVirtualizing Microsoft SQL Server on Converged Infrastructure Solution Note Enterprise Apps BattlecardSSMS DatasheetInvite at least 5 each of your prospects and customers to the SQL webinar with a SQL expert fro

22、m Windows IT Pro and Nutanix. Registration linkTalk to existing customers about SQL to expand your footprint. Bring in the SSMS team for SQL database opportunities to remove barriers and build customer trustNext StepsResources NUTANIX Enterprise App SOLUTIONS BATTLECARD29Resources: Case StudiesRicht

23、er: Physical to Virtual + SQL (and MS Apps): /rs/nutanix/images/Nutanix-Case-Study-Richter.pdfHyundai: SQL (MS Apps): /watch?v=gE8ziZoKAK8Texas A&M: Acropolis Hypervisor (AHV) + SQL (and MS Apps): /rs/031-GVQ-112/images/texas-am.pdf Bauer Built (SQL (Business Intelligence 40% faster): /rs/nutanix/im

24、ages/Nutanix_Bauer_Built_Tire_Case_Study.pdf LA Fitness: SQL Performance: /press-releases/2013/12/10/la-fitness-trims-off-infrastucture-with-nutanix/Lenoir City: SQL Server Performance benefits and DR: /resource/nutanix-helps-the-lenoir-city-utilities-board-keep-the-lights-shining-brightly/ Hallmark

25、 Business Connections (SQL): /press-releases/2015/08/19/hallmark-business-connections-slashes-operational-costs-by-55-percent-with-nutanix/We wanted to reduce our data center costs, virtualize all our critical servers and hopefully see some significant performance gains. We achieved all of our goals and more by moving to Nutanix- Greg Eamer, Director of IT, Richter“NEEDBENEFITPerformance to virtualize their large MS S