Re: Slow performance after restarting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tim (Tim_at_NoSpam)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 18:33:09 +1300

Eric,

** I am just trying to stir up thought that helps solve the problem **

How many licenses have you got?
Why are you using 9 connections?
 - 9 connections implies to me 9 concurrent server process or independant
threads. If you are not using Async queries you need only 1 connection per
DB per thread. When you are doing a startup, you need only minimal threads.
If you are using FH cursors and use secondary connections for them then a)
this is not startup and b) there are other and possbily better ways,
although without seeing the total design it is assumptive of me to
criticise.

Why are you issuing DML at startup? 9 connections / threads of DML is a LOT.

I am not familiar with connection pooling issues - it either works in my
experience or not, but I would not personally be issuing DML on a connection
pooling interface.. IE DML is for Design time not runtime (OK dropping a
table is faster than delete all records if you are not sa, but have dml
access). Its a bit of an abuse and may provoke things to ahhhh crap out.

For connection pooling, the connection is supposed to be in the same state
(in terms of SET options, USE and so on), so if you use a lot of connections
with an interloping QA session & DML, who knows how much of a mess ODBC gets
into. (personally, ODBC never seems to get in a mess).

- Tim

"Vlad Vissoultchev" <wqweto@nospam.myrealbox.com> wrote in message
news:#5ZPWwo9DHA.1128@tk2msftngp13.phx.gbl...
> i can confirm QA is "stuttering" if an orphaned connection remains past
> restart -- here the delay is 1-2 secs.
>
> this happens *only* in case of connecting to a local server.
>
> sql2k sp3 (not sp3a) on win2k3 server
>
> HTH,
> </wqw>
>
>

Relevant Pages

  • Re: Curious HTTP connections
    ... | I started having slow startup problems with my computer, ... I am running windows XP Home fully updated, plus Norton Internet Security ... The HTTP connections at startup have come from various IP addresses, ...
    (alt.computer.security)
  • Re: Windows XP Home Edition
    ... Internet Options> Connections. ... If you have AOL or other ISP software installed, ... If the modem still tries to autodial, go into Network Connections. ... Once you have the autodial at startup under control, ...
    (microsoft.public.windowsxp.basics)
  • Curious HTTP connections
    ... the startup after the Windows screen and before the desktop is fully loaded ... noticed that on some occasions there was internet activity. ... I decided to run open the command window and run the netstat -a command to ... see what connections were active. ...
    (alt.computer.security)
  • Re: Curious HTTP connections
    ... | the startup after the Windows screen and before the desktop is fully loaded ... | noticed that on some occasions there was internet activity. ... | I decided to run open the command window and run the netstat -a command to ... | see what connections were active. ...
    (alt.computer.security)
  • ADO Interop - SQL Server 2000 connections not released
    ... - DB is SQL Server 2000 ... When the ASP page is executed...no matter how many calls to the COM+ ... objects, connections, recordsets, etc. are properly set to nothing upon exit. ... We have tried OLE DB Services=-4 to disable connection pooling and the ...
    (microsoft.public.data.ado)