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

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.

Content databases contain orphaned Apps SharePoint 2013

SharePoint Health Analyzer rule “Content databases contain orphaned Apps.”

Some situation content database may become corrupted. The corrupted database may contain orphaned apps. Orphaned apps are not accessible, which causes unnecessary resource and license consumption and may result in failures in SharePoint upgrade.

Solution:

Remove app for SharePoint instances from a SharePoint 2013 site.

A user must have the Manage Web site permission to remove an app for SharePoint. By default, this permission is only available to users with the Full Control permission level or who are in the site Owners group.

To remove an app from a SharePoint site

  1. Verify that the user account that is performing this procedure is a member of the Site owners group.
  2. On the site, on the Settings menu, click View Site Contents.
    In the Apps section, point to the app that you want to remove, click …, and then 3. click Remove.
  3. Click OK to confirm that you want to remove the app.

To remove an app by using Windows PowerShell

Verify that you have the following memberships:

a. securityadmin fixed server role on the SQL Server instance.
b. db_owner fixed database role on all databases that are to be updated.
c. Administrators group on the server on which you are running the Windows PowerShell cmdlets.
d. Site Owners group on the site collection to which you want to install the app.

An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 15 Products cmdlets.

On the Start screen, click SharePoint 2013 Management Shell.

type the following commands, and press ENTER after each one:

$instances = Get-SPAppInstance -Web
#Gets all apps installed to the subsite you specify.

$instance = $instances | where {$_.Title -eq ”}
#Sets the $instance variable to the app with the title you supply.

Uninstall-SPAppInstance -Identity $instance
#Uninstalls the app from the subsite.

is the path site collection or subsite that contains the app.
is the title of the app you want to remove.

At the question “Are you sure you want to perform this action?”,
type Y to uninstall the app.

Locate and remove app instances in all locations

An app for SharePoint in the App Catalog is available for users to install.Users can install apps for SharePoint on many sites.

Below two Windows PowerShell scripts can be used to find all locations for a specific app and then uninstall all instances from every location.

First script to locate all instances of a specific app in a SharePoint environment. Then use the second script to uninstall all instances of the app from the SharePoint environment.

To locate specific apps by using Windows PowerShell (save as script and run script)

Verify that you have the following memberships:

a. securityadmin fixed server role on the SQL Server instance.
b. db_owner fixed database role on all databases that are to be updated.
c. Administrators group on the server on which you are running Windows PowerShell cmdlets.

An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets

1. save the below script as “Get-AppInstances.ps1”

This Windows PowerShell script gets all app instances from your SharePoint 2013 farm for a specified App ID on a specified web application. You specify the App ID and the web application URL and the script will remove all of the instances of the App for all webs in that web application.

param(
[Parameter(Mandatory=$true)] [Guid] $productId,
[Parameter(Mandatory=$true)] [String] $webAppUrl
)

function GetAllInstances($productId = $null, $webAppUrl = $null)
{
$outAppName = “”;
$sites = Get-SPSite -WebApplication $webAppUrl
$outWebs = @()
foreach($site in $sites){
if($site.AdministrationSiteType -ne “None”){
continue;
}
$webs = Get-SPWeb -site $site
foreach($web in $webs) {
$appinstances = Get-SPAppInstance -Web $web
foreach($instance in $appinstances) {
if($productId -eq $instance.App.ProductId) {
if ($outAppName -eq “”) {
$outAppName = $instance.Title;
}
$outWebs += $web;
}
}
}
}
return ($outAppName,$outWebs)
}
Write-Host “This script will search all the sites in the webAppUrl for installed instances of the App.”
$confirm = Read-Host “This can take a while. Proceed? (y/n)”
if($confirm -ne “y”){
Exit
}

$global:appName = $null;
$global:webs = $null;

{
$returnvalue = GetAllInstances -productId $productId -webAppUrl $webAppUrl;
$global:appName = $returnvalue[0];
$global:webs = $returnvalue[1];
}
);

$count = $global:webs.Count;
if($count -gt 0){
Write-Host “App Name:” $global:appName;
Write-Host “Product Id: $productId”;
Write-Host “Number of instances: $count”;
Write-Host “”;
Write-Host “Urls:”;

foreach($web in $global:webs) {
Write-Host $web.Url;
}
}
else {
Write-Host “No instances of the App with Product Id $productId found.”;
}
return;

  1. Now Open “SharePoint 2013 Management Shell”
  2. Change to the directory where you saved the file.

  3. At the Windows PowerShell command prompt, type the following command:

./ Get-AppInstances.ps1 -productId -webAppUrl

is the GUID ID of the App
and is the full URL of the web application.

To uninstall specific apps from all locations by using Windows PowerShell (save as script and run script)

1. Verify that you have the following memberships:

a. securityadmin fixed server role on the SQL Server instance.
b. db_owner fixed database role on all databases that are to be updated.
c. Administrators group on the server on which you are running Windows PowerShell cmdlets.

An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets

2. save the below script as “Remove-App.ps1”

This Windows PowerShell script removes all app instances from your SharePoint 2013 farm for a specified App ID on a specified web application. You specify the App ID and the web application URL and the script will remove all of the instances of the App for all webs in that web application.

param(
[Parameter(Mandatory=$true)] [Guid] $productId,
[Parameter(Mandatory=$true)] [String] $webAppUrl
)

function RemoveInstances($productId = $null, $webAppUrl = $null)
{
$outAppName = “”;
$sites = Get-SPSite -WebApplication $webAppUrl
$outWebs = @()
foreach($site in $sites){
if($site.AdministrationSiteType -ne “None”){
continue;
}
$webs = Get-SPWeb -site $site
foreach($web in $webs) {
$appinstances = Get-SPAppInstance -Web $web
foreach($instance in $appinstances) {
if($productId -eq $instance.App.ProductId) {
if ($outAppName -eq “”) {
$outAppName = $instance.Title;
}
$outWebs += $web;
Write-Host “Uninstalling from” $web.Url;
Uninstall-SPAppInstance -Identity $instance -confirm:$false
}
}
}
}
return ($outAppName,$outWebs)
}

$confirm = Read-Host “This will uninstall all instances of the App and is irreversible. Proceed? (y/n)”
if($confirm -ne “y”){
Exit
}

$global:appName = $null;
$global:webs = $null;

{
$returnvalue = RemoveInstances -productId $productId -webAppUrl $webAppUrl;
$global:appName = $returnvalue[0];
$global:webs = $returnvalue[1];
}
);

$count = $global:webs.Count;
if($count -gt 0){
Write-Host “All the instances of the following App have been uninstalled:”;
Write-Host “App Name:” $global:appName;
Write-Host “Product Id: $productId”;
Write-Host “Number of instances: $count”;
Write-Host “”;
Write-Host “Urls:”;

foreach($web in $global:webs) {
Write-Host $web.Url;
}
}
else {
Write-Host “No instances of the App with Product Id $productId found.”;
}
return;

  1. Open SharePoint 2013 Management Shell
  • Change to the directory where you saved the file.

  • At the Windows PowerShell command prompt, type the following command:

  • ./ Remove-App.ps1 -productId -webAppUrl

    is the GUID ID of the App
    is the full URL of the web application.

    If the issue still persists like as below

    If you have an orphaned app in the initialized state on a site and you delete the site, Health Analyzer reports that there’s an error and the auto-fix doesn’t work.”

    Apply CU November 2016 which will 100% resolve the issue

    SharePoint Server 2013 (KB3127933)
    SharePoint Foundation 2013 (KB3127930)

    SharePoint 2016: 16 Hive and other important directories default location

    Folder Location :

    The 16 Hive folder is located at the following path

    C:\Program Files\Common files\Microsoft Shared\Web Server Extensions\16

    16 Hive and other important directories location SharePoint2016

    16 Hive and other important directories location SharePoint 2016

    Folder Structure :

    The 16 Hive has a definite folder structure which holds the core SharePoint server files.

    ADMISAPI:- It contains soap services for Central Administration. If this directory is altered, remote site creation and other methods exposed in the service will not function correctly.

    Bin:- The directory contains all the core binary files, utilities which used by SharePoint Services. command line tools such as STSADM.EXE also present in this folder.

    Client:- This directory contains files that are used for creating office apps.

    Config:- This directory contains files used to extend IIS Web sites with SharePoint Server. If this directory or its contents are altered, Web application will not function correctly.

    GAC:- This folder contains Microsoft.SharePoint.Client.Runtime.Portable.Resources.dll and Microsoft.SharePoint.Client.Runtime.Resources.DLL.

    HCCab:- This directory has a set of cab files which has content information used by the SharePoint help system.

    Help:- The folder contains html help file (.chm) used by the configuration wizard.

    ISAPI:- This directory contains all the standard Web Services for SharePoint and resources and configuration files that the web services use.

    Logs:- This is the folder where we can have all the SharePoint related logs will see. This is important when any problem or error occur in SharePoint you have to trace the logs files in this folder to get the error messages.

    Policy:- This directory contains SharePoint 2016 Server policy files.

    Resources:- This directory contains the core.resx file used for creating language packs for SharePoint. by which different SharePoint sites with different languages and cultures can be create.

    Template:- It contains the core web site functionality like the features, templates, configurations, resources of a web site.

    UserCode:- This directory contains files used to support sandbox solution.

    Web Clients:- This directory contains files related to Client Object Model.

    Web Services:- This directory is the root directory where SharePoint back-end Web services are hosted, for example, Excel and Search.

    Other Directories In SharePoint 2016 :

    C:\Inetpub\wwwroot\wss – This directory (or the corresponding directory under the Inetpub root on the server) is used as the default location for IIS Web sites.

    C:\ProgramFiles\Microsoft Office Servers\16.0 – This directory is the installation location for SharePoint Server 2016 binaries and data. The directory can be changed during installation.

    C:\ProgramFiles\Microsoft Office Servers\16.0\WebServices – This directory is the root directory where SharePoint back-end Web services are hosted, for example, Excel and Search.

    C:\ProgramFiles\Microsoft Office Servers\16.0\Data – This directory is the root location where local data is stored, including search indexes.

    C:\ProgramFiles\Microsoft Office Servers\16.0\Logs – This directory is the location where the run-time diagnostic logging is generated.

    Activate site Features create APP in Site Contents SharePoint2016

    Today I successfully installed SharePoint Server 2016 on-premises overcoming few errors related to prerequisite as per my previous posts.

    You can see below previous posts :

    1. Windows Server Appfabric: Installation error SharePoint 2016
    2. Cannot connect to database master at SQL Server at server_name. The database might not exist, or the current user does not have permission to connect to it Error SharePoint 2016
    3. Failed to create configuration database. An exception of type Microsoft.SharePoint.Upgrade. SPUpgrade Exception was thrown. Additional exception information: One or more types failed to load. Please refer to the upgrade log for more details Error SharePoint 2016
    4. Program can’t start because api-ms-win-crt-heap-l1-1-0.dll is missing SharePoint2016
    5. Unable to install Microsoft Information Protection and control Client 2.1 error SharePoint 2016

    Here I am very excited to let you know the “SharePoint APP” created in “Site Contents” by activating the “site feature“.

    you may take it very easy but its not as simple as to resolve issues sometimes, that time it will help you a lot.

    a. “Default APP” once site is created, before activating any feature.

    Default APP in Site Contents with no feature activate

    Default APP in Site Contents with no feature activate, once site is created

    b. New APPs  added in Site Contents  after “Publishing Feature” is activated

    New APPs added in Site Contents after

    New APPs added in Site Contents after “Publishing Feature” is activated

    c. New APPs  added in Site Contents  after “Content Organizer” feature is activated.

    New APPs added in Site Contents after

    New APPs added in Site Contents after “Content Organizer” feature is activated.

    d. New APPs  added in Site Contents  after “Community Site” feature is activated.

    Site-Contents-Community-Site-Feature-activate

    Site-Contents-Community-Site-Feature-activate

    e. New APPs  added in Site Contents  after “Site Feed” feature is activated.

    New APPs added in Site Contents after

    New APPs added in Site Contents after “Site Feed” feature is activated.

    f. New APPs  added in Site Contents  after “Project Functionality” feature is activated.

    New APP created once

    New APP created once “Project Functionality” feature is activated.

    amazon     amazonsp2016  amazonsp2016_2