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. suman10 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. suman10 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

How to encrypt and decrypt Table data in postgres

For encrypting and decrypting , we must use the bytea data type on the column which we implement. Bcoz bytea will use the pgcrypto method by default. However, you will need to create the pgcrypto extension to enable these functions as they are not pre-defined in PostgreSQL/PPAS. Example CREATE EXTENSION pgcrypto; CREATE TABLE userinfo (username varchar(20), password bytea); >>    Inserting the data in an encrypted format INSERT INTO userinfo VALUES(' suman ',encrypt('111222','password','aes')); select * from userinfo ; >>    Retrieving the data as decrypted format SELECT decrypt(password,decode('password','escape'::text),'aes'::text) FROM userinfo; Thanks for reading Plz dont forget to like Facebook Page.. https://www.facebook.com/pages/Sql-DBAcoin/523110684456757
1 comment
Read more

How to recover msdb database from suspect mode

 It was Monday 9 th Jun 47 degr. temperature of Delhi-NCR. Temperature was like boiling me and database. When I reached my office( @ 8.45 am) got an alert from one of Server. “MSDB is in suspected mode” At the same time comes in my mind, this issue will boil me today.. I just tried to cool my self through cold drink then connected server from my local system using windows authentication mode..
5 comments
Read more

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