sql server new users: SQL2005 and user/device licsensing -- sql server new users

Re: SQL2005 and user/device licsensing

Barry Andrew Hall
3/30/2007 12:00:00 AM

sql server new users:

Hi,

That allows upto 10 "connections" at once yes.

Please bear in mind that you application can open a connection, get data,
then close the connection often in miliseconds.

I think you are probably looking for connection pooling. see
http://msdn2.microsoft.com/en-us/library/8xx3tyca.aspx

Basically you have your 10 CAL's in a pot. Now what happens is user1 wants
data, they take a connection from the pot, use it and it gets put back.
bearing in mind if you have good design the query should take miliseconds or
seconds, you will find that even if a user needs data and all 10 connections
are currently being used, they may have to wait a few seconds for a
connection for them to become available. Its a massive topic but very
interesting and well worth learning. Check out that link ;-)

Barry Andrew

[quoted text, click to view]

Re: SQL2005 and user/device licsensing

Barry Andrew Hall
3/30/2007 12:00:00 AM

Hi again Jason,

I personally would only buy the 10, but thats just me, unfortunately I find
the licensing side of all my servers and applications a little difficult to
determine, there is no one size fits all = )

You might find this link useful;
http://www.microsoft.com/sql/howtobuy/default.mspx

Good luck!
Barry

[quoted text, click to view]

SQL2005 and user/device licsensing

Jason Blake
3/30/2007 4:06:01 AM

If I purchase sql 2005 server standard edition with 10 user/device cals does
this allow up to 10 users or devices to be able to access the SQL server at
once ? IF an 11th user/device tries to connect do they get refused. ?

If i have 20 devices/users that may want to use the SQL Server but only a
max of 10 will use it at a time controlled by a software application do I
have to purchase 20 Cals or 10...

thanks for any response...

Re: SQL2005 and user/device licsensing

Jason Blake
3/30/2007 4:52:02 AM

thanks for the reply barry..... forgetting the connection side, from a
licensing point of view... if i have 100 PCs at a site that may want to
connect to SQL server but only ever a maximum of 10pcs at once will connect
at one time to SQL do i Have to purchase 100 device cals or 10 device cals.

thanks.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.