Post reply

Current processes?

  • August 10, 2004 at 9:16 am

    #86041

    I am trying to get a better understanding of the current activity - process info listing.

     

    I notice that some of my applications are having some queries listed even though they are not running....their status will be 'sleeping'.

    Is this normal?

    If not, what could be the cause?

     

    If it is normal, why?

     

     

     

    -edited for correct terms-

  • August 13, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • August 16, 2004 at 9:42 am

    #519167

    It's normal.  The current activity window will show all current SQL Server connections.  So even though your application may be done running the query, it sounds like it still has a connection open.  It also shows the last query that the connection ran.

    HTH

    John 

Viewing 3 posts - 1 through 2 (of 2 total)

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