.NET and SQL database lost sessions on Locks/Object pane

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • MC

    #1

    .NET and SQL database lost sessions on Locks/Object pane

    Hi!

    I have noticed this strange problem I cannot explain when I connect to sql
    server using .net:


    I use a .NET app to connect to a sql server database. When I do so, two
    strange things happen at the database.
    I can watch them in Enterprise Manager's Current Activity pane, and
    refreshing it.


    First, some times I get two Process IDs in the database, after invoking
    Connection.Open call at the code. Some times, only one Process ID is
    created.
    Why is that?


    Second, after explicity closing my connection and disposing it, at least one
    Process ID remains.
    **The problem happens even with Microsoft's Application Blocks samples** at
    http://msdn.microsoft.com/library/de...ml/daab-rm.asp.

    Only closing my app makes those Process IDs dessapear from the database.
    In ASP.NET I have to kill aspnet_wp in order to clean them.


    I do not use in the tests any database related object (SQLReader, Dataset,
    ....). You can watch this using only Connection.Open , Connection.Clos e and
    CType(connectio n, IDisposable).Di spose() methods.

    I have tried it on different machines with different SQL servers and
    configurations.
    The behavior is allways the same.


    Can anyone give me a good reason for this?


    Thanks in advance.


    -- MC


Working...