Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2002
    Location
    Sunnyvale, CA USA
    Posts
    78

    Unanswered: When did the SQL server instance come up?

    Is there a system table (or metric) that you can look at to determine the date/time the SQL server instance came up? Thanks

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    What do you mean by came up?

    How about the log file?

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245

    Re: When did the SQL server instance come up?

    I think your answer is in the sysperfinfo table. I'm struggling to remember exactly how to determine it. It's not a straightforward number as I recall, but the denominator (or base counter) for another entry in the table.

    Also, take a look at sp_monitor. This gives you total number of seconds (SQL, IO and Idle) that a server has been up.

    Check out SQL BOL on sp_monitor.

    Regards,

    Hugh Scott

    Originally posted by andyabel
    Is there a system table (or metric) that you can look at to determine the date/time the SQL server instance came up? Thanks

  4. #4
    Join Date
    Jan 2003
    Location
    Surrey, UK
    Posts
    23
    connect to the instance and run

    use master
    GO

    select login_time from sysprocesses where spid=1
    GO
    Andy


  5. #5
    Join Date
    Apr 2002
    Location
    Sunnyvale, CA USA
    Posts
    78
    Thanks! I think this is the answer I wanted.

    Originally posted by MealinA
    connect to the instance and run

    use master
    GO

    select login_time from sysprocesses where spid=1
    GO

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •