Thanks for your followup Budhi,
I think SqlServer version should not matter here. Make sure the database
server and sqlserver has installed the latest patch... Also, is the
database being called frequently in your application?
Steven Cheng
Microsoft Online Support
Get Secure!
www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--------------------
| Date: Wed, 23 Nov 2005 10:25:06 +1100
| From: Budhi Saputra Prasetya <
[email protected]>
| Reply-To: (e-mail address removed)
| Organization: Immersive Pty Ltd
| User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
| X-Accept-Language: en-us, en
| MIME-Version: 1.0
| Subject: Re: Performance issue of ASP .NET
| References: <
[email protected]>
<
[email protected]> <
[email protected]>
<
[email protected]>
<
[email protected]>
<
[email protected]>
<#
[email protected]>
<#p75Z#
[email protected]>
<
[email protected]>
<
[email protected]>
<
[email protected]>
| In-Reply-To: <
[email protected]>
| Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| Content-Transfer-Encoding: 7bit
| Message-ID: <#
[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: ppp157-241.static.internode.on.net 150.101.157.241
| Lines: 1
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:360284
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Steven Cheng[MSFT] wrote:
| > Thanks for your response Budhi,
| >
| > I'm also not very sure about the perf counter behavior you mentioned.
Also,
| > the appication object locking is just a potential cause. It'll be
better if
| > we could isolate the problem to some certain page.
| >
| > Regards,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure!
www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
| >
| > --------------------
| > | Date: Thu, 17 Nov 2005 11:58:20 +1100
| > | From: Budhi Saputra Prasetya <
[email protected]>
| > | Reply-To: (e-mail address removed)
| > | Organization: Immersive Pty Ltd
| > | User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
| > | X-Accept-Language: en-us, en
| > | MIME-Version: 1.0
| > | Subject: Re: Performance issue of ASP .NET
| > | References: <
[email protected]>
| > <
[email protected]>
<
[email protected]>
| > <
[email protected]>
| > <
[email protected]>
| > <
[email protected]>
| > <#
[email protected]>
| > <#p75Z#
[email protected]>
| > <
[email protected]>
| > | In-Reply-To: <
[email protected]>
| > | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| > | Content-Transfer-Encoding: 7bit
| > | Message-ID: <
[email protected]>
| > | Newsgroups: microsoft.public.dotnet.framework.aspnet
| > | NNTP-Posting-Host: ppp157-241.static.internode.on.net 150.101.157.241
| > | Lines: 1
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl
| > microsoft.public.dotnet.framework.aspnet:358793
| > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
| > |
| > | Steven Cheng[MSFT] wrote:
| > | > Thanks for your response Budhi,
| > | >
| > | > So from your two response, I got that there're some deadlock info
| > detected
| > | > from teh Eventlog and you also mentioned that you found there has 4
| > current
| > | > request and executing requests stuck on the server, so possibly
they're
| > the
| > | > ones which has run into deadlock, do you think so? If so, we may
have
| > to
| > | > do some code analysis on our application. Is there any pages in
your
| > | > application which could be the potential of the cause, e.g, using
some
| > | > resources or shared objects ?
| > | >
| > | > Steven Cheng
| > | > Microsoft Online Support
| > | >
| > | > Get Secure!
www.microsoft.com/security
| > | > (This posting is provided "AS IS", with no warranties, and confers
no
| > | > rights.)
| > | >
| > | >
| > | >
| > | > --------------------
| > | > | Date: Wed, 16 Nov 2005 16:35:48 +1100
| > | > | From: Budhi Saputra Prasetya <
[email protected]>
| > | > | Reply-To: (e-mail address removed)
| > | > | Organization: Immersive Pty Ltd
| > | > | User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
| > | > | X-Accept-Language: en-us, en
| > | > | MIME-Version: 1.0
| > | > | Subject: Re: Performance issue of ASP .NET
| > | > | References: <
[email protected]>
| > | > <
[email protected]>
| > <
[email protected]>
| > | > <
[email protected]>
| > | > <
[email protected]>
| > | > <
[email protected]>
| > | > <#
[email protected]>
| > | > | In-Reply-To: <#
[email protected]>
| > | > | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| > | > | Content-Transfer-Encoding: 7bit
| > | > | Message-ID: <#p75Z#
[email protected]>
| > | > | Newsgroups: microsoft.public.dotnet.framework.aspnet
| > | > | NNTP-Posting-Host: ppp157-241.static.internode.on.net
150.101.157.241
| > | > | Lines: 1
| > | > | Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| > | > | Xref: TK2MSFTNGXA02.phx.gbl
| > | > microsoft.public.dotnet.framework.aspnet:358476
| > | > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
| > | > |
| > | > | Budhi Saputra Prasetya wrote:
| > | > | > Hi Steven,
| > | > | >
| > | > | > According to the system administrator, there is no recycling
log
| > | > entries
| > | > | > during the event where the application stop responding. The
| > recycling
| > | > | > time is set to 29 hours (default setup) if that matters.
However
| > there
| > | > | > are few deadlock error entries on the error log. The system
admin
| > also
| > | > | > said that he found few people got the same problem on the net
but
| > no
| > | > one
| > | > | > answer the question. The cause is mostly because they are
trying to
| > | > move
| > | > | > the application from Windows Server 2000 to Windows Server
2003.
| > There
| > | > | > description of the error message is:
| > | > | >
| > | > | > ISAPI
| > 'C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll'
| > | > | > reported itself as unhealthy for the following reason:
'Deadlock
| > | > detected'.
| > | > | >
| > | > | > Budhi
| > | > |
| > | > | Hi Steven,
| > | > |
| > | > | There is one thing that I found by accident. When i try to
compile
| > the
| > | > | result on the server performance counter, I found that the
Request
| > | > | Executing and Request Current counter is stuck at 4, while there
is
| > no
| > | > | more request is actually submitted to the server. Could you help
me
| > with
| > | > | the issue of why this could happen?
| > | > |
| > | > | Budhi
| > | > |
| > | >
| > |
| > | Hi Steven,
| > |
| > | There is only 1 shared objects (Application Object), however the
locking
| > | only happen when I want to check whether a new generated id is a
| > | duplicate id, because the id is shared among all tables. As soon as
the
| > | id is generated I do unlock.
| > |
| > | Basically the pseudocode looks like:
| > |
| > | 1. Generate id
| > | 2. Lock the Application Object
| > | 3. Does it exist in the list, if not put a new id into the list
| > | 4. Unlock the Application Object
| > | 5. If duplicate go back to step 1 else continue with next step
| > |
| > | As you see it's very short period amount of time taken for lock and
| > | unlock. But do you know why the counter can be stuck if that's the
only
| > | resources I lock, cos I don't see how that lock and unlock in this
case
| > | can cause a problem since I'm doing it only on 1 resource. I did the
| > | stress testing few times already and there wasn't any problem before.
| > | When the stress testing finished, the counter always go back to 0.
| > |
| > | Budhi
| > |
| >
|
| Hi Steven,
|
| Sorry just came back from 2 days break from work.
About the problem,
| I started to think that it might be because of the database locking
| procedure. Could it be possible since I don't do any specific setup on
| database level. By the way, we are using MS SQL Server 2000 if that
matter.
|
| Budhi
|
