La gouvernance Infrastructure et Administration

About me

Gokan OzcifciSharePoint consultantVision Consulting Group

@gokanozcifciwww.gknzcfc.net

( gokanx.wordpress.com)

Microsoft Community Contributor

Agenda

SQL Server

SharePoint

Server

Windows

Server

WhoisQui?Who is using Applicative governance?

The definition is: strategy, guide, processes to follow for a specific goal

The difference between you and me is not longer than that « | »

GovernanceBest PracticeN+10

Platform goverance (PRE-I)

Hardware

Stay Close

Keep it clean

latest update

s

MABackup TL

Stand BY env + Test

Bakups

Hardwarelots of memory on the Web and application servers

Use gigabit network adapters for all server roles.

For front-end Web servers and application servers, use dual network adapters in production environments. Use one network adapter for users and one for Microsoft SQL Server communication.

Lots of Memory

Stay closeNo front-end Web server or application server should have more than one millisecond (ms) of latency between it and the database server.

Keep all the servers in a farm in the same data centerStay Close

UpdatesNO ! Only when impacted

Turn on Windows Update to download updates automatically, but not install automatically.

Schedule time to install updates at off-peak hours.

For high availability, rotate servers out of service one at a time during the update process.

latest updates

Managed AccountsBest practice that isn’t a best practice for corporates

Web applications: Use different accounts based on your security requirements.

Search account: Use one account for the farm.

Excel Services account: Use one account for external connections.

MA

BackupDo not only back up the data.

The usage logs, IIS logs, transaction logs, and SMTP e-mail logs all must be backed up if you want to be able to fully recover your environment.

For transaction logs, you should back up and truncate the log file every five minutes

Backup TL

EnvironmentPROD – ACC- TEST – DEV

In case of…

Routinely test backups and validate their consistency

Do not assume that the backup will work.

Disaster Recovery

Stand BY env + Test Bakups

Keep it cleanLimit content databases to 200 GB.

When you use SQL Server mirroring, do not store more than 50 databases on a single physical instance of SQL Server .

Free disk space: more than 25 percent

Memory used: less than 70 percent

Keep it clean

SQL Server 1/10 ( I-POST)Why is SQL Server so important to SharePoint?

Central store for most SharePoint data Stress on SQL Server causes stress on front-end servers and ultimately degrades user experience

SQL Governance 2/10 ( VvsP)

HA

Scale

HQ/DR

I/O €

SQL Server 3/10 (Hardware)

Your SQL Server needs to have enough RAM to function properly. If your SQL Server runs only SharePoint, here are the minimum requirements. 

SQL Server 4/10 (Disk)

SQL Server 5/10 (MP)Maintenance plans can both automate and schedule essential tasks to protect your data

SQL Server 6/10 (MB)Maximum Server Memory in MB: 2147423647Only for multiple instancesWhat to fill?

SQL Server 7/10 (MB)SQL Max Memory = TotalPhyMem - (NumOfSQLThreads * ThreadStackSize) - (1GB * CEILING(NumOfCores/4))

  NumOfSQLThreads = 256 + (NumOfProcessors*- 4) * 8   (* If NumOfProcessors > 4, else 0) 

  ThreadStackSize = 2MB on x64 or 4 MB on 64-bit (IA64)  

SQL Server 8/10 (Stats)Do not enable auto-create statistics on a server that hosts SQL Server and SharePoint Server. Not supportedSharePoint uses a stored procedure that maintains the statistics (proc_UpdateStatistics)

SQL Server 9/10 (FF)When an index is created or rebuilt, the fill-factor value determines the percentage of space on each leaf-level page to be filled with data

When Index are created or rebuilt for SharePoint 80 is optimal

SQL Server 10/10 (NTFS)

SQL server reads and writes 64k at a time, therefore is a best practice to make sure your disks are formatted with an allocation size of 64K and not the 4K default. This small change alone, will improve your SQL performance by up to 30%

Command Promt:  »chkdsk C: »

SharePoint Server (PRE-I)

Know what is in your

env.

Test = Prod

Use real data

Tests E/W

Know where you areKnow what is in your environment. Do a full survey first.

FULL Trust – Real Case

Know what is in your env.

EnvironmentIf possible, use the same kind of hardware and use the same settings

SettingsURL ( port )

What if Production Down? DB attach?

Spend time resolving unrelated issues to make sure that they will not occur during the actual upgrade.

Test = Prod

Real StealUse copies of your actual databases to run the tests

When you use real data, you can identify trouble areas and also determine upgrade performance.

Make sure that you find issues with the different kinds and sizes of sites, lists, libraries, and customizations that are present in your environment.

Use real data

TestingA single test can tell you whether you will encounter big problems.

Multiple tests will help you find all the issues

The upgrade/Install approaches

The downtimeHow the process or

performance may change after you address the issues that you uncovered in your first tests

Tests

Error / WarningsEven though a warning is not an error

IT CAN be an error

Investigate warnings

Write a Operational GuideE/W

SharePoint Server 1/8 (Wizard)Always use Wizard (just kidding )

Managed AccountSecurityDatabase Name

SharePoint Server 2/8 (PS)

Learn to install from Command-linePowershell is your friend!

Learn to manage from Command-linePowerShell Help

Script everything (if possible)Win-Win

It’s not going away any time soonMost Microsoft products will eventually use itYou can’t do everything from the GUI any moreIt can make your life easierMicrosoft certification exams contain PowerShell questionsIf you don’t learn it, someone else will

SharePoint Server 3/8 (SA)Never use a single service account!Password Policy ( Our biggest problem )Create the Following Accounts

SQL Admin AccountSharePoint Installation AccountSharePoint Farm Admin Global Administrator

SharePoint Server 4/8 (IIS)

Fine tuning of you’re IIS ServerRegular Recycle?Specific time(s)

SharePoint Server 5/8 (WUS)IIS cache has to be filled by Warm Up

Has to be configured on each serverIIS reset, receycle, … be carefull on Production Env.

SharePoint Server 6/8 (Design)HTML5, Dreamweaver, …No more real SharePoint Designers

Other governance from other platforms has to be adopted ( google eye )

SharePoint Server 7/8 (Disable)The SharePoint Health Analyzer detected a condition requiring your attention. Drives are at risk of running out of free space.

Be carefull when custommer/business has access to your platform.

SharePoint Server 8/8 (SC)Wizard again

Check your needExcel Services on Search Center?

Thanks & Great Governance