Microsoft SQL Server & Cisco UCS

Frank Cicalese

Technical Solutions Architect ~ Cisco Systems Inc.

2© 2013-2014 Cisco and/or its affiliates. All rights reserved.

Pre-integrated data center components

Blade Servers Adapters Fabric

Interconnects Extenders

Common Embedded Management System

Fewer System Components

Manageable Efficient Flexible

Unified Fabric Reduces

Components Management

Touch Points Efficient Agile

Cisco Unified Computing SystemOverview

3© 2013-2014 Cisco and/or its affiliates. All rights reserved.

Service Profile Elements In Stateless Hardware

• Profiles to define a service and/or service elements reduces configuration errors and increase consistency across deployments.

• Service definitions may define servers, networks, firewall policies, etc.

• Profiles can quickly and efficiently repurpose resources based on dynamic business requirements.

• Minimizing RTO in a more interconnected world requires additional mechanisms to increase availability

• Self-healing

• Restarting processes

• In service software upgrades

Service Profile NIC MACs HBA WWNs Server UUID VLAN Assignments VLAN Tagging FC Fabrics Assignments FC Boot Parameters Number of vNICs Boot order PXE settings IPMI Settings Number of vHBAs QoS Call Home Template Association Org & Sub Org Assoc. Server Pool Association Statistic Thresholds BIOS scrub actions Disk scrub actions BIOS firmware Adapter firmware BMC firmware RAID settings Advanced NIC settings

SAN

LAN

4© 2013-2014 Cisco and/or its affiliates. All rights reserved.

Service Profile Templates

Reduced Labor Cost

Reduced Error Rate

Simplified Tools Portfolio

Policy 1<data><data>

Service Profile 1

UIDs

Policy 1

Policy 2

Resources

Pool Data

Template 1

UID Placeholders

Policy 1

Policy 2

Resources

Pool Data

Policy 2<data>

Associate with Server

New Service Profiles From Template

Service Profile to Template

5© 2013-2014 Cisco and/or its affiliates. All rights reserved.

Cisco UCS I/O Adapters• Virtual Interface Cards (VICs)

• Replaces traditional approach of

• Multiple vNIC’s & vHBA’s per server: SingleConnect.

• Up to 256 interfaces per 2-port adapter

• VM-FEX

• Tuneable bandwidth 20Gp to 80Gp

• 3rd adapters for compatibility

• Broadcom

• Emulex

• Intel

• Qlogic

6© 2013-2014 Cisco and/or its affiliates. All rights reserved.

Monitor, Manage, and Maintain Your Infrastructure & SQL Server ImplementationsWith System Center 2012 R2

Proactively and efficiently manage and monitor your Cisco UCS Hardware with System Center 2012 R2 Operations Manager

Automate, standardize and extend Cisco UCS deployment and management with Microsoft System Center 2012 R2 Orchestrator

View and manage Cisco UCS infrastructure directly from System Center 2012 R2 Virtual Machine Manager with the UI Extension Add-in for SCVMM

7© 2013-2014 Cisco and/or its affiliates. All rights reserved.

Automate Your Data Center with Cisco UCS and Microsoft PowerShell Integration

Cisco UCS PowerTool is a user-friendly, PowerShell-based library integrated with Microsoft tools

A simple way to utilize Windows PowerShell to customize workflows to meet your business needs

Automate the deployment of SQL Server hosts and guests

8© 2013-2014 Cisco and/or its affiliates. All rights reserved.

UCS Manager

Physical Virtual

Manage Your UCS Hardware With System Center 2012 R2 And PowerShell

“Single Pane of Glass”Operations

ManagerOrchestrator

Virtual Machine Mgr.

Unified Computing System

Software

Integration

Infrastructure &

Windows Server 2012 R2 with Hyper-V

Cisco Virtual Networking Solutions for Hyper-V

VM-FEX Nexus 1000V

Storage

Provision and Manage Windows Server 2012 R2 Physical and virtual environments supported by Cisco UCS and Cisco Virtual Networking Infrastructure.

UCSM integration is available for System Center 2012 R2

Cisco Nexus 1000V switch extension for Hyper-V is available with SC 2012 R2

Sto

rag

e P

ow

erS

hell M

od

ule

s

UC

S P

ow

erT

ool fo

r P

ow

erS

hell

9© 2013-2014 Cisco and/or its affiliates. All rights reserved.

Use CaseService Profile Portability with SQL

SLOT

1

SLOT

5

SLOT

3

SLOT7

SLOT

2

SLOT6

SLOT

4

SLOT

8

!

UCS 5108

OK FAIL OK FAIL OK FAIL OK FAIL

PS1

PS2

FAN STAT FA

N1

FAN

2

FAN STAT

STA

T

OK

FAIL

N10-PAC1-550W

OK

FAIL

N10-PAC1-550W

! ResetConsole

! !UCS B200 M1

! ResetConsole

! !UCS B200 M1

! ResetConsole

! !UCS B200 M1

! ResetConsole

! !UCS B200 M1

! ResetConsole

! !UCS B200 M1

! ResetConsole

! !UCS B200 M1

! ResetConsole

! !UCS B200 M1

! ResetConsole

! !UCS B200 M1

SQL Server-PhysicalApplicationServer-VMWebServer-VM

Move Service Profile:Server NameUUID, MAC,WWNBoot infofirmwareLAN, SAN ConfigFirmware…

10© 2013-2014 Cisco and/or its affiliates. All rights reserved.

www.cisco.com/go/datacenter

www.cisco.com/go/microsoft

www.cisco.com/servers

Communities.cisco.com

Get Started Now

Optimize Your Infrastructure TodayAnd Get The Most From Your Microsoft SQL Server 2014 Workloads

Thank you.