Skip to main content

Connection and Sessions


What is the differences between Connection and Sessions in SQL-Server?

The CONNECTION is the physical communication channel between SQL Server and the applications: the TCP socket, the named pipe, the shared memory . The connections show only external connections and each connection has an spid.

select a.spid , a.nt_username , a.loginame , a.program_name from sys.sysprocesses a , sys.dm_exec_connections b where a.spid=b.session_id

A SESSION is a semi-permanent interactive information interchange, between two or more communicating devices  or between an application and users.

We must open a connection in order to create a session. Normally there is one session on each connection, but there could be multiple session on a single connection.

eg. If we connect to sql server using management studio then its one connection. once we connected we can  open 3 query windows then these are 3 sessions.

Microsoft  SQL-Server has two DMVs to maintain Sessions and Connections :-

1.       Sys.dm_exec_sessions
2.       sys.dm_exec_connections


Happy Reading
Sumanjha_Accidental_Dba

Labels:

Comments

  1. Anonymous23 June 2014 at 11:43

    I really like what you guys are usually up too. Such clever work and coverage!

    Keep up the terrific works guys I've included you guys to blogroll.


    my web-site: duvet covers queen

    ReplyDelete
    Replies
    1. Suman kumar 10 July 2014 at 21:08

      Thank you so much friend such a nice comment on my post.. you really encourage my works...

      Delete
  2. Anonymous23 June 2014 at 16:26

    Heya this is kind of of offf topic but I was wanting to know if blogs
    use WYSIWYG editors or if you have to manually code with HTML.

    I'm starting a blog soon but have no coding skills so I wanted to get
    advice from someone with experience. Any hewlp would be enormously appreciated!


    my web-site - queen duvet covers

    ReplyDelete
  3. Anonymous23 June 2014 at 16:58

    Asking questions are really pleasant thing if you are not understanding something
    totally, but this article presents good understanding even.

    Here is my homepage; kids comforter sets

    ReplyDelete
  4. Suman kumar 10 July 2014 at 21:08

    thnks

    ReplyDelete

Post a Comment

Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757

Popular posts from this blog

History of MySQL from AB Corp to Cloud Database

MySQL was created by a Swedish company, MySQL AB, founded by David Axmark, Allan Larsson and Michael "Monty" Widenius. Original development of MySQL by Widenius and Axmark began in 1994. The first version of MySQL appeared on 23 May 1995. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter,and "SQL", the abbreviation for Structured Query Language. ·          23 May 1995 - First internal release ·          Year 1996 - Version 3 o     Simple CRUD operations o     January 1997 Windows version was released on 8 January 1998 for Windows 95 and NT o     production release 1998, from www.mysql.com ·          Year 2002 - Version 4 o     MyISAM o     unions o     Tracking o     B-trees o     s...
34 comments
Read more

How to add an article in Transactional Replication

If we have a set-up of Transactional Replication for Data Distribution running and wanting to add new object to replication on other server we can follow below process. To add an article In Transaction replication with PUSH Subscription 
29 comments
Read more

Configure Impersonation Authentication in IIS8 for MVC Application

Impersonation is when ASP.NET executes code in the context of an authenticated and authorized client. By default, ASP.NET does not use impersonation and instead executes all code using the same user account as the ASP.NET process, which is typically the ASPNET account. There are 5 below steps by which we can establish Impersonation configuration in our secured application environment. 1.)    Creation of Application/Proxy user where Application is hosted. 2.)    Give appropriate access to the user. 3.)    Create Database Login user on database. 4.)    Authenticate User and provide credential on IIS. 5.)    Then Configure web.config on Application.
28 comments
Read more