Mark C. Stock said,on 3/10/2005 6:19 PM:
> "Oxnard" <shankeypNO_SPAM_at_comcast.net> wrote in message
> news:K8OdnQI6Cuogo63fRVn-vg_at_comcast.com...
>
>>"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message
>>news:42303a04$0$22850$5a62ac22_at_per-qv1-newsreader-01.iinet.net.au...
>>
>>>Jeremy apparently said,on my timestamp of 10/03/2005 10:20 PM:
>>>
>>>>So.... what do you think?
>>>
>>>Weird locking combination?
>>>
>>>--
>>>Cheers
>>>Nuno Souto
>>>in sunny Sydney, Australia
>>>wizofoz2k_at_yahoo.com.au.nospam
>>
>>How could one prove if this is the case? I have a simular situation. Once
>>every couple of months for no appeant situation the proformance gets very
>>bad on a application. I have sometimes thought it may be something to do
>>with the statistics getting weird, however I do not know how to prove
>>this.
>>
>
>
> what does the listener log look like at these peek times?
>
> could this be an app server related issue?
>
> ++ mcs
>
>
No its not an appserver issue because, the sql session
is inited as soon as the request arrives and the sql session
only takes the max time to complete.
--
Shanmu.
Received on Thu Mar 10 2005 - 07:55:59 CST
