Sitecore Performance Optimization

1         IIS:-

1. Ensure that Maximum Worker Processes for the Application Pool is set to 1 (under advanced settings)
2. Ensure that Load User Profile settings of the Application Pool is set to "true" (under advanced settings)
3. Ensure anonymous access is denied for folders /App_Config, /sitecore/admin, /sitecore/debug, /sitecore/shell/webservice.
4. Enable HTTP keep alive
5. Enable static content compression
6. On the CMS server, enable dynamic content compression
7. Disable execute permissions on the upload folder
8. Enable content expiration using HTTP response headers, especially for the /sitecore folder (optional). Sitecore recommends that the Expire Web content be enabled, Set to "After" 30 days.

 

2         Sitecore Configurations:-

1. Check if the History, PublishQueue, and EventQueue Cleanup Tasks are configured. Schedulingfrequency = 00:05:00 (5 minutes),                               Sitecore.Tasks.CleanupHistory interval = 04:00:00 (4 hours) Sitecore.Tasks.CleanupPublishQueue interval = 04:00:00 (4 hours)  Sitecore.Tasks.CleanupEventQueue interval = 04:00:00 (4 hours)
2. Include the path to static media files (header images, CSS files, JavaScript files) in the IgnoreURLPrefixes settings in sitecore config to prevent Sitecore from intercepting the requests.
3. Disable counters. Counters.Enabled setting should be false in sitecore config.
4. Enabled should be false in sitecore config.
5. Restrict access to .XML, .XSLT and .MRT files using the <system.webServer><handlers> section.
6. Disable the UploadWatcher.
7. Disable client RSS feeds by removing the Sitecore.Shell.Feeds.FeedRequestHandler.
8. EnableBucketDebug should be false in sitecore.config.

3         Database:-

1. Make sure that the Compatibility level is set for the version of SQL Server that you have installed. Values can be 110,100,90
2. Auto Close Property Set To False
3. Auto Shrink Property Set To False
4. Recovery Model Set to Simple
5. Defragment indexes
6. Clean up History, EventQueue and PublishQueue tables.

4         Sitecore Content Tree:-

1. Check Long Running Validation Rules. Set log level to info and then use Sitecore log analyzer to see the long running
2. Number of versions for the item should be less than 10.
3. Number of items under a folder should be less than 100.