Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

HI

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?

Thanks

share|improve this question

1 Answer 1

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

 
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.