Geek Answers Handbook

ASP.NET Session Performance

I'm having performance issues in my asp.net application. Sometimes it takes 30-40 seconds for the client to complete the command, as sometimes it takes 3-4 seconds. I tried SQL Profiler and I don't see any problems. I could not reproduce the problem on my side, in the same scenario, when the client tried.

I think this may be due to the session variables that I use. I use a lot of them to convey information on the page. However, I do not clean them.

If I clean them, will it help? and if it affects other users. Or is it allowed only for this user?

Any help is appreciated.

+5
source share
6 answers

In one of the stored procedures for implementing the .NET 2.0 session store based on SQL Server, there was a write lock problem. It looks like MS has included a fix in the release of .NET 4.0.

Take a look here: http://sanjevsharma.blogspot.com/2008/03/improving-aspnet-session-state-database.html

I'm 99% sure that you can run the 4.0 version of aspnet_regsql -ssadd and still run ASP.NET 2.0. I remember that I was making the difference between 2.0 and 4.0 SQL script, and the above fix was the only real difference. MS 'implementation of the fix was a little better than (and obviously based on) the links above.

+1
source

Session and therefore session variables are user-specific, so clearing them does not affect other users.

, , .

0

, ASP.NET SQL Server . , , (.. SqlConnection)

(30-40 ), , , SQLTalk roundtrip sporradic.

, . , /, .

  • SQL. / / , .
  • SQL.
 --- Executing statement SELECT * FROM Customers
 --- Start 08:55.44
 --- End   08:55.45 
 === Roundtrip was 1 second  SELECT * FROM Customers

// , "Roundtrip", , , .

0

, - , . , (4-40 ), , , .

.NET?

EQATEC.

0

, - . , , SQL, . perfmon, , - , , - .

0

ASP.NET ? ASP.NET. trace.axd,

<trace enabled="true" />

Enabling this configuration parameter will allow you to view trace.axd in the root directory of your site and view in detail the last 10 transactions. You can include a large set of results, rolling result sets, and many other great trace options through this trace element.

0
source

More articles:


All Articles