Nutanix 超融合最佳實(shí)踐指南之-SQL Server 數(shù)據(jù)庫(kù)

1、Nutanix 超融合最佳實(shí)踐指南 之 SQL Server 數(shù)據(jù)庫(kù)SQL Server Databases Run on NutanixOpportunities for SQLCustomer Case StudyWhy SQL on NutanixSQL Server Mobility Service2Gartner Operational Database Magic Quadrant31、跨平臺(tái)，2017年中旬發(fā)布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.免授權(quán)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.性能、價(jià)格內(nèi)存表、列存儲(chǔ)columnstore功能4.BI 報(bào)表功能微軟收購(gòu)了Datazen，專注于移動(dòng) BI 和數(shù)據(jù)可視化領(lǐng)域，并且它的基本部署與配置架構(gòu)都是基于SQL Server 的。在SQL Server 2016中，這一功能已經(jīng)集成在Reporting Servers中，并進(jìn)行改進(jìn)與加強(qiáng)，這意味著用戶可以使用Power BI或Excel 2016將報(bào)表發(fā)布至iphone，Android手機(jī)及Windows手機(jī)，除了移動(dòng)能力外，用戶還將獲得自助服務(wù)BI能力。因?yàn)檫@些功能都是通過(guò)內(nèi)建功能實(shí)現(xiàn)，因此無(wú)需在購(gòu)

4、買其他任何產(chǎn)品SQL Server 授權(quán)方式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