sharepoint-content-database-1920x1080

content database in sharepoint

Advertisements
Advertisements

content database in sharepoint

A content database in sharepoint is not the database server itself but container for all the content for a single web application.

manage-content-databases-1277x640
content database in sharepoint

You can have only one content database for one web application however, you can separate content for multiple websites into multiple content databases for a site collection. You can also use a single content database for multiple site collections, keeping in mind that the site collection or collections represent a single web app.

we can run the powershell command as below to get quick details however can get from “Central Admin -> Application Management”  under “View all Site Collections”.

Get-SPContentDatabase
Get-SPContentDatabase-985x390
Get-SPContentDatabase-1898x653
Get-SPContentDatabase-1896x636
Advertisements
Advertisements

Isolation and sharing are expressed as the difference between one site collection using one database and numerous site collections sharing a database. The number of site collections using a database is also a scaling and performance issue. If you are deploying site collections with a high workload attached and greater expectancy for growth, make sure to use fewer site collections per database. You can also plan your content database strategy by adding databases to site collections as they grow or associate specific site collections only with specific content databases. The latter approach lets you isolate a database serving particular site collections from all the other databases and thus isolate the content it contains.

Advertisements
Advertisements

boundaries and limits content databases

There can be 500 content databases per farm at max. With 200GB data per content database and 100TB of data per farm. 60 million items including documents and list items. Number of site collections per content database recommended to 5,000. However, up to 10,000 site collections are supported.2500 non-Personal site collections and 7500 Personal Sites or 10000 Personal Sites alone. find in details from Microsoft Doc Link.

content database for each site collection powershell

We can run below powershell command to know which content database your site collection attached to.

$site = Get-SPSite "http://win2016:37344/sites/SPmcse"
write-host $site.WebApplication.ContentDatabases

or

$url="http://win2016:37344/sites/SPmcse"
(Get-SPSite $url).ContentDatabase.name
Get-SPContentDatabase-1920x1303
Get-SPContentDatabase-1048x480
Advertisements
default-zone-1918x1088

zones in sharepoint

Advertisements
Advertisements

default zone in SharePoint

Zones are different logical paths expressed as URLs that allow access to the same web application. The default zones in sharepoint is 5. A web application can support up to five Default Zones. The available zone names are Default, Extranet, Intranet, Internet, and Custom. 

default-zone-1236x552

default-zone-1206x341

One particular zone name can be used per web application. Zones using the same name across different web applications typically are available for the same user pool to control access for that group. For instance, your internal employees can use the Intranet zone to access all of the SharePoint sites configured to use that zone, giving that group the same sort of access to all relevant web applications. Each zone is expressed as a separate website in IIS. Zones isolate users based on authentication type, network zone, and policy. All zones have own Port number and Protocol http/https. Different authentication methods can be applied to login different zones like Forms authentication in Intranet and default Windows authentication. we can configure Blob and Distributed cache differently for different zones. When planning for zone deployment, particular attention must be paid to the Default zone, since access to this zone may be gained by anyone who is able to use a link to this zone, such as a URL sent via an automated administrative email. The Default one or any zone used for an outward-facing site must possess a high level of security.

Advertisements
Advertisements
sharepoint-2016-site-template-1920x1080

sharepoint templates

Advertisements
Advertisements

sharepoint templates

This post describes the list of sharepoint templates and template id present. we can use the powershell command to get sharepoint templates list in sharepoint 2016.

Get-SPWebTemplate | Format-Table -wrap
NameTitle
GLOBAL#0 Global template
STS#0 Team Site
STS# 1 Blank Site
STS#2 Document Workspace
MPS#0 Basic Meeting Workspace
MPS#1 Blank Meeting Workspace
MPS#2 Decision Meeting Workspace
MPS#3 Social Meeting Workspace
MPS#4 Multipage Meeting Workspace
CENTRALADMIN#0 Central Admin Site
WIKI#0 Wiki Site
BLOG#0 Blog
SGS#0 Group Work Site
TENANTADMIN#0 Tenant Admin Site
APP#0 App Template
APPCATALOG#0 App Catalog Site
ACCSRV#0 Access Services Site
ACCSVC#0 Access Services Site Internal
ACCSVC#1 Access Services Site
BDR#0 Document Center
TBH#0 In-Place Hold Policy Center
DEV#0 Developer Site
EDISC#0 eDiscovery Center
EDISC#1 eDiscovery Case
OFFILE#0 (obsolete) Records Center
OFFILE#1 Records Center
OSRV#0 Shared Services Administration Site
PPSMASite#0 PerformancePoint
BICenterSite#0 Business Intelligence Center
PWA#0 Project Web App Site
PWS#0 Microsoft Project Site
POLICYCTR#0 Compliance Policy Center
SPS#0 SharePoint Portal Server Site
SPSPERS#0 SharePoint Portal Server Personal S
SPSPERS#2 Storage And Social SharePoint Porta
SPSPERS#3 Storage Only SharePoint Portal Serv
SPSPERS#4 Social Only SharePoint Portal Serve
SPSPERS#5 Empty SharePoint Portal Server Pers
SPSPERS# 6 Storage And Social SharePoint Porta
SPSPERS#7 Storage And Social SharePoint Porta
SPSPERS#8 Storage And Social SharePoint Porta
SPSPERS#9 Storage And Social SharePoint Porta
SPSPERS#10 Storage And Social SharePoint Porta
SPSMSITE#0 Personalization Site
SPSTOC#0 Contents area Template
SPSTOPIC#0 Topic area template
SPSNEWS#0 News Site
CMSPUBLISHING#0 Publishing Site
BLANKINTERNET#0 Publishing Site
BLANKINTERNET#1 Press Releases Site
BLANKINTERNET#2 Publishing Site with Workflow
SPSNHOME#0 News Site
SPSSITES#0 Site Directory
SPSCOMMU#0 Community area template
SPSREPORTCENTER#0 Report Center
SPSPORTAL#0 Collaboration Portal
SRCHCEN#0 Enterprise Search Center
PROFILES#0 Profiles
BLANKINTERNETCONTER#0Publishing Portal
SPSMSITEHOST#0 My Site Host
ENTERWIKI#0 Enterprise Wiki
PROJECTSITE#0 Project Site
PRODUCTCATALOG#0 Product Catalog
COMMUNITY#0 Community Site
COMMUNITYPORTAL#0 Community Portal
GROUP#0 Group
POINTPUBLISHINGHUB#0 PointPublishing Hub
POINTPUBLISHINGPERSONAL#0PointPublishing Personal
POINTPUBLISHINGTOPIC#0PointPublishing Topic
SRCHCENTERLITE#0 Basic Search Center
SRCHCENTERLITE#1 Basic Search Center
visprus# 0 Visio Process Repository
GLOBAL#0 Global template
STS#0 Team Site
STS#1 Blank Site
STS#2 Document Workspace
MPS#0 Basic Meeting Workspace
MPS#1 Blank Meeting Workspace
MPS#2 Decision Meeting Workspace
MPS#3 Social Meeting Workspace
MPS#4 Multipage Meeting Workspace
CENTRALADMIN#0 Central Admin Site
WIKI#0 Wiki Site
BLOG#0 Blog
SGS#0 Group Work Site
TENANTADMIN#0 Tenant Admin Site
ACCSRV#0 Access Services Site
ACCSRV#1 Assets Web Database
ACCSRV#3 Charitable Contributions Web Database
ACCSRV#4 Contacts Web Database
ACCSRV#6 Issues Web Database
ACCSRV#5 Projects Web Database
BDR#0 Document Center
OFFILE#0 (obsolete) Records Center
OFFILE#1 Records Center
OSRV#0 Shared Services Administration Site
PPSMASite#0 PerformancePoint
BICenterSite#0 Business Intelligence Center
PWA#0 Project Web App Site
PWS#0 Microsoft Project Site
SPS#0 SharePoint Portal Server Site
SPSPERS#0 SharePoint Portal Server Personal Site
SPSMSITE#0 Personalization Site
SPSTOC#0 Contents area Template
SPSTOPIC# 0 Topic area template
SPSNEWS#0 News Site
CMSPUBLISHING#0 Publishing Site
BLANKINTERNET#0 Publishing Site
BLANKINTERNET#1 Press Releases Site
BLANKINTERNET#2 Publishing Site with Workflow
SPSNHOME#0 News Site
SPSSITES#0 Site Directory
SPSCOMMU#0 Community area template
SPSREPORTCENTER#0 Report Center
SPSPORTAL#0 Collaboration Portal
SRCHCEN#0 Enterprise Search Center
PROFILES#0 Profiles
BLANKINTERNETCONTAINER#0Publishing Portal
SPSMSITEHOST#0 My Site Host
ENTERWIKI#0 Enterprise Wiki
SRCHCENTERLITE#0 Basic Search Center
SRCHCENTERLITE#1 Basic Search Center
SRCHCENTERFAST#0 FAST Search Center
visprus#0 Visio Process Repository
Advertisements
Advertisements
sharepoint templates
sharepoint-2016-site-template-1109x1040
sharepoint-2016-site-template-1106x1040.jpg
sharepoint-2016-site-template-1100x523
Advertisements
Advertisements
internal-server-error-exception-1920x1304

internal server error exception sharepoint search

internal server error exception sharepoint search

There is an internal server error exception sharepoint search.  When users perform a search in a Microsoft SharePoint environment, they receive the following error message:

Internal server error exception: Troubleshoot issues with Microsoft SharePoint Foundation
Additionally, the following critical exception may be written to the ULS log of the SharePoint Web front-end server:
Process: OWSTIMER.EXE (0x1CE0)
Product: SharePoint Foundation
Category: Topology
EvendID: 8031

Message:
An exception occurred while updating addresses for connected app {eaf6c00c-cc3f-460e-8bf2-ad9b991ea6ea_aa16845d-045a-46bc-bbc6-d701ff13950d}. The uri endpoint information may be stale. System.InvalidOperationException: The requested application could not be found at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ProcessCommonExceptions(Uri endpointAddress, String operationName, Exception ex, SPServiceLoadBalancerContext context) at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ExecuteOnChannel(String operationName, CodeBlock codeBlock) at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.GetEndPoints(Guid serviceId) at Microsoft.SharePoint.SPConnectedServiceApplicationAddressesRefreshJob.Execute(Guid targetInstanceId) bf94139a-66f8-4aab-af31-406a5ebb6db9

Cause

This issue occurs when the Search service application proxy is associated with a web application but is not associated with any Search service applications in the farm.

Resolution

To allow users to search without receiving this error message, re-associate the web application with a valid Search service application proxy. A valid Search service application proxy will be associated with a Search service application in the Manage service applications option. To do this, follow these steps:

  • Open Central Administration.
  • Click Manage web applications.
  • Select the affected web application.
  • On the ribbon, click Service Connections.
  • Under Configure Service Application Associations, select the valid Search service application proxy check box.

you can find the Microsoft support link from here

application-pools-in-iis-1920x1080

application pools in iis overview

Advertisements
Advertisements

application pools in iis overview

As defined in Internet Information Services (IIS) an application Pool is a collection of one or more URLs that are serviced by one or a set of worker processes. After installation of SharePoint, open IIS Manager. You will notice application pools in iis.

application-pool-iis-manager-969x476

You must select an existing Application Pool or create a new pool whenever you create a service or web application in SharePoint Server.

create-new-application-pool-1314x453

application pools in iis allow multiple SharePoint websites to run on a single server without the processes or code in one site interacting with any other sites. This is primarily a security benefit, since any outside intrusion on one site is isolated. Also, problematic or poor code running on one site is isolated so that other sites on the server are unaffected. For these reasons, you should plan to use dedicated application pools to isolate authenticated content and separate applications that contain password information.

we can run powershell command to get all application pools.

Advertisements
Advertisements
Get-IISAppPool
Get-IISAppPool-754x567

we can search one or more application pool directly by running the below command.

Get-IISAppPool "DefaultAppPool","SharePoint - 37344"
Get-IISAppPool-information-875x192
Service-Applications-in-SharePoint-1920x1080

Service Applications in SharePoint

Advertisements
Advertisements

Service Applications in SharePoint

Service Applications in SharePoint are associated with web applications, and specific services are typically deployed as needed in a particular farm. Only deployed services are referred to as service applications. This is a huge advantage in terms of conserving resources and optimizing performance. For instance, a specific web application can be configured to use only the services it needs. The number of service applications that exist is vast, and, as third-party vendors can create their own services for SharePoint Server. A list of services includes the following:

You can set up a single service application to be shared among multiple web applications or deploy multiple instances of the same service across a farm and, in some cases, across multiple farms. Also, there is no limitation regarding the number of services that can be deployed in any single farm. A typical planning scenario requires that you either set up services to share across multiple web applications or isolate an individual service to one or a limited number of web applications. We can publish below service applications across the farm.

  • Business Data Connectivity
  • Machine Translation
  • Managed Metadata
  • User Profile
  • Search
  • Secure Store

Navigate to “Central Admin -> Application Management ->Manage Service Applications” and click on “New” from ribbon to see the list of service applications available.

Service-Applications-in-SharePoint-1300x674
Advertisements
Advertisements

you can use powershell command to get the list of  service applications

Get-SPServiceApplication | Format-Table -wrap
Service Applications in SharePoint
Get-SPServiceApplication
Get-SPServiceApplication -Identity 48fbecaa-71e4-4f1d-bdfe-bdcbc17fa061 | Format-Table -wrap
Get-SPServiceApplication-1324x186

sharepoint services 2016

For every service application there is a service associated with it which you can from central admin by navigating to “Central Admin -> Application Management -> Manage Services on Server”.

manage-services-on-server-1273x441
services-on-server-1324x870
Advertisements
Advertisements

Alternatively you can use the powershell command as below

Get-SPServiceInstance | Format-Table -wrap
Get-SPServiceInstance-873x1099
Get-SPServiceInstance | Where {$_.Status -eq "Online"} | Format-Table -wrap
Get-SPServiceInstance-formt-1154x933

Similarly we can start the service instance by running the below command.

Start-SPServiceInstance e63962e4-e1ea-4b83-a9cc-df51683e85f3