Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

sql concurrent connections - cals - users

Posted on 2007-03-29
7
Medium Priority
?
523 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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 1500 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

670 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