Explain in-proc,out-proc and sql server.
- 4 Answers
- 51702 Views
- G7 CR Technologies, Ness Technologies, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sajid
In case of InProc, state is maintained within the managed
memory of the ASP.NET process whereas in case of OutProc
mode session is managed by an external resource (
StateServer or SQL Server )
In case of InProc, state is maintained within the managed
memory of the ASP.NET process whereas in case of OutProc
mode session is managed by an external resource (
StateServer or SQL Server )
This EggheadCafe article -
http://www.eggheadcafe.com/articles/20021016.asp has a good
comparison
Storage location
* InProc - session kept as live objects in web server
(aspnet_wp.exe). Use "cookieless" configuration in
web.config to "munge" the sessionId onto the URL (solves
cookie/domain/path RFC problems too!)
* StateServer - session serialized and stored in memory
in a separate process (aspnet_state.exe). State Server can
run on another machine
* SQLServer - session serialized and stored in SQL server
Performance
* InProc - Fastest, but the more session data, the more
memory is consumed on the web server, and that can affect
performance.
* StateServer - When storing data of basic types (e.g.
string, integer, etc), in one test environment it's 15%
slower than InProc. However, the cost of
serialization/deserialization can affect performance if
you're storing lots
of objects. You have to do performance testing for
your own scenario.
* SQLServer - When storing data of basic types (e.g.
string, integer, etc), in one test environment it's 25%
slower than InProc. Same warning about serialization as in
StateServer.
Robustness
* InProc - Session state will be lost if the worker
process (aspnet_wp.exe) recycles, or if the appdomain
restarts. It's because session state is stored in the memory
space of an appdomain. For details, see KB324772.
* StateServer - Solve the session state loss problem in
InProc mode. Allows a webfarm to store session on a central
server. Single point of failure at the State Server.
* SQLServer - Similar to StateServer. Moreover, session
state data can survive a SQL server restart, and you can
also take advantage of SQL server failover cluster, after
you've followed instructions in KB 311029.
| Is This Answer Correct ? | 73 Yes | 2 No |
Answer / vimal
in-proc-----session kept as a live object in the web server
sql server---session serialized and stored in sql server(in
tempdb)
| Is This Answer Correct ? | 36 Yes | 15 No |
Answer / ranjana tyagi
Inproc- In this the information(session) is stored in
aspnet_wp.exe.Which is lost when the application is closed.
Outproc-outproc statemanagement are state server and sql
server.
sql server- the session is stored in sql server.
state server-The session is stored in aspnet_state.exe.
| Is This Answer Correct ? | 20 Yes | 7 No |
Answer / manoj bhatt
in proc-by default the session mode is in proc,the session
object is maintained in the current application domain or we
can say in the web server memory
advantage-fast,easy to use
disadvantage-not support web garden,server restart session lose
out proc-here we maintain the session in any external source
like sql server or aspnet_state.exe
advantage-session data is not lose,when server
reboot,support web garden
dis-hard to implement,require serial,deserialization
| Is This Answer Correct ? | 5 Yes | 2 No |
Describe the Managed Execution Process in .NET?
0 Answers InfoAxon Technologies,
What is .net mobile input validation. Explain with an example? : Microsoft dot net mobile
What is the difference between primary & secondary storage device? : Dot net architecture
Explain the types of memory management? : Dot net architecture
Explain in-proc,out-proc and sql server.
4 Answers G7 CR Technologies, Ness Technologies,
What is the difference between an event and a delegate?
Explain the difference between primary & secondary storage device? : Dot net architecture
Explain about the base class library provided by microsoft.net?
what is a namespace?how they are classified?write a program which contains class,object,inheritance?
Explain about clr?
How can implement drag and drop using atlas?
how to find the 2nd higgest salary in the column for example take table name is employee? And also find bottom 2nd lowest salary ?
11 Answers GeoTechnology, Wipro,
Dot Net Framework 
