I have a web application that is heavily accessed. It uses sql server 2008 as the backend. The poolsize of the connection is set to the default size (min pool size=8;max pool size=16).

The webserver has enough ram (16gb) and fast processors.

The 8 processors of the sql server run at 25% when I check at perfmon.

How can I see if the pool size is set to a decent value?

link|improve this question
Are you expecting to see higher CPU utilization? – jl. Sep 30 '10 at 13:09
No I did not mention the cou utilization because I thinkg its toolarge or too small. I just wanted to state everything I know about the machine. – user28032 Sep 30 '10 at 20:21
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.