Thursday, June 19, 2014

SharePoint server is slow? might be LDF the cause..

Problem

You may come across the performance issue with SharePoint server. May be the problem of huge size LDF files in SQL server. Let see the solution for the same.

Solution 

We need to Shrink the LDF file in SQL server for better performance. Steps to Shrink,

  • Open SQL Server instance in your machine
  • Right click the database, Select Tasks -> Shrink -> Files in the menu

  • Will get the Shrink form to reduce the file size. Select the Reorganize pages before releasing unused space in Shrink Action part
  • Change Shrink file to 0
  • Then, Click OK 



  • Apply the above steps for the database which contains large amount of size

No comments:

Post a Comment