Post reply

Various connections for the same session

  • May 2, 2013 at 9:46 am

    #277338

    Hello:

    I'm working with SQL Server 2008 R2 and launching sys.dm_exec_connections and sys.dm_exec_sessions views I have found something strange: various connections for the same session.

    I have copied a piece of the result to an attached .text file with 3 connections sharing a session.

    Could someone give some explanation for this issue?

    Could this be related to using multiple threads in a client application?

    Thanks in advance,

    Ignacio

  • May 2, 2013 at 10:41 am

    #1611971

    Please provide the query that was used to get this result.

    Jared
    CE - Microsoft

  • May 2, 2013 at 11:01 am

    #1611977

    Jared:

    Im afraid I only have access to the database. This is issued from an application I can't access.

    Thanks,

    Ignacio

  • May 2, 2013 at 11:48 am

    #1611985

    i would swear there was a similar post a few months back, and i seem to remember that if a query uses parallelism, you can see this behavior?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply