Wednesday, March 28, 2012

Professional edition vs. SQL Server

Hi
i am using the professional edition (since i'm running it on a windows 2000 pro machine), but i wanted to know what performance gains there are between the pro. edition vs. the real sql server that would be run on a windows 2000 advanced server machine
currently i'm trying to write/query an enormous amount of data. the bottleneck is now the database, but before i go through the trouble of rebuilding a maching with 2000 server, i wanted to know what the "gains" were and if it would even be worth the time to do this
Thanks
mikeOOPS... i meant PERSONAL and not professional edition.|||Personal Edition has the same performance delimiter as MSDE, i.e. 25
concurrent users is really pushing it. It has no limit on the database size
though, but you need a full SQL Server license to actually be allowed to use
Personal Edition on a separate machine. You can't use personal Edition
separately. I.e. what you are doing probably violates the licensing
agreement.
--
Jacco Schalkwijk
SQL Server MVP
"mike" <anonymous@.discussions.microsoft.com> wrote in message
news:23137F31-435A-4FF0-9AAB-9ACC5190E48B@.microsoft.com...
> OOPS... i meant PERSONAL and not professional edition.

No comments:

Post a Comment