1 | sharepoint saturday calgary – 31 may 2014 about me

1 | SharePoint Saturday Calgary – 31 MAY 2014

About Me

+15 years’ experience in Datacenter Architectures

+80 Micrososoft Certification +11 has a MCT (Western Canada Regional

Lead) MVP in System Center Cloud &

Datacenter Management + Deploy over +1000 SharePoint Farms

Agenda

PlanningDeploymentMonitoringProtectionConclusion

Audience TargetWho is a SharePoint AdministratorWho is Hosting SharePoint Who has a SP 2013 Farm, but it’s not performing wellWho is using System Center to Administer SP 2013Who has challenges and need to find solutionsWho wants to learn how to deploy SP 2013 on Hyper-VNone of the above but I have interest

Planning Phase


What is “Virtualizable”?Active Directory Domain Services *

Front-End Web Server or Application ServerThe SQL Server Services, can we Virtualize that?Any Part of SQL, ADS, SharePoint 2013

Does Size Matter!

Yes, yes it does!

General Virtual Supportability Guidance

1. Guest Clustering is supported with SQL Server when running a guest operating system of Windows Server 2008 SP2 or newer

SQL ServerVersion

SupportingDocumentation

SQL Server 2008 SP3 Hardware & Software Requirements, Hardware Virtualization & Guest Clustering Support

SQL Server 2008 R2 SP2 Hardware & Software Requirements, Hardware Virtualization & Guest Clustering Support

SQL Server 2012 SP1 Hardware & Software Requirements, Hardware Virtualization & Guest Clustering Support

SQL Server 2014 Hardware & Software Requirements, Hardware Virtualization & Guest Clustering Support

SQL Server Version

Running on the following Windows Server Guest Operating Systems

Supported on Hyper-V

Supports Guest Clustering

SQL Server 2008 SP3

2003 SP2, 2003 R2 SP2, 2008 SP2, 2008 R2 SP1, 2012, 2012 R2

Yes Yes1

SQL Server 2008 R2 SP2

2003 SP2, 2008 SP2, 2008 R2 SP1, 2012, 2012 R2 Yes Yes1

SQL Server 2012 SP1

2008 SP2, 2008 R2 SP1, 2012, 2012 R2 Yes Yes

SQL Server 2014 2008 SP2, 2008 R2 SP1, 2012, 2012 R2 Yes Yes1 - Guest Clustering is supported with SQL Server when running a guest operating system of Windows Server 2008 SP2 or newer

http://msdn.microsoft.com/en-us/library/ms143506(v=sql.100).aspx

http://support.microsoft.com/?id=956893

http://msdn.microsoft.com/en-us/library/ms143506(v=sql.105).aspx


http://msdn.microsoft.com/en-us/library/ms143506.aspx


http://technet.microsoft.com/en-us/library/ms143506(v=sql.120).aspx


General Virtual Supportability Guidance

1. SharePoint HA refers to the deployment of each of the key tiers of a SharePoint infrastructure, across multiple virtual machines. This would involve the WFEs balanced behind a NLB, redundant application servers, and a SQL Server AlwaysOn/Clustered/Mirrored configuration across multiple virtual machines. These combinations are supported on Hyper-V.

2. Support for running SharePoint on Windows Server 2012 R2 is only available with SharePoint 2013 SP1 and SharePoint 2010 SP2

SharePointVersion

SupportingDocumentation

SharePoint 2007 Hardware & Software Requirements, Hardware Virtualization Support



SharePoint Version

Running on the following Windows Server Guest Operating Systems

Supported on Hyper-V

Supports SharePoint HA1

SharePoint 2007 SP3

2003 SP2, 2003 R2 SP2, 2008 SP2, 2008 R2 SP1

Yes Yes

SharePoint 2010 SP2

2008 SP2, 2008 R2 SP1, 2012, 2012 R22 Yes Yes

SharePoint 2013 SP1

2008 R2 SP1, 2012, 2012 R22 Yes Yes

1 - SharePoint HA refers to the deployment of each of the key tiers of a SharePoint infrastructure, across multiple virtual machines. This would involve the WFEs balanced behind a NLB, redundant application servers, and a SQL Server AlwaysOn/Clustered/Mirrored configuration across multiple virtual machines. These combinations are supported on Hyper-V.2 - Support for running SharePoint on Windows Server 2012 R2 is only available with SharePoint 2013 SP1 and SharePoint 2010 SP2

http://technet.microsoft.com/en-us/library/cc262485(v=office.12).aspx



http://technet.microsoft.com/en-us/library/ff607968(v=office.14).aspx

http://technet.microsoft.com/en-us/library/cc262485.aspx

http://technet.microsoft.com/en-us/library/ff607795.aspx


Virtualizing SQL Server | Performance

Only 6.3% better on the physical.

4 8 16 32 640

100200300400500600700800900

0

0.2

0.4

0.6

0.8

1

Hyper-V Virtual CPU Scalability

with OLTP Workloads

Virtual Processors Per VM

Tra

nsact

ions/S

ec

Avera

ge T

ransact

ion R

esponse

Tim

e (

Sec)

Windows Server 2012, SQL Server 2012, Single VM, 64GB of RAM

Full report is available here

6x performance increase

Additional features such as SR-IOV, Virtual Fibre Channel and Virtual NUMA.

5x improvement in transaction response time.

http://download.microsoft.com/download/C/C/1/CC16C89A-E289-4217-B2D8-7DD37A4285B8/ESG-Lab-Validation-WS2012-HyperV-and-SQL2012.pdf


Virtualizing SharePoint | Performance

1 2 30

200,000400,000600,000800,000

1,000,0001,200,0001,400,0001,600,000

0

0.2

0.4

0.6

0.8

1

SharePoint Workload Scalability on Windows

Server 2012 with Hyper-V

Web Front Ends

Heavy U

sers

(1%

Concurr

ency)

Avera

ge R

esponse T

ime (

Sec)

8 vCPU, 12GB RAM per WFE VMFull report is available here

SharePoint 2013 infrastructure deployed

1 Physical Hyper-V ServerSSD-BasedMirror Storage Spaces

5 Hyper-V VMs (3 WFE, 1 App, 1 SQL)Supported

Demand of over 1.3 million heavy users (60 requests per hour)With 1% concurrency, running a lightweight, non-blocking workload)With measurably low response times throughout (230 request/sec - .08s response time)

http://download.microsoft.com/download/2/7/B/27BF6FED-FEAB-48FD-A005-C3B351FF09BA/ESG_Lab_Validation_WS2012_Hyper-V_and_SharePoint_2013.pdf


Virtualizing SharePoint | Performance

1 2 3 50

400,000

800,000

1,200,000

1,600,000

2,000,000

2,400,000

0

0.2

0.4

0.6

0.8

1

SharePoint Workload Scalability on Windows

Server 2012 with Hyper-V

Web Front Ends

Heavy U

sers

(1%

Concurr

ency)

Avera

ge R

esponse T

ime (

Sec)

8 vCPU, 12GB RAM per WFE VM

ESG LabsTested a virtualized tier-1 SharePoint 2013 infrastructure

Scalability & PerformanceDeployed across 3-5 Hyper-V VMs, Single physical serverSupported over 1.3 million heavyweight 1% concurrent users on a virtualized SharePoint farm.When pushed further, the 5 VM configuration scaled to over 2 million heavyweight 1% concurrent users, whilst keeping CPU utilization below 90%.

Download Full ReportThe full report is available for public download here.

http://download.microsoft.com/download/2/7/B/27BF6FED-FEAB-48FD-A005-C3B351FF09BA/ESG_Lab_Validation_WS2012_Hyper-V_and_SharePoint_2013.pdf

SharePoint Architecture Guidance


Key Virtual Hardware Considerations

Weights & ReservesvNUMA (SQL & IIS 8)LP:VP Ratios:SQL – N/ASP – 1:1 (Max 2:1)

Dynamic MemorySP – NoSQL - Yes

VM

Synthetic vNICDVMQ or SR-IOVIn-Guest TeamingNetwork QoS

Fixed VHDX (up to 64TB)

Separate VHDXsNo SnapshotsVirtual FCIn Guest iSCSIShared VHDX

Host Storage:DAS, SMB, FC, iSCSISAS, SSD etc.

SharePoint High AvailabilityComprehensive resilience for Web Front Ends, Application & SQL

ServersMultiple Levels of RedundancySharePoint 2013 enables administrators to implement redundancy at web, application and database layers.

SQL Server AlwaysOn Failover Cluster Instances (FCI) or Availability Groups provide resilience at database level.Multiple Application servers provide resilience for farm services and specific application components such as search.Multiple front end web servers dedicated to serving content, behind an NLB for network distribution.

SQL Server AlwaysOnFailover Cluster Instance or

Availability Groups

Application ServersSearch Query & Index along with other application roles

Front-End Web ServersWeb content servers

behind a Network Load Balancer

Combining HA ConfigurationsDual-levels of resilience with Hyper-V & SharePoint HA

Windows Server 2012 R2 Hyper-VFailover Clustering at host level provides resiliency in the event of hardware failure.Supports Failover Priority to ensure SharePoint VMs start first upon failover, and in a specific order.Supports Anti-Affinity rules to keep SharePoint farm member VMs on different physical hosts.

SharePoint ResilienceSharePoint VM virtual disks should be stored on resilient storage (SMB 3.0, iSCSI, FC).A 3-tier deployment with multiple VMs per tier would be recommended for production.SharePoint farm nodes, including SQL Servers, fully supported with Hyper-V Live Migration.

Hyper-V HostCluster

Guest SQL Server AlwaysOn Failover Cluster for SharePoint

content databases

iSCSI, Fibre Channel or SMB 3.0 Storage, used to store

SharePoint & SQL Server VM virtual disks and/or SQL Server data files (SMB)

Integrated Cluster MaintenanceCluster-Aware Updating ensures clusters stay patched &

protectedHyper-V Host MaintenanceCluster-Aware Updating (CAU) will orchestrate the automatic Live Migration of SharePoint VMs away from Hyper-V nodes that are ready to be patched.Node is placed into maintenance mode before patching, and removed upon completion.CAU can be manually triggered, or set to Self-Updating Mode for automated patching on a scheduled basis - daily, weekly, or monthly intervalsCAU can also be extended to include 3rd party patches, hotfixes, firmware updates etc.CAU can be managed via PowerShell or through GUI.No downtime to the SharePoint Virtual Machines whilst the process of patching the host is underway.

Hyper-V HostCluster

Virtualized SharePoint Web, Application or SQL Servers

iSCSI, Fibre Channel or SMB 3.0 Storage, used to store SharePoint & SQL Server VM virtual disks

Hybrid Infrastructure

Integrating with Microsoft AzureSharePoint Infrastructure within a Hybrid Cloud

Microsoft Azure Infrastructure ServicesWhilst SharePoint admins can upload their own SharePoint VMs, Microsoft Azure Infrastructure Services also provides a gallery of images for rapid deployment.Virtual Machines are geo-replicated for durability & redundancy.VM images can be brought back on premises from Microsoft Azure infrastructure services.Rich web-based dashboard for administration & ongoing management.Integration with System Center for centralized management & monitoring.

SharePoint & Microsoft AzureDesign, implement, and develop on SharePoint 2010/2013 without upfront hardware costsDevelop custom internet sites and collaboration apps not supported in softwareas a service modelBurst compute, storage, and database for your SharePoint farm when you need itMicrosoft provides end-to-end, direct support for SharePoint running in Microsoft Azure.Microsoft Azure Virtual Networks and ADFSallow streamlined integration with on premise resources.Deployment can be automated via PowerShell and once deployed, can be monitored & managed with System Center

Integrating with Microsoft AzureSharePoint Infrastructure within a Hybrid Cloud

Best practice guidance for virtualization


Best PracticesLeave adequate memory for the Hyper-V partitions. (we recommend 6 GB of RAM or more for host computer operations.)

Use a recommended of four Networks

Use NIC Teaming for the VM guest network.

Use a minimum of two physical network adapters.

Use NIC Teaming for Host – Virtual Adapters


Best Practices

Do not oversubscribe the CPU on the virtualization host computer.

Do not use snapshots in a production environment*

Do not use the parent partition for services other than Hyper-V.

Do not store host computer system files on drives that are used for Hyper-V storage.

Configure the Hyper-V host computer


Configure the Hyper-V host computerAvoid running programs such as anti-virus

software on the parent partition. (Run them on the child partition if they are required.)

Use hardware that supports Second Level Address Translation (SLAT).

Enable Hyper-Threading (if hardware supports it)Use fast connections on Hyper-V (10GB) or fasterHyper-V Hotfixes are different than Windows Update!

Deployment Phase


What are our options for deployment?

Manually

System Center 2012 R2 Configuration Manager

System Center 2012 R2 Virtual Machine ManagerSystem Center 2012 R2 Orchestrator with SCVMM

Microsoft Deployment Toolkit (MDT)

Delivering SharePoint as a ServiceStandardized, automated deployment of virtualized SharePoint Servers

Automated SharePoint DeploymentSingle server or Multi-server architecture Unattended installation Service Template for SharePoint:

Test Labs, DR Planning, HA Options, Quickly adding remote sites, Hosting

Delivering SharePoint as a ServiceSharePoint via Infrastructure as a Service (IaaS)

With the Windows Azure Pack (WAP)Rich, Azure-like experiencePre-populated galleryWAP integrates with VMMAccess to certain VMRoles & available capacitySharePoint owners also have access to performance metrics associated with their VM instances and can connect to their instances via console or RDP.

Automating that Accelerated Deploymentwith System Center 2012 R2

Hyper-V Hosts

{ Virtual Machine ManagerVM & cloud management, infrastructure provisioning

App ControllerVM & applicationself-service

Operations ManagerInfrastructure & application monitoring & alerting

Data Protection ManagerContinuous protection of key applications & workloads

Service ManagerIT Service Management & IaaS Self-Service

OrchestratorIntegration & automation of key technologies & processes}

SharePoint Automation

SharePoint Integration PackSystem Center Orchestrator can be used to automate specific SharePoint-leveltasks.Free Integration Pack for SharePointAlso Integrate with PowerShll

Deploy SharePoint like the Pro’s

Scripted installationCreates the following:

FarmSite CollectionsWeb ApplicationsContent DB’sSites

Configures the following:PermissionsFile SizesOutgoing Email

Defines the followings:Quotas

& Much More!!

Monitoring Phase

SharePoint Monitoring & InsightEnsure optimal & efficient operation of the SharePoint infrastructure

Deep SharePoint Infrastructure InsightThrough System Center Operations Manager, SharePoint admins can gain deep visibility into key SharePoint components along with services applications.Management Packs contain knowledge for rules, monitors, and alerts that helps you identify problems, causes, and resolutions.Monitors health, service outages, performance and more, and provides links into up-to-date TechNet knowledge articles for fast remediation.Management Pack developed by the team that build SharePoint.Provides centralized monitoring of SharePoint, side by side with monitoring the rest of the infrastructure, across physical & virtual, from hardware, through virtualization, & into applications.

SharePoint Monitoring & InsightEnsure optimal & efficient operation of the SharePoint infrastructure

Deep SharePoint Infrastructure InsightProvides rich, customizable dashboards & views to visualize information on health & performance.Allows construction of visual Service Level Dashboards to ensure SharePoint infrastructure is meeting expectations.Allows construction of rich performance dashboards to ensure SharePoint deployments are running efficientlyPowerful in-box reporting provides historical look at health & performance trendsOperations Manager integrates with Service Manager to integrate Service Management ticketing with Operations Manager alerting.Integrates with Global Service Monitoring for Outside-In monitoring of web applications & sites.

SharePoint Configuration GuidanceProactively avoid configuration problems with ongoing assessment

Optimized SharePoint ConfigurationThrough System Center Advisor, a free cloud service, admins gain granular configuration guidance for SharePoint, aligned with best practices.Helps admins to proactively avoid configuration problems, reduce downtime, improve performance & resolve issues faster.Configuration alerts are centralized into Operations Manager console, or accessible via dedicated web console.Alerts provide detailed knowledge & guidanceAlerts also link directly to suggested solutions and knowledge base articles to accelerate time to resolution.


SharePoint Server 2013

SharePoint Foundation 2013

What does the SharePoint 2013 MP Monitoring from SharePoint 2013?

MS SharePoint Server 2013MS Project Server 2013Access ServicesBusiness ConnectivitySecurity Token ServicesManaged Meta Web ServiceEducation ServicesExcel Service ApplicationInfoPath Form ServicePerformance Point ServicesTranslation Services

Sandboxed Code ServicesSecure Store ServicesSharePoint Server SearchUser Profile ServicesVisio ServiceWord Automation Service


You must install the SharePoint Foundation MP firstIf you download it from the SCOM Console, it will put it into the correct order for you.If there is an upgrade, the import MP wizard will identify this, and upgrade for you

Installing the SharePoint 2013 MP


Make sure the RunAs account is configuredEnsure you have a list of the SP ServersAllow an hour for the MP to complete, to display all the info

Configure the SharePoint 2013 MP


Quick Glance at the issuesWorks close to real timeSaves time and effortAll the moving components shownCan be extended to show routers, Switches, Firewalls, ADS, DNS and Server Hardware

Distributed Application or your SharePoint Farm


With System Center 2012 R2 you get the Whole picture!

Great Monitoring in SharePoint

Protection Phase

SharePoint ProtectionGranular end to end application protection for SharePoint

Integrated, Intelligent Backup for SharePointThrough System Center Data Protection Manager, IT admins can protect SharePoint at both the VM & SharePoint-levels.Integrates with SharePoint VSS writers & provides the ability to protect SharePoint data, up to every 30 minutes, to disk and onto tape or cloud.Provides in-line, item level recovery, and restoration of configuration & central admin databases & automatic protection of new content databasesReduced storage consumption versus native SharePoint backup capabilities.Delegated administration for backup and restoration to key stakeholders.Each DPM Server protects up to 25TB SharePoint data.


Granular Workload-Level Protectionwith Data Protection Manager 2012 R2Through Data Protection Manager, not only can IT protect their key virtual machines, but IT can also provide centralized protection for key workloads such as SQL, SharePoint and Exchange.Data Protection Manager provides granular protection up to the latest versions of each of the key workloads, and fully supports SQL Server 2014 AlwaysOn, SharePoint 2013 farms.


Backing up to the Cloud is considered to be off-site.

Azure Backu

p


Conclusion All of SharePoint can be virtualized with WS Hyper-V

SQL Server 2014 is the best to date

SharePoint 2013 works best on Microsoft WS Hyper-V

Windows Server and System Center 2012 R2!

SharePoint with System Center 2012 R2 is protected

All of SQL can be virtualized with WS Hyper-V

Questions & Answers


Thanks to Our Sponsors


Special Thanks

SharePoint Training Courses http://www.neweratechnology.com/courses/sharepoint.aspx

Calgary SharePoint User Group

CalSPUG


Housekeeping

Join us for SharePint Time: 4:15 PM – 6:00 PM Location: TBD

1 | sharepoint saturday calgary – 31 may 2014 about me

Documents