sql concurrent connections - cals - users

I have an application that uses msde sql server where it has  problem with cuncurrent connections, so I want get a sql full version, let say sql std 2005. does it have restriction on the connections or creating users in the databases? what is th CAL for?
LVL 10
fm250Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kevin HillSr. SQL Server DBACommented:
Get a CAL for each user hitting the database, or...if there are too many (or cannot be determiend in the case of a web application), get per processor licensing.

The restrictions in MSDE is number of concurrent queries running...after 8, they get throttled down.

In Full SQL, this limitation is gone
0
fm250Author Commented:
what is the per process licesnse? and is the cost better?
0
Kevin HillSr. SQL Server DBACommented:
Per Processor...SQL Server standard list price is $5999 per physical processor installed in a socket on the motherboard (not per core for dual core processors).

If your SQL Server is the backend to a website that anonymous users can hit, you have to buy per processor.  If you can identify how many users, you can use CAL licensing (if the number is small enough to make it cheaper than $5999...)
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

fm250Author Commented:
Is the lisnse for cuncurrent connections -users/devices- or for any user or device that access the sql. in other words let say I have 50 users, but only max of 20 can connect at the same time, so in this case 20 cals only needed. Correct?

Also how is sql going to check is it going to restrict the 21st user or is it just the legal document licesnse? thanks? is there any other low cost solutions for small/medium busness as sql server?
0
Kevin HillSr. SQL Server DBACommented:
SQL Doesn't check.

You need to call MS licensing to get the "fine print" definitions you are drilling down to here.  I *think* that if you have 50 users who can and do access the SQL data, even if the max concurrency is 20, you still need a CAL for each.

I cannot specifically address user vs. device accurately
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fm250Author Commented:
Any other comments about any other low cost solutions for small/medium busness as sql server. I was reading about workgroup edition! thanks!
0
fm250Author Commented:
If I upgrade to sql express from msde? Are there any problems?  will it keep everything as is:  databases, scheduled jobs, users...etc.  
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.