Post reply

SQL Server Uptime

  • September 27, 2012 at 8:51 pm

    #264930

    Comments posted to this topic are about the item SQL Server Uptime

  • September 28, 2012 at 7:48 am

    #1543427

    Another one which states when server is ready to rock 'n roll

    USE master;

    SELECT login_time FROM sysprocesses

    WHERE spid = 1

    This return comes later then tempdb creation because in between a lots of DBCC checks and rollbacks/forwards are being performed before server is up and running.

    No big deal, we are talking seconds most of the time depending on sizes and other trivial stuff 😉

  • May 9, 2016 at 1:32 pm

    #1877609

    Thanks for the script.

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

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