2

I have a simple question.

What is the difference between Logical connection and User connection in MS SQL server ?

I am using perfmon to get SQL connection count. In that I found two options, Logical connection and User connection. But no where I am getting the exact differences between these.

So please help me.

| improve this question | | | | |
3

I looked into the Books Online Doc, it says

Number of logical connections to the system.

The main purpose of logical connections is to service multiple active result sets (MARS) requests. For MARS requests, every time that an application makes a connection to SQL Server, there may be more than one logical connection that corresponds to a physical connection.

When MARS is not used, the ratio between physical and logical connections is 1:1. Therefore, every time that an application makes a connection to SQL Server, logical connections will increase by 1.

| improve this answer | | | | |
  • That comparison is between Logical and Physical connection. Whether user connection and physical connections are same ? Also I didnt understand meaning of Logical connection from that definition and that is why I asked in this forum. Can you please explain with an example if you understood that definition. – IT researcher Aug 3 '16 at 12:10
  • The whole difference relies on whether you understand MARS, do you ?. What it is saying is with MARS being active the same physical connection or user connection can open new logical connection. Basically it allows applications to have more than one pending request per connection, and in particular, to have more than one active default result set per connection. I suggest you read MARS definition from BOL. – Shanky Aug 3 '16 at 12:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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