Re: Web Farms and session handling

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" <smuda@xxxxxxxxxxxxx> wrote in message
news:uia8TOn9FHA.2364@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>
>


.

Relevant Pages

  • Re: Horizontal scaling - advice needed
    ... the session can be unambiguously proxied to the right backend server, ... To start with have a single database machine. ... Full database clustering is challenging, but if your site is making you lots ... For transient session state, ...
    (comp.lang.ruby)
  • Re: Active/Active configuration
    ... Almost everything out there is onActive/Passive.Setting up another instance in a cluster is no different than setting up the ... how does sql server knows which instance an application/user is refering to?You need a separate IP addresse for each clustered instance. ... you really shouldn't share a single network. ... Is this a valid assumption?You may get better performance by virute of running each database on its own ...
    (microsoft.public.sqlserver.clustering)
  • Re: What is the best backup solution for failover cluster SQL Server
    ... Backing up your SQL database in a clustered environment is not different from a normal server. ... Create a cluster disk share so in the event of a fail over, all nodes will have access to the backup share. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server Architecture
    ... Mirror WRITE database fails back to primary WRITE database (which is ... now running on the secondary in the cluster). ... the primary server before Windows Clustering does. ... in addition to the database mirroring setup you described. ...
    (microsoft.public.sqlserver.clustering)
  • LSASS.exe slowly increasing in memory and VM usage
    ... I currently have a 2 node cluster with Windows 2000 Advance Server ... Description: 18264: Database backed up: Database: BEDB, ...
    (microsoft.public.win2000.advanced_server)