Solved

Restrictions on SQL Server 2005 Express

Posted on 2006-07-10
5
935 Views
Last Modified: 2009-07-29
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,

0
Comment
Question by:ddh76
  • 2
5 Comments
 
LVL 9

Expert Comment

by:riaancornelius
ID: 17071769
>> 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
 
LVL 9

Accepted Solution

by:
riaancornelius earned 63 total points
ID: 17071778
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
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 62 total points
ID: 17071918
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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

823 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question