Solved

sql concurrent connections - cals - users

Posted on 2007-03-29
7
505 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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

708 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

14 Experts available now in Live!

Get 1:1 Help Now