Clever Geek Handbook

CPU and Memory Usage in Multiple Instances of MS-SQL Express 2005/2008

In SQL Express (version 2005 or 2008) there is a limit of 1 GB of memory and 1 processor that can be used. I am wondering if there are two instances installed on the same computer, will they use the same processor and 1GB of memory? Or will they be using potentially two different processors and 2GB of memory?

+1


source to share


3 answers


Limitations for each instance. Each instance is limited to its own 1 CPU and 1 GB of RAM.

A system can have up to 16 instances of SQL Server Express Edition.



Also, MSDE, the predecessor to SQL Server Express, had per-instance restrictions.

+3


source


I can't say for sure, but most likely they will be able to use separate processors and memory. It would be quite difficult for them to coordinate memory sharing. My suspicion is that each instance will work the same regardless of the other instances present (at least in the respect you are talking about).



0


source


Suppose your system has 4 processors and presumably 4 GB of memory, and 2 instances of sql express, then each express will use one processor and 1 GB of memory. Hope it helps.

0


source






More articles:


All Articles