Re: Problem with SQLOLEDB and iis 6 - threading?

From: Hernán Castelo (hhh_at_hotmail.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 12:40:08 -0300

hi
what are you doing after connection?
get recordSets? call stored prs?
what are the "requests" and "counters" you mentioned?
( do you have latest MDAC ? )

changing provider that way
you will get connections via odbc, not oledb
i think sql oledb is better for a web environment 

-- 
atte,
Hernán Castelo
UTN Buenos Aires
.  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .
"Fredrik Gjärdman @inwarehouse.se>" <fredrik.gjardman<remove> escribió en el mensaje news:u1mQg3YEEHA.3788@TK2MSFTNGP10.phx.gbl...
> 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

  • Re: Connecting Out of Process Servers via COM+
    ... connection, and in fact we can only use one connection because of the way ... years ago when I needed a number of clients to share a single serial ... it would create a Dispatcher-Object first and registers ... > This means, altough COM+ would allow parallel requests, the calls would be ...
    (microsoft.public.vb.com)
  • Re: output.c error in multithreaded program
    ... >>I find an access violation windows message and start the JIT debugger to ... > thread will block until the Sleep() expires, ... >>it a good enough approach to handle repeated requests. ... connection. ...
    (microsoft.public.vc.mfc)
  • Slow DNS requests?
    ... I think that the delay is in resolving the DNS requests. ... Guest machines connected via CAT5 to the BEFSR41 run fine. ... As soon as the host name is resolved, performance seems to improve dramatically for that connection. ... It offers one set of entries for "Name Servers" and a different set for "Domain Search". ...
    (comp.os.linux.networking)
  • Re: http pipelining
    ... Oops, sorry, you meant sending requests in parallel, right? ... down a single TCP connection, without waiting for the first response. ... Certainly urllib and urllib2 don't support pipelining. ...
    (comp.lang.python)
  • Re: Slow DNS requests?
    ... I think that the delay is in resolving the DNS requests. ... Guest machines connected via CAT5 to the BEFSR41 run fine. ... As soon as the host name is resolved, performance seems to improve dramatically for that connection. ... your DHCP server will tell your machine what name servers to use. ...
    (comp.os.linux.networking)