May 7, 2010 at 5:34 am
It's be running under Win 2003 server OS
May 7, 2010 at 6:22 am
paul.knibbs (5/7/2010)
Gianluca Sartori (5/3/2010)
I was confused too, Grant. I was sure MSDE 2000 had a 5 concurrent connections limit, but, after searching a bit, I found out that Express Editions (starting from SQL 2005) have no connections limit.
Presumably if you were running them on a non-server OS (XP, say) they'd be subject to the global 10 connection limit, though?
No, I don't think so. I'm not an expert in this field, but I think this applies to windows connections only, that is to say all kind of connection that relies on the "server" service.
The best way to be sure is checking. I've been able to open 20 concurrent sql server sessions to the SQL2008 Express running on my laptop, but I'm sure I could have opened quite a lot more than that.
Anyway I found this strange sentence in MS support siite:
The connection limit refers to the number of redirector-based connections and is enforced for any file, print, named pipe, or mail slot session. The TCP connection limit is not enforced, but it may be bound by legal agreement to not permit more than 10 clients.
Makes things look like it works, but it's not allowed by license terms.
On the same topic, it would also be interesting to know how CAL come into play, but, again, I'm not expert in licensing issues.
-- Gianluca Sartori
May 7, 2010 at 8:33 am
Another question has occurred to me.
Do we break any MS licence agreements by running Express on a multi CPU server?
Paul
May 7, 2010 at 8:36 am
No. SQL Express will only make use of one CPU no matter how many are installed in the machine, so it's not like you're gaining anything by running it on the multi-CPU platform; therefore there's no licensing problem there.
May 7, 2010 at 9:09 am
You might want to consider going with Workgroup of Standard Edition.
The limitation of a 4GB database is fairly easy to hit. The lack of a SQL Server Agent in the Express Edition is a huge disadvantage, because it means you can't schedule backups and other maintenance jobs, you can't schedule Reporting Services reports, and you can't schedule Integrations Services jobs. Most entry-level servers have at least 2 CPUs and 2 - 4GB of memory, so the limit of 1 CPU and 1 GB of memory will really handicap the system.
You can get the Workgroup edition with 20 CALs for $2885 at list price (street price would be less) and Standard Edition with 20 CALs for $3190 at list price.
I would recommend 2008 Standard Edition, preferably on an x64 platform.
SQL Server 2008 Compare Edition Features
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
SQL Server 2008 Licensing Frequently Asked Questions
http://www.microsoft.com/sqlserver/2008/en/us/licensing-faq.aspx
SQL Server 2008 R2 Pricing
Viewing 5 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply