Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

SharePoint

FIXED – Distributed Cache is Unhappy

When SharePoint Server Distributed Cache is unhappy in a farm, you may see page loads error, 404s not found, API failures, and similar.   Having a well configured Distributed Cache will ensure healthy page renderings.  PowerShell notes below. Credit to one awesome long term SP engineer for the snippets below. Thank you.   Cheers! 

shades_smile

Image result for sharepoint distributed cache

CHECK STATUS

To check the status of the Distributed Cache Servers, run this command on each Farm from a DC machine.

REMOVE SERVER

ADD SERVER

CHANGE SERVICE = UP

To change the Service Status of a server to UP, run these commands on the server you wish to bring UP.

CHANGE STATUS = DOWN

To change the Service Status of a server to DOWN, run these commands on the server you wish to bring DOWN.

CHANGE IsLeadHost=FALSE

There can be only one IsLeadHost=True server in a Farm.  If there is more than is IsLeadHost=True servers your Farm will act unstable and people will see page load errors. We traditional set the lowest server name alphabetically in a Farm as IsLeadHost.  Change the DC Farm so that Service Status=DOWN on server.

More than one IsLeadHost=True is BAD.

SET DC CACHE SIZE (24GB server = 6GB CACHE)

Also notice our default DC cache size is only 819 MB.  MSFT formula = 24GB-2GB=22GB/2GB=11GB. Typical recommendation for a 24GB server is no more than 8GB Cache size. If running 24GB RAM on WFE, we should allocate 6GB (1024*6=6144 MB).

References

PWA Refresh – Clone Project Server to Lower Env (DEV)

Cloning a project server environment is not a simple procedure.   Wanted to share notes to help others.   Duplicating the SQL databases is a good start.   However, there are internal issues with duplicate GUID (same number already in use) that can create issues.

To resolve that hurdle I coded PowerShell which generates a new GUID and updates Site Collection (SPSite) via TSQL directly.   https://github.com/spjeff/spadmin/tree/master/SPContentDatabase-Replace-Site-GUIDs

With a fresh new GUID in place we can follow steps in SharePoint Central Admin, PowerShell, and PWA Settings to bring the new PWA database pairs (SharePoint Content + Project Plans) online for customers.   Word DOC included below with step-by-step detail.   Cheers! 

shades_smile

Download Checklist

PWA Refresh Procedure.DOC

Diagram

image

Context Diagram

References

VIDEO – NEW SharePoint Admin Center

Today I  noticed a new link in the top right of SharePoint Admin Center and recorded a brief video tour to highlight new features and compare to Classic Admin Center.   URL is below in case you want to try on your O365 tenant name.  Cheers! 

shades_smile

Video

Modern URL – SharePoint Admin Center

Classic URL – SharePoint Admin Center

References

Poster – SharePoint List – When to Use What

The below visual captures ideas on SharePoint table data storage and when to use what.    Rows and columns of data are common.  Choosing the best hosting technology provides ease of support, quick time to market, performance, and scale for data growth.

SQL Server has good use cases, but comes with trade-offs including higher upfront setup effort and fewer end user controls (audit, search, version history).  Can improve performance and reporting if those trade-offs are correctly addressed.

Select right tool for the job.  Times for both.

Cheers! 

shades_smile_thumb

Download PDF

Download VSDX

image

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲