Slow SharePoint improve performance without upgrading hardware

what you can do if your SharePoint is sometimes very slow.

E.g.: on the first start of a Site
Sometimes during the day a search query will take about a minute until you get results…..

Just look on that article: http://support.microsoft.com/kb/2625048

it will improve “feeled” performance (site response times) massive, if you’re going to implement both solutions.

Disabling CRL Check is just necessary if the SP Server does not have internet connectivity, that means proxy settings must be configured for the server itself

http://technet.microsoft.com/de-de/library/bb430772(v=exchg.141).aspx, and your proxy must allow traffic from the server of course.

Advertisements

SharePoint shortcut URL and hidden list

Users and Permissions:
People and Groups: _layouts/people.aspx
Site Collection Admins: _layouts/mngsiteadmin.aspx
Advanced Permissions: _layouts/user.aspx
Master Pages: _Layouts/ChangeSiteMasterPage.aspx
Look and Feel:
Quick Launch settings page: /_layouts/quiklnch.aspx
Title, Desc, and Icon: _layouts/prjsetng.aspx
Navigation: _layouts/AreaNavigationSettings.aspx
Page Layout and Ste Templates: _Layouts/AreaTemplateSettings.aspx
Welcome Page: _Layouts/AreaWelcomePage.aspx
Tree View: _layouts/navoptions.aspx
Top Nav Bar: _layouts/topnav.aspx
Site Theme: _layouts/themeweb.aspx
Reset to Site Definition: _layouts/reghost.aspx
Searchable Columns: _Layouts/NoCrawlSettings.aspx
Site Content Types: _layouts/mngctype.aspx
Galleries
Site Columns: _layouts/mngfield.aspx
Site Templates: _catalogs/wt/Forms/Common.aspx
List Templates: _catalogs/lt/Forms/AllItems.aspx
Filter toolbar for Lists and libraries: ?Filter=1
Web Parts: _catalogs/wp/Forms/AllItems.aspx
Workflows: _layouts/wrkmng.aspx
Workflow history hidden list: /lists/Workflow History
Master Pages and Page Layouts: _catalogs/masterpage/Forms/AllItems.aspx
Regoinal Settings: _layouts/regionalsetng.aspx
Site Administration
Recreate default site sp groups: _layouts/15/permsetup.aspx
recycle bin: _layouts/RecycleBin.aspx
Site Libraries and Lists: _layouts/mcontent.aspx
Site Usage Report: _layouts/usageDetails.aspx
User Alerts: _layouts/sitesubs.aspx
RSS: _layouts/siterss.aspx
Search Visibility: _layouts/srchvis.aspx
Sites and Workspaces: _layouts/mngsubwebs.aspx
Site Features: _layouts/ManageFeatures.aspx
Delete This Site: _layouts/deleteweb.aspx
Site Output Cache: _Layouts/areacachesettings.aspx
Content and Structure: _Layouts/sitemanager.aspx
Content and Structure Logs: _Layouts/SiteManager.aspx?lro=all
Search Settings: _layouts/enhancedSearch.aspx
Site Collection Administration
Search Scopes: _layouts/viewscopes.aspx?mode=site
Search Keywords: _layouts/listkeywords.aspx
Recycle Bin: _layouts/AdminRecycleBin.aspx
Site Collection Features: _layouts/ManageFeatures.aspx?Scope=Site
Site Hierachy: _layouts/vsubwebs.aspx
Site hierarchy page (lists of sub sites): /_layouts/1033/vsubwebs.aspx
Portal Site Connection: _layouts/portal.aspx
Site Collection Audit Settings: _layouts/AuditSettings.aspx
Site Collection Policies: _layouts/Policylist.aspx
Site Collection Cache Profiles: Cache%20Profiles/AllItems.aspx
Site Collection Output Cache: _Layouts/sitecachesettings.aspx
Site Collection Object Cache: _Layouts/objectcachesettings.aspx
Variations: _Layouts/VariationSettings.aspx
Variation Labels: _Layouts/VariationLabels.aspx
Translatable Columns: _Layouts/TranslatableSettings.aspx
Variation Logs: _Layouts/VariationLogs.aspx
Site Settings: _layouts/settings.aspx
Delete user from Site collection (on-premises): /_layouts/15/people.aspx?MembershipGroupId=0

Load document tab initial
?InitialTabId=Ribbon.Document

Delete user from Site collection (on-premises):
/_layouts/15/people.aspx?MembershipGroupId=0

Display list in grid view. ‘True’ is case sensitive:
?ShowInGrid=True

Sandboxed Solution Gallery:
/_catalogs/solutions/Forms/AllItems.aspx

Filter toolbar for Lists and libraries:
?Filter=1

Site usage page:
/_layouts/usage.aspx

View all site content page (Site content):
/_layouts/viewlsts.aspx

Get the version of the SharePoint server (Patch level):
/_vti_pvt/Service.cnf

Web Part Maintenance Page:
?Contents=1

Show Page in Dialog View:
?isdlg=1

Application page for registering SharePoint apps
/_layouts/15/appregnew.aspx

Save Site as a template
/_layouts/savetmpl.aspx

Sign in as a different user
/_layouts/closeConnection.aspx?loginasanotheruser=true

Enable SharePoint designer
/_layouts/SharePointDesignerSettings.aspx

Quick Deploy List
Quick%20Deploy%20Items/AllItems.aspx

Open Page in Edit Mode
?ToolPaneView=2

Taxonomy Hidden List (MMS)
Lists/TaxonomyHiddenList/AllItems.aspx

User Information List:
_catalogs/users
_catalogs/users/simple.aspx

Force displaying the user profile in the site collection:
/_layouts/userdisp.aspx?id={UserID}&Force=True

Site hierarchy page (lists of sub sites)
/_layouts/vsubwebs.aspx
/_layouts/1033/vsubwebs.aspx

Add Web Parts Pane: ?ToolPaneView=2 : Add to the end of the page URL; will only work if the page is already checked out
Create: [area]/_layouts/spscreate.aspx
Create: /_layouts/create.aspx

Create list in a different portal area :

/_layouts/new.aspx?NewPageFilename=YourTemplateName.stp&ListTemplate=100&
ListBaseType=0

When you save a template in a portal area and try to create a new list in a different portal area, the template will not show on the Create page. Use this URL to force it to show.

Documents and Lists: /_layouts/viewlsts.aspx

List Template Gallery: /_catalogs/lt

Manage Audiences: /_layouts/Audience_Main.aspx

Manage Cross Site Groups: /_layouts/mygrps.aspx

Manage List Template Gallery: /_catalogs/lt/Forms/AllItems.aspx

Manage My Alerts: /_layouts/MySubs.aspx

Manage People: /_layouts/people.aspx

Manage Site Collection Administrators: /_layouts/mngsiteadmin.aspx

Manage Site Collection Users:
/_layouts/siteusrs.aspx : To access you must be an admin on the server or a site collection admin for the site.

Manage Site Groups: /_layouts/role.aspx

Manage Site Template Gallery: /_catalogs/wt/Forms/AllItems.aspx

Manage Site Template Gallery: /_catalogs/wt/Forms/Common.aspx

Manage Sites and Workspaces: /_layouts/mngsubwebs.aspx

Manage User Alerts: /_layouts/AlertsAdmin.aspx

Manage User Alerts: /_layouts/SiteSubs.aspx

Manage User Permissions: /_layouts/user.aspx

Manage Web Part Gallery: /_catalogs/wp/Forms/AllItems.aspx

Master Page Gallery: /_catalogs/masterpage : Also includes Page Layouts

Modify Navigation: /_layouts/AreaNavigationSettings.aspx

Recycle Bin: /_layouts/AdminRecycleBin.aspx

Save as site template: /_layouts/savetmpl.aspx

Site Column Gallery: /_layouts/mngfield.aspx

Site Content and Structure Manager: /_layouts/sitemanager.aspx

Site Content Types: /_layouts/mngctype.aspx

Site Settings: /_layouts/settings.aspx

Site Settings: /_layouts/default.aspx

Site Template Gallery: /_catalogs/wt

Site Theme: /_layouts/themeweb.aspx

Site usage details: /_layouts/UsageDetails.aspx

Site Usage Summary: /_layouts/SpUsageWeb.aspx

Site Usage Summary: /_layouts/Usage.aspx

Sites Registry: /SiteDirectory/Lists/Sites/Summary.aspx

Top-level Site Administration: /_layouts/webadmin.aspx

User Information: /_layouts/userinfo.aspx

Web Part Gallery: /_catalogs/wp

Web Part Page Maintenance: ?contents=1 : Add to the end of the page URL

Retrive account password powershell

Basic Powershell cmdlet sharepoint

Get-Command -Noun SP*
Get-Help Get-SPSite
Get-Help Get-SPSite -Examples
PS C:\Users\de.prasad.adm> Get-Command -Noun SPSite

CommandType Name ModuleName


Cmdlet Backup-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Copy-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Move-SPSite Microsoft.SharePoint.PowerShell
Cmdlet New-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Repair-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Restore-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Set-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Test-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Upgrade-SPSite Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPWeb

CommandType Name ModuleName


Cmdlet Export-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Import-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet New-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Set-SPWeb Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPWebApplication

CommandType Name ModuleName


Cmdlet Convert-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet New-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet Set-SPWebApplication Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPServiceApplication

CommandType Name ModuleName


Cmdlet Get-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Publish-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Set-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Unpublish-SPServiceApplication Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPServiceApplicationPool

CommandType Name ModuleName


Cmdlet Get-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
Cmdlet New-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
Cmdlet Set-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPContentDatabase

CommandType Name ModuleName


Cmdlet Dismount-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Mount-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet New-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Set-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Test-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Upgrade-SPContentDatabase Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPDatabase

CommandType Name ModuleName


Cmdlet Get-SPDatabase Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPManagedAccount

CommandType Name ModuleName


Cmdlet Get-SPManagedAccount Microsoft.SharePoint.PowerShell
Cmdlet New-SPManagedAccount Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPManagedAccount Microsoft.SharePoint.PowerShell
Cmdlet Set-SPManagedAccount Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun STimerJob
PS C:\Users\de.prasad.adm> Get-Command -Noun SPTimerJob

CommandType Name ModuleName


Cmdlet Disable-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Enable-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Set-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Start-SPTimerJob Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPUser

CommandType Name ModuleName


Cmdlet Get-SPUser Microsoft.SharePoint.PowerShell
Cmdlet Move-SPUser Microsoft.SharePoint.PowerShell
Cmdlet New-SPUser Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPUser Microsoft.SharePoint.PowerShell
Cmdlet Set-SPUser Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun WebApplication

CommandType Name ModuleName


Cmdlet ConvertTo-WebApplication WebAdministration
Cmdlet Get-WebApplication WebAdministration
Cmdlet New-WebApplication WebAdministration
Cmdlet Remove-WebApplication WebAdministration
PS C:\Users\de.prasad.adm> Get-Command -Noun SPProcessAccount

CommandType Name ModuleName


Cmdlet Get-SPProcessAccount Microsoft.SharePoint.PowerShell

PS C:\Users\de.prasad.adm> Get-Command -Verb Get

Cmdlet Get-PfxCertificate Microsoft.PowerShell.Security
Cmdlet Get-PfxData PKI
Cmdlet Get-Process Microsoft.PowerShell.Management
Cmdlet Get-PSBreakpoint Microsoft.PowerShell.Utility
Cmdlet Get-PSCallStack Microsoft.PowerShell.Utility
Cmdlet Get-PSDrive Microsoft.PowerShell.Management
Cmdlet Get-PSProvider Microsoft.PowerShell.Management
Cmdlet Get-PSSession Microsoft.PowerShell.Core
Cmdlet Get-PSSessionConfiguration Microsoft.PowerShell.Core
Cmdlet Get-PSSnapin Microsoft.PowerShell.Core
Cmdlet Get-Random Microsoft.PowerShell.Utility
Cmdlet Get-ScheduledJob PSScheduledJob
Cmdlet Get-ScheduledJobOption PSScheduledJob
Cmdlet Get-SecureBootPolicy SecureBoot
Cmdlet Get-SecureBootUEFI SecureBoot
Cmdlet Get-Service Microsoft.PowerShell.Management
Cmdlet Get-SPAccessServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesDatabaseServer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesDatabaseServerGroup Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesDatabaseServerGroupMapping Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAlternateURL Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppAcquisitionConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppAutoProvisionConnection Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppDeniedEndpointList Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppDisablingConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppDomain Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppHostingQuotaConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppInstance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppPrincipal Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppScaleProfile Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppSiteSubscriptionName Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppStateSyncLastRunTime Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppStateUpdateInterval Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppStoreConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAuthenticationProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAuthenticationRealm Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBackupHistory Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBingMapsBlock Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBingMapsKey Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBrowserCustomerExperienceImprovementProgram Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBusinessDataCatalogEntityNotificationWeb Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBusinessDataCatalogMetadataObject Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBusinessDataCatalogThrottleConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPCertificateAuthority Microsoft.SharePoint.PowerShell
Cmdlet Get-SPClaimProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPClaimProviderManager Microsoft.SharePoint.PowerShell
Cmdlet Get-SPClaimTypeEncoding Microsoft.SharePoint.PowerShell
Cmdlet Get-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPContentDeploymentJob Microsoft.SharePoint.PowerShell
Cmdlet Get-SPContentDeploymentPath Microsoft.SharePoint.PowerShell
Cmdlet Get-SPCustomLayoutsPage Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDataConnectionFile Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDataConnectionFileDependent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDeletedSite Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDesignerSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDiagnosticConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDiagnosticsPerformanceCounter Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDiagnosticsProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDistributedCacheClientSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEduServiceSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchAdministrationComponent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchComponent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchContentEnrichmentConfigur… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlContentSource Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlCustomConnector Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlExtension Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlLogReadPermission Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlMapping Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchFileFormat Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchHostController Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchLanguageResourcePhrase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchLinguisticComponentsStatus Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchLinksDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchMetadataCategory Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchMetadataCrawledProperty Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchMetadataManagedProperty Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchMetadataMapping Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchOwner Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchPropertyRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchPropertyRuleCollection Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryAndSiteSettingsService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryAndSiteSettingsServi… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryAndSiteSettingsServi… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryAuthority Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryDemoted Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryKeyword Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryScope Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryScopeRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQuerySpellingCorrection Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQuerySuggestionCandidates Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchRankingModel Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchResultItemType Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchResultSource Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchSecurityTrimmer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchServiceApplicationBackupS… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchServiceInstance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchSiteHitRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchStatus Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchTopology Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchVssDataPath Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelBIServer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelBlockedFileType Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelDataConnectionLibrary Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelDataProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelFileLocation Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelUserDefinedFunction Microsoft.SharePoint.PowerShell
Cmdlet Get-SPFarm Microsoft.SharePoint.PowerShell
Cmdlet Get-SPFarmConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPFeature Microsoft.SharePoint.PowerShell
Cmdlet Get-SPHealthAnalysisRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPHelpCollection Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInfoPathFormsService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInfoPathFormTemplate Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInfoPathUserAgent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInfoPathWebServiceProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInternalAppStateSyncLastRunTime Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInternalAppStateUpdateInterval Microsoft.SharePoint.PowerShell
Cmdlet Get-SPIRMSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPLogEvent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPLogLevel Microsoft.SharePoint.PowerShell
Cmdlet Get-SPManagedAccount Microsoft.SharePoint.PowerShell
Cmdlet Get-SPManagedPath Microsoft.SharePoint.PowerShell
Cmdlet Get-SPMetadataServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPMetadataServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPMobileMessagingAccount Microsoft.SharePoint.PowerShell
Cmdlet Get-SPODataConnectionSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPODataConnectionSettingMetadata Microsoft.SharePoint.PowerShell
Cmdlet Get-SPOfficeStoreAppsDefaultActivation Microsoft.SharePoint.PowerShell
Cmdlet Get-SPPendingUpgradeActions Microsoft.SharePoint.PowerShell
Cmdlet Get-SPPerformancePointServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPPerformancePointServiceApplicationTrusted… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPPluggableSecurityTrimmer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProcessAccount Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProduct Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProfileLeader Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProfileServiceApplicationSecurity Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectDatabaseQuota Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectDatabaseState Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectEnterpriseProjectTaskSync Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectLogLevelManager Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectOdataConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectPCSSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectPermissionMode Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectQueueSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectWebInstance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRequestManagementSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRoutingMachineInfo Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRoutingMachinePool Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRoutingRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSDatabaseCreationScript Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSDatabaseRightsScript Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSDatabaseUpgradeScript Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSExtension Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSProxyUrl Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSServiceApplicationServers Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSSite Microsoft.SharePoint.PowerShell
Cmdlet Get-SPScaleOutDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPScaleOutDatabaseDataState Microsoft.SharePoint.PowerShell
Cmdlet Get-SPScaleOutDatabaseInconsistency Microsoft.SharePoint.PowerShell
Cmdlet Get-SPScaleOutDatabaseLogEntry Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSecureStoreApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSecureStoreSystemAccount Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSecurityTokenServiceConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServerScaleOutDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServerScaleOutDatabaseDataState Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServerScaleOutDatabaseInconsistency Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServerScaleOutDatabaseLogEntry Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationEndpoint Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationProxyGroup Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationSecurity Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceContext Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceHostConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceInstance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSessionStateService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPShellAdmin Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteAdministration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscription Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionEdiscoveryHub Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionEdiscoverySearchScope Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionFeaturePack Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionIRMConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionMetadataConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteUpgradeSessionInfo Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteURL Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSolution Microsoft.SharePoint.PowerShell
Cmdlet Get-SPStateServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPStateServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPStateServiceDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTaxonomySession Microsoft.SharePoint.PowerShell
Cmdlet Get-SPThrottlingRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTopologyServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTopologyServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTranslationThrottlingSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTrustedIdentityTokenIssuer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTrustedRootAuthority Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTrustedSecurityTokenIssuer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTrustedServiceTokenIssuer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUpgradeActions Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUsageApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUsageDefinition Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUsageService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUser Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserLicense Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserLicenseMapping Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserLicensing Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserSettingsProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserSettingsProviderManager Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserSolution Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioExternalData Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioPerformance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioSafeDataProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebApplicationAppDomain Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebApplicationHttpThrottlingMonitor Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebPartPack Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebTemplate Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWOPIBinding Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWOPISuppressionSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWOPIZone Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWorkflowConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWorkflowServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-Tpm TrustedPlatformModule
Cmdlet Get-TpmEndorsementKeyInfo TrustedPlatformModule
Cmdlet Get-TpmSupportedFeature TrustedPlatformModule
Cmdlet Get-TraceSource Microsoft.PowerShell.Utility
Cmdlet Get-Transaction Microsoft.PowerShell.Management
Cmdlet Get-TroubleshootingPack TroubleshootingPack
Cmdlet Get-TypeData Microsoft.PowerShell.Utility
Cmdlet Get-UICulture Microsoft.PowerShell.Utility
Cmdlet Get-Unique Microsoft.PowerShell.Utility
Cmdlet Get-Variable Microsoft.PowerShell.Utility
Cmdlet Get-WebAppDomain WebAdministration
Cmdlet Get-WebApplication WebAdministration
Cmdlet Get-WebApplicationMonitoringStatus Microsoft.MonitoringAgent.Pow…
Cmdlet Get-WebAppPoolState WebAdministration
Cmdlet Get-WebBinding WebAdministration
Cmdlet Get-WebCentralCertProvider WebAdministration
Cmdlet Get-WebConfigFile WebAdministration
Cmdlet Get-WebConfiguration WebAdministration
Cmdlet Get-WebConfigurationBackup WebAdministration
Cmdlet Get-WebConfigurationLocation WebAdministration
Cmdlet Get-WebConfigurationLock WebAdministration
Cmdlet Get-WebConfigurationProperty WebAdministration
Cmdlet Get-WebFilePath WebAdministration
Cmdlet Get-WebGlobalModule WebAdministration
Cmdlet Get-WebHandler WebAdministration
Cmdlet Get-WebItemState WebAdministration
Cmdlet Get-WebManagedModule WebAdministration
Cmdlet Get-WebRequest WebAdministration
Cmdlet Get-Website WebAdministration
Cmdlet Get-WebsiteState WebAdministration
Cmdlet Get-WebURL WebAdministration
Cmdlet Get-WebVirtualDirectory WebAdministration
Cmdlet Get-WheaMemoryPolicy Whea
Cmdlet Get-WIMBootEntry Dism
Cmdlet Get-WinAcceptLanguageFromLanguageListOptOut International
Cmdlet Get-WinCultureFromLanguageListOptOut International
Cmdlet Get-WinDefaultInputMethodOverride International
Cmdlet Get-WindowsDriver Dism
Cmdlet Get-WindowsEdition Dism
Cmdlet Get-WindowsErrorReporting WindowsErrorReporting
Cmdlet Get-WindowsImage Dism
Cmdlet Get-WindowsImageContent Dism
Cmdlet Get-WindowsOptionalFeature Dism
Cmdlet Get-WindowsPackage Dism
Cmdlet Get-WindowsSearchSetting WindowsSearch
Cmdlet Get-WinEvent Microsoft.PowerShell.Diagnostics
Cmdlet Get-WinHomeLocation International
Cmdlet Get-WinLanguageBarOption International
Cmdlet Get-WinSystemLocale International
Cmdlet Get-WinUILanguageOverride International
Cmdlet Get-WinUserLanguageList International
Cmdlet Get-WmiObject Microsoft.PowerShell.Management
Cmdlet Get-WSManCredSSP Microsoft.WSMan.Management
Cmdlet Get-WSManInstance Microsoft.WSMan.Management

Configure diagnostic logging SharePoint 2016

The SharePoint Server 2016 environment might require configuration of the diagnostic logging settings after initial deployment, after upgrade, and if a change is made to the environment, such as adding or removing a server.

The guidelines in the following list can help you form best practices for the specific environment.

* Change the drive to which the server writes logs:

By default, SharePoint Server 2016 writes diagnostic logs to the same drive and partition on which it was installed. Because diagnostic logging can use a large amount of drive space and compromise drive performance, you should configure SharePoint Server 2016 to write to another drive on which SharePoint Server 2016 is not installed.

You should also consider the connection speed to the drive on which SharePoint Server 2016 writes the logs. If verbose-level logging is configured, the server records a large amount of data. Therefore, a slow connection might result in poor log performance.

* Restrict log disk space usage:

By default, the amount of disk space that diagnostic logging can use is unlimited. Therefore, restrict the disk space that logging uses, especially if you configure logging to write verbose-level events. When the disk reaches the restriction, SharePoint Server 2016 removes the oldest logs before it records new logging data.

* Use the Verbose setting sparingly:

You can configure diagnostic logging to record verbose-level events. This means that SharePoint Server 2016 records every action that it takes. Verbose-level logging can quickly use drive space and affect drive and server performance. You can use verbose-level logging to record more detail when you are making critical changes and then reconfigure logging to record only higher-level events after you make the change.

* Regularly back up logs:

Diagnostic logs contain important data. Therefore, back up the logs regularly to ensure that this data is preserved. When you restrict log drive space usage, or if you keep logs for only a few days, SharePoint Server 2016 automatically deletes log files, starting with the oldest files first, when the threshold is met.

* Enable event log flooding protection:

When you enable this setting, SharePoint Server 2016 detects repeating events in the Windows event log, and suppresses them until conditions return to a typical state.

You can set the level of diagnostic logging for the event log and for the trace log. This limits the types and amount of information that are written to each log.

The following tables define the levels of logging that are available for the event log and trace log.

event-log-levels

trace-log-levels

Configure diagnostic logging by using Central Administration :

  1. In Central Administration, on the home page, click Monitoring.
  2. On the Monitoring page, in the Reporting section, click Configure diagnostic logging.
  3. On the Diagnostic Logging page, in the Event Throttling section, configure event throttling as follows:To configure event throttling for all categories:
    1. Select the All Categories check box.
    2. Select the event log level from the Least critical event to report to the event log list.
    3. Select the trace log level from the Least critical event to report to the trace log list.

    To configure event throttling for one or more categories:

    1. Select the check boxes of the categories that you want.
    2. Select the event log level from the Least critical event to report to the event log list.
    3. Select the trace log level from the Least critical event to report to the trace log list.

    To configure event throttling for one or more subcategories (you can expand one or more categories and select any subcategory):

    1. Click the plus (+) next to the category to expand the category.
    2. Select the check box of the subcategory.
    3. Select the event log level from the Least critical event to report to the event log list.
    4. Select the trace log level from the Least critical event to report to the trace log list.

    To return event throttling for all categories to default settings:

    1. Select the All Categories check box.
    2. Select Reset to default from the Least critical event to report to the event log list.
    3. Select Reset to default from the Least critical event to report to the trace log list.
  4. In the Event Log Flood Protection section, select the Enable Event Log Flood Protection check box.
  5. In the Trace Log section, in the Path box, type the path of the folder to which you want logs to be written.
  6. In the Number of days to store log files box, type the number of days (1-366) that you want logs to be kept. After this time, logs will automatically be deleted.
  7. To restrict the disk space that logs can use, select the Restrict Trace Log disk space usage check box, and then type the number gigabytes (GB) you want to restrict log files to. When logs reach this value, older logs will automatically be deleted.
  8. After you have made the changes that you want on the Diagnostic Logging page, click OK.

Configure diagnostic logging by using Windows PowerShell :

  1. Verify that you have the following memberships:
  • securityadmin fixed server role on the SQL Server instance.
  • db_owner fixed database role on all databases that are to be updated.
  • Administrators group on the server on which you are running the Windows PowerShell cmdlets.

An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint Server 2016 cmdlets.

  1. On the Start menu, click All Programs.
  2. Click SharePoint 2016.
  3. Click SharePoint 2016 Management Shell.
  4. To change the drive to which the server writes logs, at the Windows PowerShell command prompt, type the following command:

Set-SPDiagnosticConfig -LogLocation D:\DiagnosticLogs

  1. To restrict log disk space usage, at the Windows PowerShell command prompt, type the following command:

Set-SPDiagnosticConfig -LogMaxDiskSpaceUsageEnabled

Or assign the maximum disk space for logs:

Set-SPDiagnosticConfig -LogDiskSpaceUsageGB 500

  1. To view the current logging level, at the Windows PowerShell command prompt, type the following command:

Get-SPLogLevel

  1. To change the logging level, at the Windows PowerShell command prompt, type the following command:

Set-SPLogLevel -TraceSeverity Monitorable

To set all categories back to default levels, at the Windows PowerShell command prompt, type the following command, and then press ENTER:

Clear-SPLogLevel

9. To enable event log flooding protection, at the Windows PowerShell command prompt, type the following command:

Set-SPDiagnosticConfig -EventLogFloodProtectionEnabled

Monitor cache performance SharePoint 2016

SharePoint Server 2016 provides three types of caches that help improve the speed at which web pages load in the browser: the BLOB cache, the ASP.NET output cache, and the object cache.

The BLOB cache is a disk-based cache that stores binary large object files that are used by web pages to help the pages load quickly in the browser.

The ASP.NET output cache stores the rendered output of a page. It also stores different versions of the cached page, based on the permissions of the users who are requesting the page.

The object cache reduces the traffic between the web server and the SQL database by storing objects such as lists and libraries, site settings, and page layouts in memory on the front-end web server. As a result, the pages that require these items can be rendered quickly, increasing the speed with which pages are delivered to the client browser.

The monitors measure cache hits, cache misses, cache compactions, and cache flushes. The following list describes each of these performance monitors.

A cache hit occurs when the cache receives a request for an object whose data is already stored in the cache. A high number of cache hits indicates good performance and a good end-user experience.

A cache miss occurs when the cache receives a request for an object whose data is not already stored in the cache. A high number of cache misses might indicate poor performance and a slower end-user experience.

Cache compaction (also known as trimming), happens when a cache becomes full and additional requests for non-cached content are received. During compaction, the system identifies a subset of the contents in the cache to remove, and removes them. Typically these contents are not requested as frequently.

Compaction can consume a significant portion of the server’s resources. This can affect both server performance and the end-user experience. Therefore, compaction should be avoided. You can decrease the occurrence of compaction by increasing the size of the cache. Compaction usually happens if the cache size is decreased. Compaction of the object cache does not consume as many resources as the compaction of the BLOB cache.

A cache flush is when the cache is completely emptied. After the cache is flushed, the cache hit to cache miss ratio will be almost zero. Then, as users request content and the cache is filled up, that ratio increases and eventually reaches an optimal level. A consistently high number for this counter might indicate a problem with the farm, such as constantly changing library metadata schemas.

You can monitor the effectiveness of the cache settings to make sure that the end-users are getting the best experience possible. Optimum performance occurs when the ratio of cache hits to cache misses is high and when compactions and flushes only rarely occur. If the monitors do not indicate these conditions, you can improve performance by changing the cache settings.

The following sections provide specific information for monitoring each kind of cache.

Monitoring BLOB cache performance:

monitor-blob-cache

Note:
For the BLOB cache, a request is only counted as a cache miss if the user requests a file whose extension is configured to be cached. For example, if the cache is enabled to cache .jpg files only, and the cache gets a request for a .gif file, that request is not counted as a cache miss.

Monitoring ASP.NET output cache performance :

monitoring-asp-net-output-cache-performance

Note:
For the ASP.NET output cache, all pages are cached for a fixed duration that is independent of user actions. Therefore, there are flush-related monitoring events.

Monitoring object cache performance :

The object cache is used to store metadata about sites, libraries, lists, list items, and documents that are used by features such as site navigation and the Content Query Web Part.

This cache helps users when they browse to pages that use these features because the data that they require is stored or retrieved directly from the object cache instead of from the content database.

The object cache is stored in the RAM of each web server in the farm. Each web server maintains its own object cache.

You can monitor the effectiveness of the cache settings by using the performance monitors that are listed in the following table.

monitoring-object-cache-performance

“Unable to render the data. If the problem persists, contact your web server administrator.” error in SharePoint 2016 BCS

Created an external list SharePoint 2016 using business data connectivity services, configured secure store target application and created external list in SharePoint.
The external list displayed this error message with a correlation ID.

“Unable to render the data. If the problem persists, contact your web server administrator.”

unable-to-render-the-data-if-the-problem-persists-contact-your-web-server-administrator

ULS Log viewer found this message in the logs:

Error while executing web part: Microsoft.BusinessData.Infrastructure.BdcException: The shim execution failed unexpectedly – Unable to obtain the application proxy for the context.. —> Microsoft.Office.SecureStoreService.Server.SecureStoreServiceException: Unable to obtain the application proxy for the context.

Solution:

The web application is not associated with the secure store service application.

  • Go to SharePoint Central Administration site
  • Application management >> Click on Configure service application associations under Service Applications.
  • select the web application in which your site exist, Check the “Application proxy group” column >> Make sure the BDC and secure store service applications check boxes checked.

service-application-association-sharepoint-2016

SharePoint 2016 Help Collection

In this article, we will discuss ,how to use PowerShell cmdlets for managing Help Collections SharePoint.

SharePoint help collection is not configured with SharePoint Configuration, This needs to manually configured.SharePoint Help Files(.Cab) installed on the hive folder with SharePoint Installation but not configured by default. In order to configure it we have to run the PowerShell commands.

when users click on the Help button  on their site collection, they get the following error

help

” Unfortunately, Help Seems to be broken,There aren’t any help collections in the current language for the site you’re using.”

unfortunately-help-seems-to-be-broken

Even if go to Site settings > Site administration > Help Settings will get this

home-error

Clearly Help collection is broken and now it is SharePoint Admins responsibility to fix the broken Help Collection.

S0lution :

In order to fix the broken help collection, following activities needs to be done.

Check the CAB files exist
Get the Current Help File Status
Install the Help File(s)
Testing

Check Help Files :

Logon the SharePoint Server and browse to the hive folder.

Go to “C:\program Files\Common Files\microsoft shared\web server extensions\16\HCCab

In this folder, make sure you see cab files for 14 & 15.

cab-file

If you have multiple language packs then check each language folder i.e English is 1033

  • Log on the server with farm admin account
  • Open PowerShell windows (Run as Administrator)
  • Run the Get-sphelpcollection command

get-sphelp

you can see nothing return even command completed successfully

Install Help files :

install all the available help,run the command with all options

  • Log on the server with farm admin account
  • Open PowerShell (Run as Administrator) and run Install-SPHelpCollection – All

install-sphelp

This command will install the help files available in the hive folder.
Wait for 5 minutes to completely install it, if you have multiple language packs install then even wait little more.
Now run Get-SpHelpCollection and you will get something like this.

get-sphelp2

Test it at both locations via site settings as well as from the browsing the Site collection.

Go to Site collection > Site settings > help Settings and you will see this option

home

Now if you click on the “?” (help button) on the top suite bar, you will get this pop up

central-admin-help

Uninstall :

As we noticed, we have 2010 help files also installed, we have to uninstall one by one.

  • Log on the server with farm admin account
  • Open PowerShell ( Run as administrator) and run this command
  • Uninstall-SpHelpCollection –Name “OSSEndUser.1033.12”

uninstall-help

Conclusion :

In this session we learned how to fix the broken Help Collection.

Keep reading and learning.