Friday, October 17, 2014

How to increase server resource quota?

As an administrator, you can also specify the resource usage quota. SharePoint then monitors the resource usage level for a site collection against this quota. To monitor the resource usage level, SharePoint collects performance data such as processor time and unhandled exceptions that relate to custom code being used in sandboxed solutions. When resource usage level exceeds the daily quota, SharePoint turns off the sandbox for the site collection; then, custom code cannot run. Resource usage quotas can reduce the risk that custom code will adversely affect the performance of a site collection. You can also set an alert to be notified by email when the resource usage level for the site collection approaches its limit.

The server resource quota is by default 300 for every tenant. Increasing that limit is necessary if you use any Sandbox solutions. Increasing this limit will give your tenant more RAM and CPU power.

This can be done form Office 365 Admin center. Just follow the steps below to achive that:

  • From the admin menu choose SharePoint
  • From the lsit of Site Collections choose the site collection that you desire to increase the server resource


  • From the ribbon choose server resource quota


  • Change the size to desired value


  • Enable the options to send an email when the usage limit reaches 80%
  • Press save to save the new values

In some scenarios you may recieve a SharePoint error with a correlation ID, when you try to do this operation. Then PowerShell will be your best friend. Here are the steps to do it by PowerShell:

  • Start SharePoint Online Management Shell   
  • Type: Connect-SPOService -Url -credential
  • Get-SPOSite -Identity
  • Set-SPOSite -Identity -ResourceQuota 600 -StorageQuota 15000

Replace contoso with your domain and for credential change to your admin credential.

The values are in MB!

How to increase the capacity of your SPO tenant?

According to Microsoft latest article regarding SharePoint Online software boundaries and limits, the maximum size of a tenant can be 1 TB and can contain no more than 500,000 site collections. The minimum storage allocation per site collection is 100 MB. The default tenant storage is (10 GB + number of subscribed users * 500 MB). So if we have a customer with 20 subscribed users, the default assigned size for the tenant will be 10 GB + (10 * 500 MB) = 15 GB.

Beside the assigned tenant size, every subscribed user receives 1 TB of extra capacity as soon as personal site is provisioned for that user.

In some scenarios a customer may want to increase the storage capacity. We had a customer that needed to increase the capacity of a tenant by 50 GB, in aim to migrate documents from a file server to SharePoint Online. We couldn’t find any solution to add more capacity from the Office 365 admin center. The subscription was purchased as open subscription and no add-ons were available beneath “Purchase Service”.

The customer had in this situation two options, the first one was to buy 100 more subscriptions and receive 100 * 500 MB, which could give 50 GB. But this option was unnecessary and very expensive. If the customer have chosen this option it would have cost them 41,000 Swedish krona/year.

The second and the better option was to add a SharePoint Online P1 subscription with only 1 user and then add capacity add-on for 50 GB. This will cost them 1500 Swedish crowns/year!

Here are the steps to add the capacity:

  • Navigate and logon to your Office 365 admin center
  • On the left menu press PURCHASE SERVICES
  • From available service find SharePoint Online (Plan 1)


  • On the right side press Add


  • Ensure that you have only 1 user license
  • Beneath the user license you will find a drop down arrow for optional add-ons
  • Press the arrow and fill the desired capacity


  • Press add to the cart
  • Then press check out
  • Pay by a credit card for athe entire year or per month.


  • Your order will be processed and the capacity will be added to your tenant
  • Then you can use it for any Site collection you need to expand

Friday, May 02, 2014

Drive to Office 365

Microsoft has recently announced 1 TB for OneDrive for business in Office 365. That will be a game changer move and is very welcomed and appriciated from the customers. One question that always pop up during customer meetings is how can we migrate from Google Drive, DropBox or Box to OneDrive for Business?

I’m pretty sure that Microsoft will provide the customers with a tool soon, since that has always been Microsoft strategy to ease the migration to their products. Meanwhile a customer can use a tool like Metalogix Drive 2 Office 365.


Friday, August 30, 2013

Estimate content database size

Keywords: Content database, SharePoint boundaries, Versioning

It’s not an easy task to estimate the total required storage for a content database in SharePoint 2013, since it depends on many factors as number of documents, versioning, amount of deleted files in recycle bin, Metadata used for each file and amount of list items. There is a formula for calculating the size and it should be used to give an approximation, not an exact value. The growth of the database must be measured during a time period to be able to establish a baseline.

Content Database size = ((D x V) x S) + (10 KB x (L + (V x D)))

D = Number of Documents
V = Number of Versions
S = Average Size of documents. Must be above Zero!
L = Number of List items
10 KB = Average size of metadata that SharePoint store for each file

D1 = Number of documents = 200,000
V2 = Number of non-current versions = 2
S = Average size of documents = 250 KB
L = List items = 600,000

Content Database size = (((200,000 x 2)) × 250) + ((10 KB × (600,000 + (200,000 x 2))) = 110,000,000 KB or 105 GB

1 - Calculated by assuming 10,000 users times 20 documents
2 - Assuming that the maximum versions allowed is 10

Some reminders:
Maximum content databases per farm are 500
Maximum supported size of content database for general usage scenarios is 200 GB
Maximum supported size of content database for all other usage scenarios is 4 TB. Some conditions must be met when using content databases larger than 4 TB. Read more

Happy calculating


/Henrik A. Halmstrand

Thursday, August 29, 2013

Access Request in SharePoint 2013

Keywords: Access Request, Outgoing E-mail settings, Access denied
Access request and invitations

Access request is a new feauture in SharePoint 2013 that make it possible to ask for permission to access a site! Without enabling access request, the user will recieve a message that this site is not shared with you! There will be no way of asking for permission to access the site except sending an email to the owner, and if the owner is unknown, then good luck! :)

To enable this feature, you need first of all to enable outgoing email settings from Central administration page. Without doing this the link will not appear beneath site settings—>Users and permissions!

Before enabling outgoint E-mail settings



After enabling outgoint E-mail settings



After that you need to enable Access request and specify an email address for the site owner:


When it’s done the users that visit the site and don’t have permission will recieve a message like this:


After sending the request this message will appear:


The user tells the owner why he/she needs to access the site! The owner of the site will be able to check all pending request from site settings—>Users and Permissions—>Access Request and invitations.


From the elipses the owner can choose to approve or decline the request. The owner can also choose to send a motivation for the decision taken:


When approved the user will recieve an email stating that permission has been granted to access the site!



/Henrik A. Halmstrand

Enable GeoLocation in SharePoint 2013

Keywords: GeoLocation, Bing Maps, Map view, SharePoint 2013

GeoLocation is a new functionality in SharePoint 2013 that makes it possible to add a users physical coordinates to a SharePoint list. Let’s assume that you have a contact list and want to show your customers location on a map. With GeoLocation you can achieve this easily.

GeoLocation need to be enabled in SharePoint and is not there OOTB. To enable it you need first to browse to and obtain a trial key for 90 days! For commercial use you must obtain a key and pay the fee!


Sign in using your LiveID and obtain a valid Key. The key will be something like this:


Using SharePoint Management shell run the following line of PowerShell script:

Set-SPBingMapsKey –BingKey PutYourBingKeyHere

When done, you need to create a Site Column that can be used in a list. To do that, copy these lines into a file and call it CreateGeoLocation.ps1

$fieldXml = "<Field Type = 'Geolocation' DisplayName='Geo Location' Name='geolocation' Group='custom fields'/>"
#get spweb object
$web = Get-SPWeb "PutYourSite"

Run CreateGeoLocation.ps1 and make sure that the script run correctly without any error messages!

This will create a site Column under custom fields. See below:


Using GeoLocation

To use GeoLocation you need to add a contact list app!

When the app is added, from List setting choose to add a column from existing site columns!


When done, add a new post to the contact list as below:


At the bottom of the page you will find two links, one is called specify your location and the other is Use my location! If you use the former one you need to browse to Bing map and find the latitude and longitude of your location:


Latitude for Stockholm, Sweden: 59.332329
Longitude for Stockholm, Sweden: 18.062929

Add those value to your GeoLocation field as below:


Then you are done! If you want to use latter alternative (Use my location) you need to enable “let apps use my location” beneath the “privacy” option! 


Create a Map View

To create a map view, create a new view of the list and choose map view. Choose only desired field and save the view. The view will be something like this:




/Henrik A. Halmstrand

Tuesday, July 17, 2012

Sugen på att utveckla applikationer för nya Office och SharePoint 2013?

Vänta inte länge, registrera dig här och börja utveckla!

Microsoft tar över Yammer för att förstärka Sociala funktioner i SharePoint

Läs mer om detta här:

Frågan är om de hinner inför Yammer i SharePoint 2013, kvarstår att se!

Microsoft har släppt en publik beta av SharePoint Foundation 2013

Igår annonserade Microsoft att de kommer att släppa en publik beta av sin nästa version av samarbetsplattformen SharePoint. Bara några timmar efter fanns betan tillsammans med utbildningsmaterialen ute. Klicka här för att ladda ner dessa:
SharePoint 2013 Foundation

Enjoy the new SharePoint!

Tuesday, February 07, 2012

Marketplace, OAuth 2.0 0ch Licenseringen, en titt inuti SharePoint 15 Technical Preview Interoperability API

Denna information är direkt hämtat från de observationer som jag gjort i “SharePoint 15 Technical Preview Interoperability API”, som publicerade av Microsoft och som kan laddas ner från denna länk:

Som Microsoft har skrivit, är denna information tillfälligt och kan förändras när som helst. Informationen är publik och strider inte mot något NDA. Ha en trevlig läsning!


Wow, kommer SharePoint 15 att kunna kopplas till en Marketplace? Hur skulle det kunna se ut? Kanske streama ner applikationer och kunna testa dem innan man bestämmer sig för att köpa?

Kommer utvecklarna att kunna publicera sina applikationer som i Android Market och Apples App Store? Kvarstår att se! Ordet marketplace nämns bara en gång i dokumentationen och det i klassen SPAPP, se nedan!

SPApp class
Represents an app loaded onto Microsoft SharePoint Server and ready to be installed


OAuth 2.0

Äntligen hoppas vi att detta blir verklighet. OAuth 2.0 beskrivs nedan och är ett sätt för att skapa en federation mellan SharePoint och andra tjänster såsom Facebooks- och Googles API. Användarna från till exempel Google eller Facebook kan komma åt en SharePoint site utan att behöva existera i företagets AD.

Klassen som används heter “SPOAuth2BearerCredentials class” och Microsoft beskriver den så här:

“Provides credentials for authentication with a service that supports OAuth 2.0 bearer token authentication”.

“The OAuth 2.0 authorization protocol enables a third-party
application to obtain limited access to an HTTP service, either on
behalf of a resource owner by orchestrating an approval interaction
between the resource owner and the HTTP service, or by allowing the
third-party application to obtain access on its own behalf. This
specification replaces and obsoletes the OAuth 1.0 protocol described
in RFC 5849.”



Licenseringen har alltid varit en svår fråga, kommer SharePoint 15 att lösa detta åt oss? Kvarstår att se! Denna klass avslöjar lite av det som Microsoft kanske har tänkt att implementera!

Checks if the currently logged in user has the proper license to access the specified entity.


Fortsättningen följer….
Nyckelord: Marketplace, SharePoint 15, SPApp, Oauth 2.0, SharePoint 15 Technical Preview Interoperability API