Many database connections

S

Shannon

We have recently added a server running Project Server 2007 using SharePoint
Services 3.0 on Windows Server 2003 R2.

When I check the activity on our SQLServer 2005 server, there are upwards of
70 database connections from the project server. There as many as 5
connections to a single project database.

This server does not see much activity at this point, so the number of
connections is at least a curiosity. Is a large number of connection to the
Database expected?

Thanks Shannon
 
S

Sean Hanson

Each thread from the queue service and each IIS /pwa worker thread can have
connections, so it may look like a large number.
--
Sean Hanson

http://www.randsmanagement.com
Mass Resource Tool for 2007
Project Server 2007 Archive Tool
SRS Reports
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Server Connection Pooling for MPS 0
No more connection on SQL Server 2005 1
connection issues - 5086 0
Forms Authentication Project Server 2007 1
Project Server 2003 Share Point Services Issue 0
Sharepoint Services 6
PWA: Sql Server Connection Problems :( 1
Odd Query Could Not Be Processed error 0

Top