During my sessions about SharePoint, when I click on links and they open up instantly, inevitably there are one or two participants who walk up to me and ask “How many servers do you use to make SharePoint so speedy?” And my answer is: “My entire SharePoint environment is run through a single virtual machine on my personal laptop.” When a question is repeatedly raised, it means there is a need for clarity. So, being one of the foremost SharePoint solution authorities in Seattle, I am sharing some insights here into how you can improve the performance of your own SharePoint deliveries.
- It’s all about Performance of SQL Server: I have provided SharePoint solutions to clients, not only from Seattle, but also Redmond, Bellevue, Bothell and other parts of the US. Most of the clients relate performance of SharePoint to settings and configurations. That is partially true, but what really drives the speed of SharePoint is the SQL Server installation and configuration. Every piece of information is stored within SQL server’s databases. So, it stands to reason that optimizing the performance of your SQL Server database if crucial. If your information can be written, stored and accessed at a faster speed, then the performance of SharePoint will also be quick.
- Disks and NTFS Allocation: Optimizing disks for SQL server is one of the most overlooked configuration steps. To optimize the speed of SQL server, you need to make sure you have the right disks in place. To attain top speeds with SQL Server, you need to alter NTFS Allocation of your drives by formatting your disks. SQL reads and writes at 64k, but the default settings of your disks only allow 4k! By changing the default NTFS Allocation, you can see up to 30% improvement in SQL server speed.
- Modification to the Model Databases: SharePoint stores your web applications, by using the SQL information in model database. Now, by default these databases would accommodate a small space to store the information, which is not sufficient in most scenarios. So, you need to customize and allocate more space to store data. This will improve the performance of SQL server. Depending on the scale of work, if you feel that the space (presently allocated) could run out in future, you can customize the SharePoint database to increase by chunks, so that there is no dip in the performance.
- Optimizing Logs and Maintenance: If there is no proper log file to tell the Database where the small file is placed, then all the above optimization will be of no use. It is important to have the right model in place. There are two main strategies used in this respect. In the first model, information will require less space and maintenance, while the second one is the exact opposite. Whichever model you choose make sure that it is well maintained and the logs are truncated efficiently.
By implementing these simple, yet effective tips into your SharePoint process you can enjoy faster speed and efficiency in work.
Summary: Whether you are a SharePoint solution provider in Seattle, Redmond, Bellevue or Bothell, anyone can benefit from these simple steps to overcome SharePoint performance and speed issues.