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