Posted by Greg D. Moore \(Strider\) on 04/15/06 17:06
"FreeToGolfAndSki" <wlr@genoagroup.com> wrote in message
news:1145109633.754240.192500@e56g2000cwe.googlegroups.com...
> I'm thinking of migrating our 12 user SQL 2000 db to SQL 2005 Express.
> The db is about 2 gb. Does anyone know if there is a no of users or db
> size or other restrictions on SQL 2005 Express. How about performance
> relative to SQL 2000? Thanks in advance....
>
SQL 2005 Express is limited to 1GB of RAM, a single CPU and a 4GB database.
That's about it. It does NOT have the query governor that the MSDE had.
In general if it's a small database, you should be fine and may even see an
increase in performance.
[Back to original message]
|