RE: ASPSTATE issues

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Steven Cheng[MSFT] (v-schang_at_online.microsoft.com)
Date: 02/12/04 

Date: Thu, 12 Feb 2004 12:29:33 GMT

Hi Kevin,

Thanks for posting in the community!
>From your description, you're doing stress testing on a certain ASP.NET web
application. The application used sqlserver connections to a certain
database(aspstate). However, you found that when running the test, the
connections remains abou 100 and then the web app's performance(pages
request per unit time) slow down to barely nothing.
If there is anything I misunderstood, please feel free to let me know.

As for this issue, I'd like to asked some further questions on it:
1. Are you using the SQLServer as the ASP.NET web application's Session
State management server? If so , would you provide me the detailed setting
for the <sessionState> in your web.config file, especially the connection
string?

2. Have you used the SQLProfiler to see what's the account the ASP.NET used
to connect sqlserver? Also, what's the web app's authentication setting?
Have you used impersonate?

In addition, here are some tech articles on server process monitor and
sqlserver session management:

#Watching Your Server Processes
http://msdn.microsoft.com/library/en-us/dnaspp/html/aspnet-watchserverproces
ses.asp?frame=true

#ASP.NET Performance Monitoring, and When to Alert Administrators
http://msdn.microsoft.com/library/en-us/dnaspp/html/monitor_perf.asp?frame=t
rue

#HOW TO: Configure ASP.NET for Persistent SQL Server Session State
Management
http://support.microsoft.com/default.aspx?scid=kb;en-us;311209

Please check out the preceding suggestions. If you have any new findings or
further infos , please feel free to post here.

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.)

Get Preview at ASP.NET whidbey
http://msdn.microsoft.com/asp.net/whidbey/default.aspx

Relevant Pages

  • Re: Resource Accumulation on SQLServer
    ... > We have a JDBC project that works with SQLServer, ... we noticed that resource useage on SQLServer ... That said, if the number of locks accumulate, then you might have a problem. ... may need to review how you close connections. ...
    (comp.lang.java.databases)
  • Re: DAO, Transactions, SQLServer
    ... dbSQLPassThrough in all my queries, I was getting rid of Jet, but not ... With this option I no longer get outstanding connections, ... > I have a problem with DAO, Transactions and SQLServer. ... > are opened (by the driver I believe) and I suspect that the driver sends ...
    (microsoft.public.sqlserver.connect)
  • Re: DAO, Transactions, SQLServer
    ... dbSQLPassThrough in all my queries, I was getting rid of Jet, but not ... With this option I no longer get outstanding connections, ... > I have a problem with DAO, Transactions and SQLServer. ... > are opened (by the driver I believe) and I suspect that the driver sends ...
    (microsoft.public.vb.database)
  • Re: adding data
    ... > I add my data from sqlserver to dropdownlist on formload.I wanted it ... > load data every time on form load.I made if session is null then load if ... > session isnt null dont load.I add to sqlserver a new data ans I make ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: adding data
    ... >> I add my data from sqlserver to dropdownlist on formload.I wanted it ... >> load data every time on form load.I made if session is null then load ... > I think the problem is, that you must re-bind the dropdownlist after ...
    (microsoft.public.dotnet.framework.aspnet)