Server Fault is a question and answer site for system and network administrators. 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


We run Sharepoint 2007 1 Admin server, 1 Search Server, 2 Web servers and 1 database server.

I have noticed that at any one time there is always at least 80 connections to the sharepoint databases even when knowone is activly on site sites.

Is this normal? What are the connections doing at activity monitor is showing the connections as sleeping?


share|improve this question
up vote 1 down vote accepted

SharePoint operates with a load of timer jobs running in the background to perform site administration tasks. Take a look through the activity list in the admin site and you'll see all the things that are happening. I'd imagine these would account for a good number of the connections that you see listed.

share|improve this answer
Is there a reason why the search service holds onto 5 or 6 connections at any one time. – Andy Sep 28 '10 at 10:09
Depends how you have it set up - the service has a number of parts anyway doing different tasks. E.g. you can set it up to more than 1 crawl agent... Entirely depends on your config but the search service has a whole is a pretty complex architecture so it's broken down it to a range of separate discrete processes that will will run independently. – Chris W Sep 28 '10 at 10:53

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.