Wednesday, June 11, 2014

7 Tips to Improve SharePoint Server Performance

Hi friends, today I am going to share one of my favorite topics in SharePoint that is performance improvement. Microsoft SharePoint offers good performance even during backup & restore operation is running but I will share some tips that will make your SharePoint server better than before. Backup & Restore operation of SharePoint use SharePoint server resources and slowdown the server performance while operations are running. Follow below tips to minimize the server resource usages and improve the server performance.

Tip 1: Perform Backup on Local Disk

To improve the SharePoint performance, it is very important to make a backup of SharePoint database on a local disk on the server instead on server network drive. After making the backup on local drive, you can easily copy the database backup on network drive. If you don't have local disk on the server then it is recommended to use a network drive with same latency as of server.

Tip 2: Maintain Small Databases

Small databases help in faster backup & restore. If you have a big database or planning for it then it is recommended to split it into small databases that will help you in faster recovery. For practice, use multiple small databases for a website application instead of having a big database.

Tip 3: Use Database Backup Compression Technique during Backup

Firstly, it was introduced with SQL server 2008. Compressed database backup increases the backup speed and significantly requires less to restore because it is smaller than uncompressed database backup. It helps in faster backup & restore of SharePoint database.

Tip 4: Prefer Incremental Backup for Large Database

Incremental backup back ups data since last backup only. Last backup can be either full backup or differential backup. There is a small difference between differential & incremental backup, differential backup back ups data since last full backup while incremental backup back ups data since last backup. Incremental backup is fast and small in comparison of differential backup because it back ups data since last backup. It helps in improving the database performance as well as minimizes the changes of data loss.

Tip 5: Choose Backup Type Wisely

SharePoint uses SQL server to store database and SQL server backup uses transaction log, differential & full to minimize the recovery time of database. If you are using simple recovery model of your database then there is no need to truncate the transaction log files because SQL server does not maintain transaction log if database is simple recovery model. But if you are using full recovery model for your database, then I will recommend you to truncate the transaction log file periodically to avoid the database maintenance problems.

Tip 6: Avoid Conflicting Issue

To avoid conflicting issue in the database, it is recommended to don't run backup operation during peak hour. Typically SharePoint server runs 27*7, so it is best practice to run incremental backup to safeguard data against server failure.

Tip 7: If Possible Try to Use RAID 10

RAID stands for redundant array of independent disks. It combines multiple disk drives component into a single unit for performance improvement. If you are using RAID on the SharePoint server then I will recommend you to use RAID 10 because it reads & writes data faster in comparison of other RAID levels.  

No comments:

Post a Comment