By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,882 Members | 2,465 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,882 IT Pros & Developers. It's quick & easy.

Web Farms and session handling

P: n/a
Hi!

We have a problem which is correlated to web farms and session handling and
are thinking of what solution to choose.

Our setup is with a web farm, one ldap server and a database cluster.

The web farm is doing searches which are quite performance expensive against
the ldap server, taking up to 10 or 15 seconds. The searches are displayed
to the client in a datagrid, which then may have to be paged.

There are different ways to handle paging:
- do the search again against the ldap, but in our opinion that is to slow
to be an option.

- save the search result in the viewstate, but that gives pages roundtrip
with sizes of megabytes.

- save the search result in the in-proc session, but that can't handle where
the session is moved to another server within the web farm.

- save the search result in the aspnet state server session, but the state
server isn't cluster-aware and is therefore a single point of failure, which
really isn't an option.

- save the search result in a sql session, but according to MS articles this
normally requires a new database server, in our case a database cluster. The
cost for another database cluster (hardware, software, maintanance and so
on) is high.
Anyone have any ideas that'll solve our problem? Anyone have any high load
experience with SQL server sessions?

Regards,

John
Dec 1 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
if you have a sqlserver cluster, you don't need a new one. the resources for
using sqlserver for state management is low, single row read and write per
page flip. your current server should hardly notice it.

aspstate is a pretty simple database as are the queries.
-- bruce (sqlwork.com)

"John Allberg" <sm***@nospam.nospam> wrote in message
news:ui**************@TK2MSFTNGP12.phx.gbl...
Hi!

We have a problem which is correlated to web farms and session handling
and are thinking of what solution to choose.

Our setup is with a web farm, one ldap server and a database cluster.

The web farm is doing searches which are quite performance expensive
against the ldap server, taking up to 10 or 15 seconds. The searches are
displayed to the client in a datagrid, which then may have to be paged.

There are different ways to handle paging:
- do the search again against the ldap, but in our opinion that is to slow
to be an option.

- save the search result in the viewstate, but that gives pages roundtrip
with sizes of megabytes.

- save the search result in the in-proc session, but that can't handle
where the session is moved to another server within the web farm.

- save the search result in the aspnet state server session, but the state
server isn't cluster-aware and is therefore a single point of failure,
which really isn't an option.

- save the search result in a sql session, but according to MS articles
this normally requires a new database server, in our case a database
cluster. The cost for another database cluster (hardware, software,
maintanance and so on) is high.
Anyone have any ideas that'll solve our problem? Anyone have any high load
experience with SQL server sessions?

Regards,

John

Dec 1 '05 #2

P: n/a
Thanks for Bruce's input.

Hi John,

I agree with Bruce on this. And so far in ASP.NET 1.X if stateserver of not
possible, SqlServer session maybe the only considerable approach for
webfarm or webgarden scenario...
BTW. in ASP.NET 2.0 we can replace the default build-in sessionState module
with our own custom module , that may help implement our own session
storage mechanism...

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

--------------------
| From: "Bruce Barker" <br******************@safeco.com>
| References: <ui**************@TK2MSFTNGP12.phx.gbl>
| Subject: Re: Web Farms and session handling
| Date: Thu, 1 Dec 2005 10:31:56 -0800
| Lines: 56
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Response
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <u1**************@TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: rdcsd1.safeco.com 12.144.134.2
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP10.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:362123
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| if you have a sqlserver cluster, you don't need a new one. the resources
for
| using sqlserver for state management is low, single row read and write
per
| page flip. your current server should hardly notice it.
|
| aspstate is a pretty simple database as are the queries.
|
|
| -- bruce (sqlwork.com)
|
|
|
|
|
| "John Allberg" <sm***@nospam.nospam> wrote in message
| news:ui**************@TK2MSFTNGP12.phx.gbl...
| > Hi!
| >
| > We have a problem which is correlated to web farms and session handling
| > and are thinking of what solution to choose.
| >
| > Our setup is with a web farm, one ldap server and a database cluster.
| >
| > The web farm is doing searches which are quite performance expensive
| > against the ldap server, taking up to 10 or 15 seconds. The searches
are
| > displayed to the client in a datagrid, which then may have to be paged.
| >
| > There are different ways to handle paging:
| > - do the search again against the ldap, but in our opinion that is to
slow
| > to be an option.
| >
| > - save the search result in the viewstate, but that gives pages
roundtrip
| > with sizes of megabytes.
| >
| > - save the search result in the in-proc session, but that can't handle
| > where the session is moved to another server within the web farm.
| >
| > - save the search result in the aspnet state server session, but the
state
| > server isn't cluster-aware and is therefore a single point of failure,
| > which really isn't an option.
| >
| > - save the search result in a sql session, but according to MS articles
| > this normally requires a new database server, in our case a database
| > cluster. The cost for another database cluster (hardware, software,
| > maintanance and so on) is high.
| >
| >
| > Anyone have any ideas that'll solve our problem? Anyone have any high
load
| > experience with SQL server sessions?
| >
| > Regards,
| >
| > John
| >
| >
|
|
|

Dec 2 '05 #3

P: n/a
Hi!

Thanks for the help. With this info, we'll go with SQLState.

Thanks,

John

"Steven Cheng[MSFT]" <st*****@online.microsoft.com> wrote in message
news:aP**************@TK2MSFTNGXA02.phx.gbl...
Thanks for Bruce's input.

Hi John,

I agree with Bruce on this. And so far in ASP.NET 1.X if stateserver of
not
possible, SqlServer session maybe the only considerable approach for
webfarm or webgarden scenario...
BTW. in ASP.NET 2.0 we can replace the default build-in sessionState
module
with our own custom module , that may help implement our own session
storage mechanism...

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

--------------------
| From: "Bruce Barker" <br******************@safeco.com>
| References: <ui**************@TK2MSFTNGP12.phx.gbl>
| Subject: Re: Web Farms and session handling
| Date: Thu, 1 Dec 2005 10:31:56 -0800
| Lines: 56
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Response
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <u1**************@TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: rdcsd1.safeco.com 12.144.134.2
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP10.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:362123
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| if you have a sqlserver cluster, you don't need a new one. the resources
for
| using sqlserver for state management is low, single row read and write
per
| page flip. your current server should hardly notice it.
|
| aspstate is a pretty simple database as are the queries.
|
|
| -- bruce (sqlwork.com)
|
|
|
|
|
| "John Allberg" <sm***@nospam.nospam> wrote in message
| news:ui**************@TK2MSFTNGP12.phx.gbl...
| > Hi!
| >
| > We have a problem which is correlated to web farms and session
handling
| > and are thinking of what solution to choose.
| >
| > Our setup is with a web farm, one ldap server and a database cluster.
| >
| > The web farm is doing searches which are quite performance expensive
| > against the ldap server, taking up to 10 or 15 seconds. The searches
are
| > displayed to the client in a datagrid, which then may have to be
paged.
| >
| > There are different ways to handle paging:
| > - do the search again against the ldap, but in our opinion that is to
slow
| > to be an option.
| >
| > - save the search result in the viewstate, but that gives pages
roundtrip
| > with sizes of megabytes.
| >
| > - save the search result in the in-proc session, but that can't handle
| > where the session is moved to another server within the web farm.
| >
| > - save the search result in the aspnet state server session, but the
state
| > server isn't cluster-aware and is therefore a single point of failure,
| > which really isn't an option.
| >
| > - save the search result in a sql session, but according to MS
articles
| > this normally requires a new database server, in our case a database
| > cluster. The cost for another database cluster (hardware, software,
| > maintanance and so on) is high.
| >
| >
| > Anyone have any ideas that'll solve our problem? Anyone have any high
load
| > experience with SQL server sessions?
| >
| > Regards,
| >
| > John
| >
| >
|
|
|

Dec 6 '05 #4

P: n/a
You're welcome John,

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.)
--------------------
| From: "John Allberg" <sm***@nospam.nospam>
| References: <ui**************@TK2MSFTNGP12.phx.gbl>
<u1**************@TK2MSFTNGP10.phx.gbl>
<aP**************@TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Web Farms and session handling
| Date: Tue, 6 Dec 2005 09:24:40 +0100
| Lines: 121
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <ee**************@TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: pc5161235.han.telia.se 131.115.161.235
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP10.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:362973
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Hi!
|
| Thanks for the help. With this info, we'll go with SQLState.
|
| Thanks,
|
| John
|
| "Steven Cheng[MSFT]" <st*****@online.microsoft.com> wrote in message
| news:aP**************@TK2MSFTNGXA02.phx.gbl...
| > Thanks for Bruce's input.
| >
| > Hi John,
| >
| > I agree with Bruce on this. And so far in ASP.NET 1.X if stateserver of
| > not
| > possible, SqlServer session maybe the only considerable approach for
| > webfarm or webgarden scenario...
| > BTW. in ASP.NET 2.0 we can replace the default build-in sessionState
| > module
| > with our own custom module , that may help implement our own session
| > storage mechanism...
| >
| > 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.)
| >
| > --------------------
| > | From: "Bruce Barker" <br******************@safeco.com>
| > | References: <ui**************@TK2MSFTNGP12.phx.gbl>
| > | Subject: Re: Web Farms and session handling
| > | Date: Thu, 1 Dec 2005 10:31:56 -0800
| > | Lines: 56
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| > | X-RFC2646: Format=Flowed; Response
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| > | Message-ID: <u1**************@TK2MSFTNGP10.phx.gbl>
| > | Newsgroups: microsoft.public.dotnet.framework.aspnet
| > | NNTP-Posting-Host: rdcsd1.safeco.com 12.144.134.2
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP10.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl
| > microsoft.public.dotnet.framework.aspnet:362123
| > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
| > |
| > | if you have a sqlserver cluster, you don't need a new one. the
resources
| > for
| > | using sqlserver for state management is low, single row read and write
| > per
| > | page flip. your current server should hardly notice it.
| > |
| > | aspstate is a pretty simple database as are the queries.
| > |
| > |
| > | -- bruce (sqlwork.com)
| > |
| > |
| > |
| > |
| > |
| > | "John Allberg" <sm***@nospam.nospam> wrote in message
| > | news:ui**************@TK2MSFTNGP12.phx.gbl...
| > | > Hi!
| > | >
| > | > We have a problem which is correlated to web farms and session
| > handling
| > | > and are thinking of what solution to choose.
| > | >
| > | > Our setup is with a web farm, one ldap server and a database
cluster.
| > | >
| > | > The web farm is doing searches which are quite performance expensive
| > | > against the ldap server, taking up to 10 or 15 seconds. The searches
| > are
| > | > displayed to the client in a datagrid, which then may have to be
| > paged.
| > | >
| > | > There are different ways to handle paging:
| > | > - do the search again against the ldap, but in our opinion that is
to
| > slow
| > | > to be an option.
| > | >
| > | > - save the search result in the viewstate, but that gives pages
| > roundtrip
| > | > with sizes of megabytes.
| > | >
| > | > - save the search result in the in-proc session, but that can't
handle
| > | > where the session is moved to another server within the web farm.
| > | >
| > | > - save the search result in the aspnet state server session, but the
| > state
| > | > server isn't cluster-aware and is therefore a single point of
failure,
| > | > which really isn't an option.
| > | >
| > | > - save the search result in a sql session, but according to MS
| > articles
| > | > this normally requires a new database server, in our case a database
| > | > cluster. The cost for another database cluster (hardware, software,
| > | > maintanance and so on) is high.
| > | >
| > | >
| > | > Anyone have any ideas that'll solve our problem? Anyone have any
high
| > load
| > | > experience with SQL server sessions?
| > | >
| > | > Regards,
| > | >
| > | > John
| > | >
| > | >
| > |
| > |
| > |
| >
|
|
|

Dec 6 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.