3

how to minimize database latency issues for increase sharepoint web front end and applications servers performance I have a large scale of sharepoint farm and in peak time there is issue of Sql server slowness

Improve this question
1
  • 2
    You must first identify the actual bottleneck before addressing it. "Latency" is a generic term which could mean network, disk, CPU, memory.
    – user6024
    Oct 29, 2017 at 19:46

1 Answer 1

Reset to default
1

Some things to check consider:

  • Add RAM to SQL Server box
  • Decrease the distance between the SQL Server and the SharePoint servers
  • Isolate the SQL Server from other applications--just have SharePoint databases on one server, no other instances or non-SharePoint application databases
  • Point the web servers back to themselves (127.0.0.1) in the HOSTS file.
  • Decrease the services on the web front end servers that should be application server specific.
  • Add more servers to the farm and scale out.
  • Follow the recommended requirements
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.