Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I try to say them with other words.</p> <p>In a server you can have many asp.net sites that runs together. Each one site is an <strong>app domain</strong>.</p> <p>You must assign to each of them one <strong>application pool</strong>. Many application domains (sites) can have the same application pool, and because they have the same application pool they run under the same processes, and under the same account - and they have the same settings of the pool. If this pool restarts, then all sites under that pools restarts.</p> <p>Now each pool can have one or more <strong>worker process</strong>. Each worker process is a different program that's run your site, have their alone static variables, they different start stop calls etc. Different worker process are not communicate together, and the only way to exchange data is from common files or a common database. If you have more than one worker process and one of them make long time calculations, then the other can take care to handle the internet calls and show content.</p> <p>When you assign many worker process to a single pool then you make the called <strong>web garden</strong> and your site is like to be run from more than one computer if a computer is one processing machine.</p> <p><a href="https://i.stack.imgur.com/y0gTZ.gif" rel="noreferrer"><img src="https://i.stack.imgur.com/y0gTZ.gif" alt="app domains, with pools and processes"></a></p> <p>Each worker process can have many threads.</p> <p>How the more worker process affect you:<br> When you have <strong>one worker process</strong> everything is more simple, among your application all static variables are the same, and you use the <a href="http://msdn.microsoft.com/en-us/library/c5kehkcz.aspx" rel="noreferrer"><code>lock</code></a> to synchronize them.<br> When you assign <strong>more than one worker process</strong> then you still continue to use the <code>lock</code> for static variables, static variables are not different among the many runs of your site, and if you have some common resource (e.g. the creation of a thumbnail on the disk) then you need to synchronize your worker process with <a href="http://msdn.microsoft.com/en-us/library/system.threading.mutex.aspx" rel="noreferrer"><code>Mutex</code></a>.</p> <p>One more note. Its sounds that when you make <strong>more worker process</strong> then you may have more smooth asynchronous page loads. There is a small issue with the session handler of asp.net that is lock the entire process for a page load - that is good and not good depend if you know it and handle it - or change it.</p> <p>So let talk about one site only with many worker process. Here you face the issue that you need to synchronize your common resource change with <code>Mutex</code>. But the pages/handlers that use session they are not asynchronous because the session locks them. This is good for start because you avoid to make this synchronization of many points your self.</p> <p>Some questions on this topic:<br> <a href="https://stackoverflow.com/questions/9426673/web-app-blocked-while-processing-another-web-app-on-sharing-same-session">Web app blocked while processing another web app on sharing same session</a><br> <a href="https://stackoverflow.com/questions/9052401/jquery-ajax-calls-to-web-service-seem-to-be-synchronous">jQuery Ajax calls to web service seem to be synchronous</a><br> <a href="https://stackoverflow.com/questions/12284530/asp-net-server-does-not-process-pages-asynchronously">ASP.NET Server does not process pages asynchronously</a><br> <a href="https://stackoverflow.com/questions/8989648/replacing-asp-nets-session-entirely">Replacing ASP.Net&#39;s session entirely</a> </p> <p>Now this session lock is not affect different sites. </p> <p>Among different sites the more worked process can help to not the one site block the other with long running process.<br> Also among different sites the more pools also can help, because each pool have at least one worked process, but remember and see by your self using the process explorer, each working process takes more memory of your computer, and one big server with 16G memory and one SQL server can not have too many different worked process - for example on a server with 100 shared sites, you can not have 100 different pools.</p>
    singulars
    1. This table or related slice is empty.
    1. POIIS app pools, worker processes, app domains
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USAristos
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIIS app pools, worker processes, app domains
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI'm figuring out it's different from the way how IIS 5 handles it compared to IIS 6 and above. So in IIS 5 you have one Worker process and multiple app domains in it compared to IIS 6 you have multiple worker processes (w3wp.exe) one for each application pool.In IIS 6.0 inetinfo redirects to different worker process depending on the request . Am I right here ? Here is my source http://dotnetslackers.com/articles/iis/ASPNETInternalsIISAndTheProcessModel.aspx
      singulars
      1. PO
      1. USSRK
    2. CO@user460103 Yes iis5 is have one worker process (multiple app domains can have only with a small hack, but they not work together.) When you have on one site many worker process, then yes iis6 can redirect you to different worker process.
      singulars
      1. PO
      1. USAristos
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload