1. Cisco Data Center SolutionsThe Optimal Infrastructure ForMicrosoft SQL Server 2014 WorkloadsAaron RigneyConsulting Systems EngineerDate 9/20/2014 2013 Cisco and/or its affiliates. All rights reserved. 1

2. Running Your Microsoft Environment on UCS Allows You toIncrease deploymentavailability and scaleDecrease databaseand virtualization sprawlReduce costsHardware computing capacityNumber of database appsNumber of DBAsResulting in Underutilized Hardware Overburdened Administrators1990 2014 2013 Cisco and/or its affiliates. All rights reserved. 2 3. Compute Cisco Unified Computing(UCS)Manageability Cisco UCS Manager Cisco UCS PowerTool Cisco Integration WithSystem CenterNetworking Cisco Nexus 1000V Cisco UCS VM-FEX 2013 Cisco and/or its affiliates. All rights reserved. 3 4. With UCS Service ProfilesUCS Service Profiles are XML filesthat contain metadata for theserverStateless servers require that aUCS Service Profile is associatedwith each workloadOnce applied to a blade, turn onand bring up a new service profilein minutes to serve end users 2013 Cisco and/or its affiliates. All rights reserved. 4 5. Introduce SQL Server workloadsinto production with service profilesBring failed SQL Server workloadsback in minutes instead of hours ordaysCustomize your operations withautomated PowerShell scripts 2013 Cisco and/or its affiliates. All rights reserved. 5 6. Pre-integrated data centercomponents Blade Servers Adapters Fabric Interconnects Extenders Common EmbeddedManagement System Fewer SystemComponents Manageable Efficient Flexible Unified Fabric Reduces Components ManagementTouch Points Efficient AgileOverview 2013 Cisco and/or its affiliates. All rights reserved. 6 7. Cisco UCS B & CSeries ExtendedMemory Blade Server(Interior View)Efficiency and PerformanceCisco UCS 82598KR-CI10 Gigabit Ethernet AdapterCompatibilityCisco UCS M7 1KRConverged Network AdaptersVirtualizationCisco UCSVirtual Interface CardsCisco ExtendedMemory Technology48 DIMMs 2013 Cisco and/or its affiliates. All rights reserved. 7 8. Profiles to define a service and/or serviceelements reduces configuration errors andincrease consistency across deployments.Service definitions may define servers, networks,firewall policies, etc. Profiles can quickly and efficientlyrepurpose resources based on dynamicbusiness requirements. Minimizing RTO in a more interconnectedworld requires additional mechanisms toincrease availabilitySelf-healingRestarting processesIn service software upgradesService ProfileNIC MACsHBA WWNsServer UUIDVLAN AssignmentsVLAN TaggingFC Fabrics AssignmentsFC Boot ParametersNumber of vNICsBoot orderPXE settingsIPMI SettingsNumber of vHBAsQoSCall HomeTemplate AssociationOrg & Sub Org Assoc.Server Pool AssociationStatistic ThresholdsBIOS scrub actionsDisk scrub actionsBIOS firmwareAdapter firmwareBMC firmwareRAID settingsAdvanced NIC settingsSANLAN 2013 Cisco and/or its affiliates. All rights reserved. 8 9. Reduced Labor CostReduced Error RateSimplified ToolsPortfolioPolicy 1Service Profile 1UIDsPolicy 1Policy 2ResourcesPool DataService Profileto TemplateTemplate 1UID PlaceholdersPolicy 2Policy 1ResourcesPool DataPolicy 2Associatewith ServerNew ServiceProfiles FromTemplate 2013 Cisco and/or its affiliates. All rights reserved. 9 10. With Service Profile TemplatesConfigure Service ProfileTemplates specifically for yourSQL ServersCreate new service profiles inseconds once you have a templateFoster consistent standardizationof your SQL Serverimplementations with thestandards set by your organization 2013 Cisco and/or its affiliates. All rights reserved. 10 11. With System Center 2012 R2Proactively and efficiently manageand monitor your Cisco UCSHardware with System Center2012 R2 Operations ManagerAutomate, standardize and extendCisco UCS deployment andmanagement with MicrosoftSystem Center 2012 R2OrchestratorView and manage Cisco UCSinfrastructure directly from SystemCenter 2012 R2 Virtual MachineManager with the UI ExtensionAdd-in for SCVMM 2013 Cisco and/or its affiliates. All rights reserved. 11 12. Cisco UCS PowerTool is a user-friendly,PowerShell-based libraryintegrated with Microsoft toolsA simple way to utilize WindowsPowerShell to customizeworkflows to meet your businessneedsAutomate the deployment of SQLServer hosts and guests 2013 Cisco and/or its affiliates. All rights reserved. 12 13. Operations Manager Orchestrator Virtual Machine Mgr of GlassCisco Virtual Networking Solutions for Hyper-VVM-FEX Nexus 1000VWindows Server 2012 R2 with Hyper-VUCS ManagerInfrastructure &Physical VirtualSingle PaneUnified Computing SystemSoftwareIntegrationStorage Provision and ManageWindows Server 2012 R2Physical and virtualenvironments supported byCisco UCS and Cisco VirtualNetworking Infrastructure. UCSM integration isavailable for System Center2012 R2 Cisco Nexus 1000V switchextension for Hyper-V isavailable with SC 2012 R2 2013 Cisco and/or its affiliates. All rights reserved. 13 14. Service Profile Portability with SQLSLOT1SLOT3SLOT5SLOT7!STATSLOT2SLOT4SLOT6SLOT8UCS 5108FANSTATFAN2 FAN1FANSTATN10-PAC1-550W! !UCS B200 M1! Console Reset! !UCS B200 M1! Console Reset! !UCS B200 M1! Console Reset! !UCS B200 M1! Console Reset! !UCS B200 M1! Console Reset! !UCS B200 M1! Console Reset! !UCS B200 M1! Console Reset! !UCS B200 M1! Console ResetOK FAIL OK FAIL OK FAIL OK FAILPS2 PS1FAILOKN10-PAC1-550WFAILOKSQL Server-PhysicalApplicationServer-VMWebServer-VMMove Service Profile:Server NameUUID, MAC,WWNBoot infofirmwareLAN, SAN ConfigFirmware 2013 Cisco and/or its affiliates. All rights reserved. 14 15. Cisco UCS provides vast amountsof compute and memory perstandard rack unitImplement large, virtualized SQLServer workloads with sufficient I/Oto service workloads without addingmore blades and/or ports to theenvironmentSupport for Scale-Out or Scale-Upvirtual deployments 2013 Cisco and/or its affiliates. All rights reserved. 15 16. Compute Cisco UnifiedComputing (UCS)Networking Cisco Nexus 1000V Cisco UCS VM-FEXManageability Cisco UCS Manager Cisco UCS PowerTool Cisco Integration WithSystem Center Rapidly launch tothe cloud with apreconfiguredsolution Approach theprivate cloudwith lower risk Scale up and outwith ease Have confidencewith a validatedsolution built onMicrosoftReferenceArchitectureFlexPodorVSPEXManage With PowerShell System Center 2013 Cisco and/or its affiliates. All rights reserved. 16 17. And Get The Most From Your Microsoft SQL Server 2014 WorkloadsGet Started Now www.cisco.com/go/datacenter www.cisco.com/go/microsoft www.cisco.com/servers Communities.cisco.com 2013 Cisco and/or its affiliates. All rights reserved. 17