Restrictions on SQL Server 2005 Express

I know that the restrictions on SQL 2005 Express are 1 GB RAM, 1 processor and 4GB database size but what does this mean in reality?

Does it mean that if you install it on a machine with 4GB RAM, and 2 processors, the SQL Engine only uses 1GB of the 4GB ever and only 1 of the processors?  

It would be nice, also, to see written Microsoft confirmation that it no longer uses the "governor" for SQL 2005 Express.

Thanks,

LVL 1
ddh76Asked:
Who is Participating?
 
riaancorneliusConnect With a Mentor Commented:
To use RAM efficiently and use more than 1 processor, you need to configure SQL Server to do so. Express won't let you.
0
 
riaancorneliusCommented:
>> Does it mean that if you install it on a machine with 4GB RAM, and 2 processors, the SQL Engine only uses 1GB of the 4GB ever and only 1 of the processors?  
Sounds about right.
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
I agree with riaancornelius: the sql server express will only use up to it's max resources.

regarding the governor:
http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.