Connection pooling isn't happening?

[Russ]

Hi there,

I've got a website that I'm trying to test using the MS Web
Application Stress tool, but performance seems to be really poor
(about 6 requests/second). I've done some testing, and it seems that
as soon as I drop any database requirement into the application,
performance instantly drops tenfold, regardless of what I'm actually
doing.

So I'm guessing the issue is around the database connection - I'm
connecting from my local development PC to my ISP's SQL server. I'd
expect some kind of connection pooling to be going on to slightly
alleviate this problem, but when I look in the Performance Monitor, I
can only see 2 connections currently pooled in the ".NET Data Provider
for SqlServer" object.

Anyone got any ideas? Obviously a tenfold performance drop is
concerning me!

Many thanks all,

Russ

 

[William \(Bill\) Vaughn]

Assuming you're using ADO.NET and the SqlClient provider, connection pooling
is enabled by default. What do these data access routines do? Perhaps they
could be written more efficiently.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)