Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am learning from http://msdn.microsoft.com/en-us/library/ms143432.aspx, my question is what is the differences between "Connections per client" and "user connection"?

share|improve this question

migrated from stackoverflow.com Oct 5 '09 at 1:27

This question came from our site for professional and enthusiast programmers.

    
I feel I am short of and interested in some basic internals of SQL Server. It is not a problem, but I am always confused when people say terms like "user connection" and "connection per client", so I want to find out why. Thanks! –  George2 Oct 3 '09 at 17:08
    
For ServerFault, I think it deals more with server configuration and maintenance, but this question is more related to developers. Let me know if you feel any issues. –  George2 Oct 3 '09 at 17:09
add comment

1 Answer

User connections here is the maximum number of connections that can be made to the server. Connections per client, which I don't believe is configurable, is how many connections an individual client can make.

Here's where there's a difference: a server is configured to allow 200 connections (I'm picking an arbitrary number). The connections per client is set to 10. If I have 198 connections already and a particular client has 5 connections, it can add two more. The limit is the user connections maximum of 200. On the other hand, if I have 12 connections already, 2 from a particular client, that client can add 8 more, bringing its total to 10. It can't add an 11th, because the maximum connections per client is limited to 10.

share|improve this answer
    
Thanks! I am confused what do you mean "client"? A machine has a specific IP address? A connection object of ADO.Net or a specific process/thread? –  George2 Oct 7 '09 at 10:45
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.