Monthly Archives December 2015


When doing development on a SharePoint development server, there may be the need to create multiple web applications. To prevent conflicts there are two possibilities: either use host headers or use a different port. To support host headers we can either add additional DNS entries or use the HOSTS file (C:Windows\System32\drivers\etc). Read more

Maximum Degree of Parallelism (MAXDOP) is a SQL server instance level setting that defines the number of processors used for the execution of a query in a parallel plan. It defines the computing and thread resources used for query plan operators that perform the work in parallel. Although many of the solutions using SQL server as a database back-end may profit from the parallelism, SharePoint is one of the solutions that works best when the parallel execution is turned off (MAXDOP=1). For SharePoint 2007 and 2010, it is the recommended setting; however, for SharePoint 2013, it is a hard requirement Read more

There is a formula that can be used to predict the amount of space required for any given database.

Following is a description of the variables and their respective descriptions:

Variables Descriptions
D The expected number of documents in a content database
The average size of the documents to be stored
L The number of list items (roughly three times the number of documents
V The number of retained version for a document; the default value is 1 for the document
M The estimated amount of metadata (a constant of 10 KB that can be adjusted if your environment  is more metadata-intensive

An estimate for size of any given content database is the given by this formula Read more