Hi,
I have had a similar (Deadlock - SQL) issue for a while, but I think I've gotten rid of it now, not sure yet. Same story here windows 2003 server SP2 ....Net 3.5 etc. I used system.xml.xpath and xsl in a code class and neglected to null out after using it. I think xsl sorting in .Net causes some SQL handling in the internal processing. This is speculation, I didn't completely dive into it due to lack of time. I've now nulled out all created xml objects and I've not come across the issue anymore, so far. If you're using .Net xml sorting, make sure you clean up nicely. Perhaps this helps. Kind Regards, Wilson Wampers From: [email protected] [mailto:[email protected]] On Behalf Of Nigel Hertz Sent: Wednesday, 10 February 2010 07:06 To: ozMOSS Subject: RE: Deadlocks [SEC=UNOFFICIAL] Almost on a daily basis - every day since 28 Jan except for the 6th, 7th & 8th of Feb, and twice on the 4th. (I saved and cleared the logs on the 28th) It seems to happen any time between around 10:30pm and 3am (which affects our UK branches). However, CPU usage on the machine tends to spike up to around 99% usage a couple of times a day - generally around 13:30 here, which is when I generally recycle the app pool as soon as I notice it. This doesn't let it reach the "deadlock" stage, so it doesn't log it. From: [email protected] [mailto:[email protected]] On Behalf Of Chris Milne Sent: Wednesday, 10 February 2010 9:59 AM To: ozMOSS Subject: RE: Deadlocks [SEC=UNOFFICIAL] Is the event recurring in your logs? How often? From: [email protected] [mailto:[email protected]] On Behalf Of Nigel Hertz Sent: Wednesday, 10 February 2010 8:56 AM To: ozMOSS Subject: RE: Deadlocks [SEC=UNOFFICIAL] We've been recycling the app pool 3-4 times a day for the past week or so L From: [email protected] [mailto:[email protected]] On Behalf Of Noja, Fadi Sent: Wednesday, 10 February 2010 9:46 AM To: ozMOSS Subject: RE: Deadlocks [SEC=UNOFFICIAL] I had that before and I simply recycled the app pool and it stopped appearing. ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Nigel Hertz Sent: Wednesday, 10 February 2010 9:43 AM To: ozMOSS Subject: RE: Deadlocks There's nothing in the logs referring to SQL at all, it seems to purely be an IIS issue. It's a 2003 SP2 server, with .Net 3.0 installed. I'm checking windows update now to see what patches etc are available. From: [email protected] [mailto:[email protected]] On Behalf Of Paul Turner Sent: Wednesday, 10 February 2010 9:37 AM To: ozMOSS Subject: RE: Deadlocks What .net framework level do you have... is it 3.5 SP1? If no... consider running Windows Update. Is it a 2003 Server? Regards, Paul Turner Senior Solutions Specialist M: 0412 748 168 P: 08 8238 0912 F: 08 8234 5966 A: 66 Henley Beach Road, Mile End SA 5031 E: [email protected] <mailto:[email protected]> W: www.dws.com.au <https://webmail.dws.com.au/owa/UrlBlockedError.aspx> Error! Filename not specified. ADVANCED BUSINESS SOLUTIONS LTD This email and any files transmitted with it are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient you have received this email in error and are requested to delete it immediately. Any opinion expressed in this e-mail may not necessarily be that of DWS Pty Ltd. Please consider the environment before printing this email. ________________________________ From: [email protected] [[email protected]] On Behalf Of Daniel W. Brown [[email protected]] Sent: Wednesday, 10 February 2010 9:06 AM To: ozMOSS Subject: RE: Deadlocks I haven't seen that particular one, is there any event log entries which correspond to the approx. time which show SQL server deadlocks? From: [email protected] [mailto:[email protected]] On Behalf Of Nigel Hertz Sent: Wednesday, 10 February 2010 9:01 AM To: ozMOSS Subject: Deadlocks Hi all Has anyone ever seen this in their event logs? If so, any tips on resolving the issue? ISAPI 'C:\WINNT\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll' reported itself as unhealthy for the following reason: 'Deadlock detected'. Nigel ---------------------------------------------------------------- Nigel Hertz Software Developer | Information Technology Stockland Level 25 | 133 Castlereagh Street | Sydney NSW 2000 T: 02 9035 2617 | F: 02 8988 2617 ________________________________ Stockland Notice: If this communication has been sent to you by mistake, please delete and notify us. If it has been sent to you by mistake, legal privilege is not waived or lost and you are not entitled to use it in any way. Stockland and its subsidiaries reserve the right to monitor e-mail communication through its networks. ________________________________ Stockland Notice: If this communication has been sent to you by mistake, please delete and notify us. If it has been sent to you by mistake, legal privilege is not waived or lost and you are not entitled to use it in any way. Stockland and its subsidiaries reserve the right to monitor e-mail communication through its networks. ________________________________ Stockland Notice: If this communication has been sent to you by mistake, please delete and notify us. If it has been sent to you by mistake, legal privilege is not waived or lost and you are not entitled to use it in any way. Stockland and its subsidiaries reserve the right to monitor e-mail communication through its networks. ________________________________ Stockland Notice: If this communication has been sent to you by mistake, please delete and notify us. If it has been sent to you by mistake, legal privilege is not waived or lost and you are not entitled to use it in any way. Stockland and its subsidiaries reserve the right to monitor e-mail communication through its networks.
_______________________________________________ ozmoss mailing list [email protected] http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
