Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We have a client that uploads many large files to the site 10MB++

What I am wondering is are there any maintenance jobs that we could run on SP or SQL server to improve the performance?

Or any way to pinpoint that this is causing the performance problem?

share|improve this question
add comment

1 Answer 1

up vote 3 down vote accepted

You're not describing what performance problems you are seeing. Start with updating your question with that. There are no magical SQL maintenance jobs that will shrink your documents etc, you have to design your SharePoint farm in the correct way to handle large amounts of data.

  • Use Site Collections to be able to spread the data over multiple content databases
  • Check you versioning history settings
  • Check how much data there is in your content databases, don't go over 100GB per content database is the normal recommendation
  • Avoid adding all files into a single document library
  • Check you SQL I/O performance (disk read/write etc)

etc etc - there are a gazillion ways to tune and design for performance. To further be able to help you please describe how your environment looks like.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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