SQL Server Performance

Hung Process id issue

Discussion in 'SQL Server 2005 General DBA Questions' started by ashish.johri, Jul 2, 2008.

  1. ashish.johri New Member

    Hi Team,
    Yesterday I got following information in event viewer in one sql server.
    "This instance of SQL Server has been using a process id of 1512 since 4/1/2008 8:54:30 PM (local) 7/2/2008 3:54:30 AM (UTC)."
    If the message is true then this has been using this spid for last 4 months. When I run sp_who2 in master DB, I was not able to find the particular spid. This doesn't seem to me a fake message. Please let me know where I am wrong.
    Regards,
    Ashish
    ashish.johri, Jul 2, 2008
    #2

  2. satya Moderator

    What is the number associated to that SPID?
    I think it si the session that had been started, and eventually started a transaction but never commited. Or may be the reboot had forced the rollback, essentially completed the transaction.

    satya, Jul 2, 2008
    #3

  3. ashish.johri New Member

    Thanks Satya,
    I have one question:
    If the sql server is restarted then the transaction which are running would stop in between and will roll back.
    I want to know that in this case if we execute sp_who2 then would we see the spids? I am not sure.
    Regards,
    Ashish Johri
    ashish.johri, Jul 2, 2008
    #4

  4. satya Moderator

    satya, Jul 3, 2008
    #5

Share This Page