Connection pooling isn't happening?

  • Thread starter Thread starter Russ
  • Start date Start date
R

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
 
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)
 
Back
Top