SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When can we expect a maximum number of SQL connections for the Central Administration Configuration & Content DB? and what are all the important tables in these databases that an administrator should know ?

share|improve this question
up vote 1 down vote accepted

You can expect a lot of connections to the SQL Servers when you have a lot of requests and when you are using code that is not properly managing and disposing the SharePoint objects.

Since you should not fiddle with the databases at all you should not recommend any tables to your DBAs - then they would start "fixing" indexes and stuff and potentially harm the SharePoint databases. Leave them as is and instead focus on the databases;

  • which DBs are used for collaboration sites: optimize for read/write
  • which DBs are used for anonymous publishing sites: optmizie mostly for read
  • which DBs are used for records management sites: optimize for read
  • ...
share|improve this answer

Your Answer


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.