473,322 Members | 1,287 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Out of Process State - MSSQL

I've taken a look at this article
http://msdn.microsoft.com/library/de...sp12282000.asp
which someone posted a month or so ago regarding setting up SQL server to
handle state data.

The article references .Net beta, and the file state.sql in the
framwork/1.0x directory, but that file doesn't exist for version 1.1.4322.
I'm wondering if there's a component that I need to install, or if I need to
simply use the state.sql file in the older version directory. Any help, or
points in the right direction, with this is greatly appreciated.

Also, I'm wondering what your impressions of using MS SQL as a state server
is. I've seen alot of articles concerning the concepts of state management,
but I'd love to hear from someone who's actually been using the sql server
state functionality of .net framework. Essentially, I'm interested in
taking my failover cluster web servers to a load-balance cluster, and I'm
thinking that the sql server state management would be better than relying
on cookies.

Thanks!
- Chad Crowder
Nov 18 '05 #1
4 2285
Chad,

For the 1.1 Framework, the file you need is InstallSqlState.sql for Session
state in the Temp database and InstallPersistSqlState.sql for Session state
in the ASPState database. Both of these files are in the v1.1.4322
directory.

SqlServer Session state is going to have considerable overhead from InProc
Session state. While you gain the benefit of maintaining Session state is
the process is restarted, you are going to experience at least a 25%
performance drop from in process Session state. That number can increase
dramatically if you are storing complex objects.

See http://www.asp.net/Forums/ShowPost.a...=1&PostID=7504.

Jim Cheshire, MCSE, MCSD [MSFT]
ASP.NET
Developer Support
ja******@online.microsoft.com

This post is provided "AS-IS" with no warranties and confers no rights.

--------------------
From: "Chad Crowder" <chad@spam_me_not.chad>
Subject: Out of Process State - MSSQL
Date: Fri, 2 Apr 2004 13:48:53 -0500
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <Od**************@TK2MSFTNGP09.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: 12.108.244.117
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:223231
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

I've taken a look at this article
http://msdn.microsoft.com/library/de...-us/dnaspnet/h tml/asp12282000.aspwhich someone posted a month or so ago regarding setting up SQL server to
handle state data.

The article references .Net beta, and the file state.sql in the
framwork/1.0x directory, but that file doesn't exist for version 1.1.4322.
I'm wondering if there's a component that I need to install, or if I need tosimply use the state.sql file in the older version directory. Any help, or
points in the right direction, with this is greatly appreciated.

Also, I'm wondering what your impressions of using MS SQL as a state server
is. I've seen alot of articles concerning the concepts of state management,but I'd love to hear from someone who's actually been using the sql server
state functionality of .net framework. Essentially, I'm interested in
taking my failover cluster web servers to a load-balance cluster, and I'm
thinking that the sql server state management would be better than relying
on cookies.

Thanks!
- Chad Crowder


Nov 18 '05 #2
Chad,

For the 1.1 Framework, the file you need is InstallSqlState.sql for Session
state in the Temp database and InstallPersistSqlState.sql for Session state
in the ASPState database. Both of these files are in the v1.1.4322
directory.

SqlServer Session state is going to have considerable overhead from InProc
Session state. While you gain the benefit of maintaining Session state is
the process is restarted, you are going to experience at least a 25%
performance drop from in process Session state. That number can increase
dramatically if you are storing complex objects.

See http://www.asp.net/Forums/ShowPost.a...=1&PostID=7504.

Jim Cheshire, MCSE, MCSD [MSFT]
ASP.NET
Developer Support
ja******@online.microsoft.com

This post is provided "AS-IS" with no warranties and confers no rights.

--------------------
From: "Chad Crowder" <chad@spam_me_not.chad>
Subject: Out of Process State - MSSQL
Date: Fri, 2 Apr 2004 13:48:53 -0500
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <Od**************@TK2MSFTNGP09.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: 12.108.244.117
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:223231
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

I've taken a look at this article
http://msdn.microsoft.com/library/de...-us/dnaspnet/h tml/asp12282000.aspwhich someone posted a month or so ago regarding setting up SQL server to
handle state data.

The article references .Net beta, and the file state.sql in the
framwork/1.0x directory, but that file doesn't exist for version 1.1.4322.
I'm wondering if there's a component that I need to install, or if I need tosimply use the state.sql file in the older version directory. Any help, or
points in the right direction, with this is greatly appreciated.

Also, I'm wondering what your impressions of using MS SQL as a state server
is. I've seen alot of articles concerning the concepts of state management,but I'd love to hear from someone who's actually been using the sql server
state functionality of .net framework. Essentially, I'm interested in
taking my failover cluster web servers to a load-balance cluster, and I'm
thinking that the sql server state management would be better than relying
on cookies.

Thanks!
- Chad Crowder


Nov 18 '05 #3
Jim,

Thanks for the info and insight. I'd read about the 25% as well, but I was
thinking that I can offset much of this performance decrease by the fact
that I'll be able to distribute the load across multiple web servers in the
server farm.

I'm also interested in whether this 25% reduction in performance is
predicated on the assumption that my coding isn't already database-bound.
For example, I'm already making at least one DB connection per page anyway.

The State Server concept doesn't appeal a great deal to me. It seems that
going that route would create a single fail point (ie, if the state server
goes down, I'm screwed), whereas with SQL Server state, I already have a
redundant SQL Server system. I'm not sure if it's even possible to make a
State Server redundant (ie, run it in some sort of cluster).

Again, thanks for the info and insight.

- Chad
"Jim Cheshire [MSFT]" <ja******@online.microsoft.com> wrote in message
news:9r**************@cpmsftngxa06.phx.gbl...
Chad,

For the 1.1 Framework, the file you need is InstallSqlState.sql for Session state in the Temp database and InstallPersistSqlState.sql for Session state in the ASPState database. Both of these files are in the v1.1.4322
directory.

SqlServer Session state is going to have considerable overhead from InProc
Session state. While you gain the benefit of maintaining Session state is
the process is restarted, you are going to experience at least a 25%
performance drop from in process Session state. That number can increase
dramatically if you are storing complex objects.

See http://www.asp.net/Forums/ShowPost.a...=1&PostID=7504.

Jim Cheshire, MCSE, MCSD [MSFT]
ASP.NET
Developer Support
ja******@online.microsoft.com

This post is provided "AS-IS" with no warranties and confers no rights.

--------------------
From: "Chad Crowder" <chad@spam_me_not.chad>
Subject: Out of Process State - MSSQL
Date: Fri, 2 Apr 2004 13:48:53 -0500
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <Od**************@TK2MSFTNGP09.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: 12.108.244.117
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:223231X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

I've taken a look at this article


http://msdn.microsoft.com/library/de...-us/dnaspnet/h
tml/asp12282000.asp
which someone posted a month or so ago regarding setting up SQL server to
handle state data.

The article references .Net beta, and the file state.sql in the
framwork/1.0x directory, but that file doesn't exist for version 1.1.4322.I'm wondering if there's a component that I need to install, or if I need

to
simply use the state.sql file in the older version directory. Any help, orpoints in the right direction, with this is greatly appreciated.

Also, I'm wondering what your impressions of using MS SQL as a state serveris. I've seen alot of articles concerning the concepts of state

management,
but I'd love to hear from someone who's actually been using the sql serverstate functionality of .net framework. Essentially, I'm interested in
taking my failover cluster web servers to a load-balance cluster, and I'm
thinking that the sql server state management would be better than relyingon cookies.

Thanks!
- Chad Crowder

Nov 18 '05 #4
Chad,

The fact that you have another connection already open isn't going to
change anything. The connection string will be different. The reason you
suffer from the performance hit with SqlServer Session state is that you
are dealing with an architecture that is much slower than accessing memory
via InProc Session state.

Because State Server is a Windows service, there is no clustering. You can
share Session state between members of a cluster, but you cannot cluster
State Server.

Jim Cheshire, MCSE, MCSD [MSFT]
ASP.NET
Developer Support
ja******@online.microsoft.com

This post is provided "AS-IS" with no warranties and confers no rights.

--------------------
From: "Chad Crowder" <chad@spam_me_not.chad>
References: <Od**************@TK2MSFTNGP09.phx.gbl> <9r**************@cpmsftngxa06.phx.gbl>Subject: Re: Out of Process State - MSSQL
Date: Tue, 6 Apr 2004 08:59:25 -0400
Lines: 103
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <eW**************@tk2msftngp13.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: 12.108.244.117
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGP08.phx.gbl!tk2msftngp13
.phx.gblXref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:223901
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

Jim,

Thanks for the info and insight. I'd read about the 25% as well, but I was
thinking that I can offset much of this performance decrease by the fact
that I'll be able to distribute the load across multiple web servers in the
server farm.

I'm also interested in whether this 25% reduction in performance is
predicated on the assumption that my coding isn't already database-bound.
For example, I'm already making at least one DB connection per page anyway.

The State Server concept doesn't appeal a great deal to me. It seems that
going that route would create a single fail point (ie, if the state server
goes down, I'm screwed), whereas with SQL Server state, I already have a
redundant SQL Server system. I'm not sure if it's even possible to make a
State Server redundant (ie, run it in some sort of cluster).

Again, thanks for the info and insight.

- Chad
"Jim Cheshire [MSFT]" <ja******@online.microsoft.com> wrote in message
news:9r**************@cpmsftngxa06.phx.gbl...
Chad,

For the 1.1 Framework, the file you need is InstallSqlState.sql for

Session
state in the Temp database and InstallPersistSqlState.sql for Session

state
in the ASPState database. Both of these files are in the v1.1.4322
directory.

SqlServer Session state is going to have considerable overhead from InProc
Session state. While you gain the benefit of maintaining Session state is the process is restarted, you are going to experience at least a 25%
performance drop from in process Session state. That number can increase
dramatically if you are storing complex objects.

See http://www.asp.net/Forums/ShowPost.a...=1&PostID=7504.

Jim Cheshire, MCSE, MCSD [MSFT]
ASP.NET
Developer Support
ja******@online.microsoft.com

This post is provided "AS-IS" with no warranties and confers no rights.

--------------------
>From: "Chad Crowder" <chad@spam_me_not.chad>
>Subject: Out of Process State - MSSQL
>Date: Fri, 2 Apr 2004 13:48:53 -0500
>Lines: 23
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Message-ID: <Od**************@TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.dotnet.framework.aspnet
>NNTP-Posting-Host: 12.108.244.117
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl
>Xref: cpmsftngxa06.phx.gblmicrosoft.public.dotnet.framework.aspnet:223231 >X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
>
>I've taken a look at this article


http://msdn.microsoft.com/library/de...n-us/dnaspnet/ h tml/asp12282000.asp
>which someone posted a month or so ago regarding setting up SQL server to >handle state data.
>
>The article references .Net beta, and the file state.sql in the
>framwork/1.0x directory, but that file doesn't exist for version1.1.4322. >I'm wondering if there's a component that I need to install, or if I need to
>simply use the state.sql file in the older version directory. Any help,or >points in the right direction, with this is greatly appreciated.
>
>Also, I'm wondering what your impressions of using MS SQL as a stateserver >is. I've seen alot of articles concerning the concepts of state

management,
>but I'd love to hear from someone who's actually been using the sqlserver >state functionality of .net framework. Essentially, I'm interested in
>taking my failover cluster web servers to a load-balance cluster, and
I'm >thinking that the sql server state management would be better than

relying >on cookies.
>
>Thanks!
>- Chad Crowder
>
>
>



Nov 18 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: mj | last post by:
Hello, thanks for the help. I am running a WinXP Pro w/ SP2 (my home computer, with ZoneAlarm firewall) Apache 2.0.52 MySQL 4.1.7 PHP 5.1.0-dev I have developed a PHP/MySQL web app that...
2
by: Jin | last post by:
Hello: I run one process that calls the following the store procedure and works fine. create PROCEDURE sp_GetHostSequenceNum AS BEGIN SELECT int_parameter_dbf + 1
3
by: Trevor Andrew | last post by:
Hi There, I have a small ASP.NET application under development. I am using VS.NET 2002 (2003 upgrade is on the way) with .NET Framework 1.1. It is hosted on a web hosting service in the US. I am...
3
by: Chad Crowder | last post by:
I've taken a look at this article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspnet/html/asp12282000.asp which someone posted a month or so ago regarding setting up SQL...
4
by: dhnriverside | last post by:
Hi peeps I'm having some problems with my Session State sticking (it keeps resetting itself) - I haven't looked into it yet, but I was wondering about using SQL Server as an out of process state...
0
by: Filipe Marcelino | last post by:
Hi, I whant to know if a user is using a process. To achieve that I have to know the state of the process, so I wrote the following code: Dim localAll As Process() =...
8
by: mandydhaliwal | last post by:
Hi all, I am porting a win32 c++ program on Linux which first reads a list of processes and their paths from a file.Then this program should launch all of thesese processes. I tried to...
4
by: Richard Rossel | last post by:
Hi Fellows, I have a problem with process termination. I have a python code that apache runs through a django interface. The code is very simple, first, it creates a process with the...
5
by: knyghtfyre | last post by:
Hello, My company is developing a rather large application with .NET 2.0. We are expanding to a server farm and are in the process of converting our application to use an out-of-process session...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.