[PDF] Tuning Microsoft SQL Server for SharePoint

View - Download Tuning Microsoft SQL Server for SharePoint

Previous PDF

Next PDF

Tuning Microsoft SQL

Server for SharePoint

Daniel Glenn

Daniel Glenn

@DanielGlenn http://KnowSP.com xSharePoint and Collaboration Practice Leader @ InfoWorks,

Inc. Ȃwww.InfoWorks-tn.com

xPASS Nashville Business Intelligence (Nash BI) User Group xSharePoint User Group President and Speaker

Business Process

Analysis, Analysis,

Architecture and

Design

Fresh perspective

to create and align your strategy and goals

We will help you

respond to your business needs and get more done in less time

Improve the impact

of information on your business

Trusted partner for

creating and maintaining a sustainable organization

PMP-certified

Project Managers,

PMO standards and

procedures

InfoWorks

www.InfoWorks-TN.com

About you

xDatabase administrators xBusiness users xDevelopers xSharePoint administrators

SharePoint experience?

About you

Agenda

xSharePoint install demo xWhat is SharePoint? xSharePoint Databases xSQL Configuration xSQL Server Maintenance xSharePoint Configuration

SharePoint Install

Demo

What is SharePoint?

SharePoint

xSharePoint is a valuable tool that delivers enterprise document management, business intelligence, web content management, search, and social capabilities xThere are different versions and deployment options xFoundation, Standard, Enterprise; on- premises, cloud, hybrid components xA Site Collection?

SharePoint

SharePoint Databases

SharePoint

Databases

xFor a full install of SharePoint 2013 Enterprise on-premises, there are over 20 databases xTypes: xConfiguration xCentral Admin Content xContent xService Apps (some have more than one DB) xOne content database per Site Collection

xContent databases can have many site collections, but a large (>100GB) site collection should have a dedicated database

SharePoint

Databases

SharePoint

Configuration

SharePoint

Configuration

xDedicated SQL instance xWatch those resources! xDNS CNAME or SQL Alias for use with

SharePoint

xBefore SharePoint install xKeep your collaborationsite content databases < 200GB xMonitor SharePoint content database I/O

SQL Configuration

SQL

Configuration

xNew Instance xNot on the SharePoint server! xLatin1_General_CI_AS_KS_WS xFile placement xModel database xIncrease initial size, and set to do MB growth not % xFull recovery xTempdb xData files = # of processor cores* xSimple recovery xServer memory (RAM) usage xMax Degree of Parallelism SQL

Configuration

SQL

Configuration

Permissions for SharePoint administrators &

service accounts xSharePoint admins themselves do NOT need permissions within SQL xThe service account used to install SharePoint needs: xsecurityadminand dbcreatorSQL Server roles during setup and configuration SQL

Configuration

Permissions for SharePoint administrators &

service accounts (cont) xThe service account that is the Farm service account will be provisioned automatically during farm creation to have: xdbcreatorand securityadminfixed server roles. xIt will also be the db_ownerfor all

SharePoint databases.

xOther service accounts will be added to new roles on SharePoint databases

To learn more: http://technet.microsoft.com/en-

us/library/cc678863(v=office.15).aspx

SQL Server

Maintenance

SQL Server

Maintenance

xDatabase growth xPlan and pre-grow xQuotas, # site collections per database xLow vs. High I/O databases xLower I/O databases can be larger without performance issues xBackups xLocation xTest them! xSimple vs. full recovery

SQL Server

Maintenance

xKB841057 (et al.) For SharePoint production xOpen xEdit xQuery xEtc. xFragmentation xDatabase xTables xIndexes xFile system

SQL Server

Maintenance

xKB841057 (et al.) For SharePoint production xOpen xEdit xQuery xEtc. xFragmentation xDatabase xTables xIndexes xFile system

Summary

Best Practices

& Summary xUse SQL Server best practice guidance xUse RAID disks and spread data and trans log files on multiple physical drives xAuto growth and fragmentation xDefragment SQL drives that have SharePoint content databases xBackup (with multiple copies) and test your backups xDedicated SQL Server or

SQL Instance

xCreate SQL Server alias or CNAME xContent databases < ~200GB xMonitor SharePoint content database I/O xMaxDOP= 1 xSet dbcreatorand securityadminfor

SharePoint install

account only

SharePoint Install

Demo

Thank you!

@Daniel Glenn

Daniel.Glenn@InfoWorks-TN.com

www.NashvilleSUG.com

Nashbi.sqlpass.org

quotesdbs_dbs29.pdfusesText_35

[PDF] Php Date Format From String

[PDF] Dix sept wilayas productrices de datte , une richesse inépuisable

[PDF] conditionnement des dattes - Tunisie Industrie

[PDF] Intoxication par le Datura

[PDF] 5352/210 - Administration des Douanes et Impôts Indirects

[PDF] Dauphine en mains - Université Paris-Dauphine

[PDF] Banque, finance, assurance - Offre de formation de l 'Université Paris

[PDF] master-management-luxedauphinefr - Université Paris-Dauphine

[PDF] Année universitaire 2016-2017 Calendrier des Candidatures /E

[PDF] l 'université choisie - Université Paris-Dauphine

[PDF] FOR 7-121 NOTICE LIVRET 2 DEME

[PDF] The Biggest Secret - Download David Icke Books For Free

[PDF] La vérité vous rendra libres - TopChrétien

[PDF] DAVID ICKE quot L humanité est collectivement hypnotisée par une

[PDF] Lecture de David Le Breton