EM Current Activity

  • I am new to Enterprise Manager.  When viewing the current activity process info in Enterprise Manager, I've noticed that the processes continue to grow.  Is this a problem or can it eventually become a problem?

    Dee

     

  • Short answer.

    The Process Info is indicating all the connections to that sql server.

    When a connection is establised it is given a Spid. When a connection is closed the Spid is droped for reuse.

    If the connecting app/user does not close their connection you can run out of connections. 

    Having alot of connections open for a long period of time indicates a problem with the calling application/Users.

    You can clean up unwanted connections using the kill command

     

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

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