SharePoint Performance Tuning
As your users continue to make use of SharePoint, you may notice slowdown in SharePoint performance. This slowdown is most likely the result of users storing many large files in your SharePoint server. Microsoft SQL server databases are not optimized to handle large amount of binary files. Fortunately, there are ways to keep SharePoint performance up even while the size of the files grows.
Offloading BLOG Files
The best way to increase SharePoint performance is to move the files into another storage location with higher performance. The use of external storage allows SharePoint’s SQL server to focus only on the task of keeping track (i.e. metadata) of files and not the files themselves. The files can be offloaded to flash storage that offers much higher performance than traditional hard drives.
Cost Savings by Data Access Priority
High performance storage can be expensive, so it may not be viable to place all your files on the fastest storage system or server possible. However, you don’t actually need to store everything on the fastest servers. Older or archived documents that are rarely accessed can be stored on slower, less expensive storage medium, reducing the load on your high performance servers. You can monitor server processing time to find out where the bottlenecks are located and try to move those processes to faster servers.
If you don’t want to spend too much time doing server optimization, you can use third-party tool such as Metalogix’s StoragePoint. This software helps you fluidly move files into tiered storage systems. The most actively files are stored in high performance storage, while the least used files can be archived in slower, less expensive storage.
With the help of these tools you should be able to keep SharePoint performance high! Cheers!