Solved

sql concurrent connections - cals - users

Posted on 2007-03-29
7
508 Views
Last Modified: 2011-09-20
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?
0
Comment
Question by:fm250
  • 4
  • 3
7 Comments
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 18818163
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
 
LVL 10

Author Comment

by:fm250
ID: 18818315
what is the per process licesnse? and is the cost better?
0
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 18818567
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 10

Author Comment

by:fm250
ID: 18821858
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
 
LVL 21

Accepted Solution

by:
Kevin3NF earned 500 total points
ID: 18822716
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
 
LVL 10

Author Comment

by:fm250
ID: 18824413
Any other comments about any other low cost solutions for small/medium busness as sql server. I was reading about workgroup edition! thanks!
0
 
LVL 10

Author Comment

by:fm250
ID: 18840032
If I upgrade to sql express from msde? Are there any problems?  will it keep everything as is:  databases, scheduled jobs, users...etc.  
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

947 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now