Post reply

is startup time held in any view?

  • July 10, 2008 at 4:17 am

    #193698

    This has got to be so easy but I need to extract the startup time of SQL server 2005 for a report and I cant find it anywhere!

    before I go completely :w00t: please can anyone tell me the view, procedure etc that I need.

    Thank you

    Sue

  • July 10, 2008 at 4:28 am

    #840717

    It's not stored anywhere alone that I know of.

    I usually query sys.dm_exec_sessions and get the login time of session_id 1. It's the Resource Monitor and it starts when SQL starts and does not disconnect.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 10, 2008 at 7:13 am

    #840784

    Thank you, that works a treat for what I need it for!

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

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