Solved

sql concurrent connections - cals - users

Posted on 2007-03-29
7
512 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the 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 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Generate Scripts Fails 5 34
query execution hang 5 28
Get the latest status 8 30
SQL Syntax: How to force case sensitive query? 2 23
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
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…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

786 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