Sql SErver Licensing


Author
Message
Ger Cannoll
Ger Cannoll
Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)
Group: StrataFrame Users
Posts: 430, Visits: 507
I have a potential customer who has a server , and will be running a distributed application on each of the reps laptops.
There are about 15 reps, who will be running the application , disconnected, and then uploading data to the server
Sql express is not an option as Database sze is over 4 Gigs.

Does anybody know the licensing situaution in this case.... e.g. Do I need to purchase 15 server licenses at about $1800 each for each of the Reps laptops ?

I had a look at the MS pricing site but it gave no example of this situation

Reply
Larry Caylor
Larry Caylor
StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)
Group: Awaiting Activation
Posts: 592, Visits: 3.7K
Microsoft licensing can get complicated but there are basically two ways SQL Server may be licensed. One is by processor. When licensed by processor there is no limit on the number of users that may access the server. Unlike Oracle which licenses by core, SQL is licensed by processor socket so a quad core cpu still counts as a single processor. However processing licensing can get expensive, around $24,000 per processor for SQL Enterprise.

The other license model is to purchase a server license for each server and a client access license (CAL) for each user that will access the server. Under server licensing you can have as many processors as the edition of SQL Server you are using supports.

The licensing gets more complicated when you mix in virtual servers or a server that supports and Internet application.

Which model is best for you depends on how many servers and users you need to support. In my shop we run SQL Enterprise on five different servers with 600 users. All of our servers are multi-core and multi-processor. One of the reasons we use multiple servers is that in addtion to running business application we also do data warehousing. For us it turned out that that lowest cost licensing model was to purchase a license for each server and a CAL for each user. If we could consolidate everything on to a sinble box, processor licensing might be a better choice.   

We also use Strataframe ES. Under the terms of MS licensing, the ES server acts as a concentrator, presenting multiple ES users as a single user to SQL. Although there is only a single SQL user, a SQL CAL is required for each user that accesses the SQL box via the ES server. You can't get away with a single CAL. If the SQL box was licensed by processor, you could have an unlimited number of ES users.

In Gerard's case it sounds like he needs an acutal server on each laptop which requires either a processor license or server license with a CAL. If I were in this situation I'd first try to use SQL Express by splitting my database into multiple databases to get around the 4GB per database limit. If that wasn't possible I'd look at SQL Workgroup edition with one server license and one SQL CAL for each laptop.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Ger Cannoll - 15 Years Ago
Charles R Hankey - 15 Years Ago
Ger Cannoll - 15 Years Ago
Charles R Hankey - 15 Years Ago
Ger Cannoll - 15 Years Ago
Edhy Rijo - 15 Years Ago
Charles R Hankey - 15 Years Ago
Edhy Rijo - 15 Years Ago
Ger Cannoll - 15 Years Ago
Keith Chisarik - 15 Years Ago
                         [quote][b]Keith Chisarik (04/16/2010)[/b][hr]I use SF with MySQL, I...
Edhy Rijo - 15 Years Ago
Larry Caylor - 15 Years Ago
Dustin Taylor - 15 Years Ago
Russell Scott Brown - 15 Years Ago
Russell Scott Brown - 15 Years Ago
Russell Scott Brown - 15 Years Ago
Edhy Rijo - 15 Years Ago
Russell Scott Brown - 15 Years Ago
Russell Scott Brown - 15 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search