Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Doesn't it depend on how much RAM you have?</p> <p>In theory, a x64 process can allocate EB's (etabytes?) of RAM, I think - ie, a LOT. But if you do, your machine should start paging like crazy and generally die.</p> <p>It was different in 32 bit mode, as you couldn't allocate more than 1GB of RAM in ANY process in windows (yes, there are ways around it, but it's not pretty). In practice, this ment about 7-800meg per .NET process, as .NET reserved some space.</p> <p>Either way, in 32 bit, the most you can use is 3GB - the OS reserves 1GB of virtual space for itself.</p> <p>In 64 bit, it should be 2^64, which is a big number, but <a href="http://en.wikipedia.org/wiki/X86-64" rel="nofollow noreferrer">http://en.wikipedia.org/wiki/X86-64</a> says it's 256TB of virtual space, and 1TB of REAL RAM. Either way, it's a lot more than you are likely to have in your machine, so it's going to hit the page file.</p> <blockquote> <p>With a 64-bit OS and a 64-bit runtime, .NET 2.0-based applications can now utilize 500 times more memory for data such as server-based caches.</p> </blockquote> <p>This has some good info, too <a href="http://www.theserverside.net/tt/articles/showarticle.tss?id=NET2BMNov64Bit" rel="nofollow noreferrer">http://www.theserverside.net/tt/articles/showarticle.tss?id=NET2BMNov64Bit</a></p> <p>BTW, if you are on a x64 machine (ie, x64 machine + x64 OS), compiling for AnyCPU and x64 does the same thing - it runs in x64 mode. The only difference is if you use AnyCPU vrs x86:</p> <ul> <li>x64 OS/.NET, AnyCpu: x64 app</li> <li>x64 OS/.NET, x64: x64 app</li> <li><p>x64 OS/.NET, x32: x32 app (x64 .NET framework as BOTH x32 and x64 versions of the Fx installed)</p></li> <li><p>x32 OS/NET, AnyCPU: x32 app</p></li> <li>x32 OS/.NET, x64: CRASH AND BURN BABY! (actually, it just dies gracefully)</li> <li>x32 OS/.NET, x32: x32 app.</li> </ul>
    singulars
    1. This table or related slice is empty.
    1. POMaximum Memory a .NET process can allocate
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USNic Wise
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    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. VTDownMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COBut how can i get the real memory limit for a machine?
      singulars
      1. PO
      1. USRauhotz
    2. COI flag your answer as bad because you mixed everything. The 3 gigs memory is the maximum free physical memory where could live 1 or more process. Any process could access the full 4 gigs space (32 bits adressing), the memory that could not be in physical memory will be cached (if cache is setup properly). And 3 gigs is not totally true either. You have to set XP for, by default it is only 2 gigs of ram maximum for app and 2 gigs for the os (of physical memory).
      singulars
      1. PO
      1. USEric Ouellet
    3. COSorry, Eric, but you need to read up on it, and actually TRY it. The theoretical limit on a 32bit system may be 4GB, but windows limits you to 3GB (the other GB is used for the system, and you have to use /3GB in the boot params to even get that), and while each process has a 4GB space, windows or the .NET FX enforces a 1GB limit for processes which do not do special things (SQL and Exchange do).
      singulars
      1. PO
      1. USNic Wise
 

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