1 / 28

Information worker / Sharepoint business workshops

Information worker / Sharepoint business workshops. Cathy Kohler Lets Collaborate. Typical SharePoint project. To do list: Purchase Hardware Install SharePoint Configure SharePoint Document Requirements Build Requirements Test solutions / UAT Deploy into Production

nhu
Download Presentation

Information worker / Sharepoint business workshops

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Information worker / Sharepointbusiness workshops

  2. Cathy Kohler Lets Collaborate

  3. Typical SharePoint project • To do list: • Purchase Hardware • Install SharePoint • Configure SharePoint • Document Requirements • Build Requirements • Test solutions / UAT • Deploy into Production • Go live to business • & everything works happily ever after…

  4. Not really… That’s more like it…

  5. So Now what ??? Monitoring Maintenance Backups Site Administration Planning Optimisation DRP testing

  6. 1 Step Planning

  7. SharePoint Maintenance Where to start ??? • Identify your Requirements • What SLA’s do you have in place with Business • What tools are available • Define & document a strategy • Farm Backup / Granular / Site • Identify limitations & workarounds • Test your strategy regularly • Create a Maintenance & Monitoring checklist • Define frequency of monitoring (daily, weekly, monthly) • Clean-up site data, logs, backups • Database maintenance • Constantly review strategy

  8. 2 Step Backups

  9. Backups • Backup via SharePoint Central Admin, Windows Powershell, SQL or 3rd Party • Level of backup • Full Farm (all settings & db’s) • Configuration settings • SQL db’s • Search Backups • Granular : Site Collection, Site & List level • Security (excl. or incl.) • Versioning (excl. or incl.) • Snapshot • Unattached restore – useful for end user support and response times

  10. Backups – Full Farm More info: http://technet.microsoft.com/en-us/sharepoint/ee518668.aspx

  11. Settings Not included • Some settings in the SharePoint Server environment are not included in a farm backup. They include the following settings that are stored on Web servers: • Application pool account passwords • HTTP compression settings • Time-out settings • Custom Internet Server Application Programming Interface (ISAPI) filters • Computer domain membership • Internet Protocol security (IPsec) settings • Network Load Balancing settings • Secure Sockets Layer (SSL) certificates • Dedicated IP address settings

  12. Backups - granular

  13. Backups - powershell • Manual backup - Create local folder on SharePoint server e.g. E:\Backups • Open SharePoint PowerShell • Scheduled Farm backup – Create a scheduled task to execute after hours • Open notepad and paste the following: • Backup-SPFarm-Directory \\ServerName\Backups -BackupMethod full • Close and save as BackupSharePointFarm.ps1 • Create a scheduled task for the following: • powershell-command E:\Backups\Script\BackupSharePointFarm.ps1 • At a Site level • Backup-SPSite -Identity SiteUrl –Path \\ServerName\Backups -IncludeUserSecurity -IncludeVersions

  14. Backup Tips • The following accounts must have R/W access to the backup location • Central Admin app pool account • SQL Service account • the account used to run the backup / execute the script • The backup location must be an UNC path e.g. \\server\share and not a local paths e.g. C:\backups • Document all IIS configurations for each Web server

  15. 3 Step Monitoring

  16. Monitoring - Sharepoint • Plan a monitoring strategy • Identify performance requirements • Search results • Time taken for Page views • SharePoint Farm monitoring • Timer Jobs • SharePoint Health Analyzer • Site monitoring • Site web analytics report • Check for updates • Server hardware / software • Security updates • Server Performance • Memory, CPU, disks

  17. Monitoring - Database • SQL clustering or mirroring • Test cluster or mirror to ensure recovery from a catastrophic failure • SQL snapshots • Test snapshots recovery for read-only and static copy of a database • Database monitoring • Routinely check the database integrity • Defragment indexes • Set optimal fill factor for the database servers • Monitor the database size and shrink it to recover the unused space • Database Backups • Check backups are running smoothly

  18. 4 Step Maintenance

  19. maintenance • Component Maintenance • SharePoint • Windows, IIS, etc • Service Apps, Search Optimisation & maintenance • SQL • SQL Databases • SQL Server Indexes • Patch Maintenance • SharePoint Server/s • Windows • SQL Server/s • Components

  20. Maintenance - Database • Reduce size of SharePoint log database • Configure a scheduled tasks to reduce database log size • Manually via SQL Server Management Studio (do all 3 steps) • Right click db– Properties – Options –change Recovery model to Simple • Right click db– Tasks – Shrink – Files – select File type: Log & required shrink action – OK • Right click db – Properties – Options – change Recovery model to Full • Query Command Line via SQL Server Management Studio

  21. 5 Step DRP Testing

  22. DRP Testing • Identify a Disaster Recovery strategy that is acceptable to the business for downtime while rebuilding/restoring your farm • DRP strategy can be expensive and increase complexity of your farm e.g. Cold standby vs. Hot • Prioritise Your SharePoint Data in DR Terms e.g. farm config vs. content • NB!!! Rebuilding your Dev / DRP environment from backups is an excellent way of ensuring you are able to restore from backups • Quarterly or monthly exercise to restore SharePoint farm or sites depending on backup & recovery strategy and redesign what doesn’t work • Unattached restore – useful for item level restores without necessarily having a Test environment

  23. 6 Step Site Administration

  24. Site admin • Weekly maintenance tasks should be carried out by the SharePoint Farm Admin • Analyse sizing of content databases and set warning limits • Split any large content databases before performance is affected • Analyse SharePoint Usage and Activity • Manage SharePoint Permissions • Monitor Governance maturity and enforce policies • Update Enterprise metadata / tags / folksonomy • Test & refine Search results • Update / Add Best bets • Review eve viewer/ULS logs for critical errors • Investigate purchasing a 3rd party tools to minimise time for administration

  25. 7 Step Optimisation

  26. optimisation • Effective measures to optimize the performance of the server farm • Throttling • Control overloading of server resources during peak usage times • Large lists control • As the size of a list grows the execution time of the list queries also increases, so some parameters to consider: the number of user query results to allow, the list warning level indicating that the list is getting close to the threshold limit which will result in poor list performance • Search engine optimization • Recommendations for the search engine optimization are meaningful site URLs and page titles, accurate metadata elements, and text based navigation menus. • Storage optimization • Optimize storage by using RAID disk arrays, avoid the auto growth option for data and log files, limit the content database size, and create multiple data files and distribute them across multiple disks for large content database. • Search refinements • Best bets

  27. Questions Questions/contact us: Cathy@letscollaborate.co.za

More Related