Problem with SQLOLEDB and iis 6 - threading?

From: Fredrik Gjärdman (remove)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 13:42:20 +0100

I run a website on a dual proc. W2003 box with a clean setup running iis
6.0. The site does a ton of data access using PROVIDER=SQLOLEDB against a
SQL 2000 server with all the latest stuff.

When I put load on it it starts to process requests and perfmon counters
look as expected but efter a minute it seems to hang - still processing the
number of simultaneous requests I load it with and it does nothing until the
requests time out. Then it starts over again.

I have no locking problems in the DB and nothing is happening anywhere - no
events nothing.

Then i change PROVIDER=SQLOLEDB to DRIVER={SQLServer} and the problem is
gone.

I have a top of the line setup that is not yet in production so it is a
clean test environment where I have full control of everything and nobody
else is doing anything. The only reason I can come up with is that this is a
contention problem of some kind and to since changing the driver does the
trick I guess threading issues with the driver.

I remeber in the old days that it was possible to change the threading model
of ADO but now I can't find any reference to it.

Any ideas?

Relevant Pages

  • Problem with SQLOLEDB and iis 6 - threading?
    ... W2003 box with a clean setup running iis ... When I put load on it it starts to process requests and perfmon counters ... trick I guess threading issues with the driver. ... I remeber in the old days that it was possible to change the threading model ...
    (microsoft.public.data.ado)
  • Problem with SQLOLEDB and iis 6 - threading?
    ... W2003 box with a clean setup running iis ... When I put load on it it starts to process requests and perfmon counters ... trick I guess threading issues with the driver. ... I remeber in the old days that it was possible to change the threading model ...
    (microsoft.public.inetserver.iis)