Pages

Wednesday, September 21, 2011

SP2010 Performance Optimization

There are lots of things you can do to make SharePoint go faster.

This blog aggregates some useful information I’ve leveraged. Will continue adding as I learn more. Figured it would be good to have the info aggregated in one place.

  • Infrastructure
    • Move TempDB & Database log files to separate drives
    • Consider content db strategy for different types of SharePoint sites (intranet vs. collaboration vs. public)
    • Content db size limits are there to ensure backups can run quickly
    • Don’t use default db growth settings: http://www.benjaminathawes.com/blog/Lists/Posts/Post.aspx?ID=5
  • Registry Setting
    • The windows server will routinely call to Microsoft to check licensing. If you are on a VM that has blocked network this will cause slowdown in performance. To fix it, copy the following into a .vbs file on your server and run it with a cscript command from the command prompt:
const HKEY_USERS = &H80000003
strComputer = "."
Set objReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" _
   & strComputer & "\root\default:StdRegProv")
strKeyPath = ""
objReg.EnumKey HKEY_USERS, strKeyPath, arrSubKeys
strKeyPath = "\Software\Microsoft\Windows\CurrentVersion\WinTrust\Trust Providers\Software Publishing"
For Each subkey In arrSubKeys
    objReg.SetDWORDValue HKEY_USERS, subkey & strKeyPath, "State", 146944
Next