Knowledge Base

Determine SQL Server instance uptime

SQL Server does not provide an easy and simple query to Determine instance uptime, to achieve the following we can do a trick - tempdb database is being created every time we start SQL Server. Querying the create time of current reincarnation of temporary database will result in the Instance uptime. The table/columns we are interested is sysdatabase.

Read more: Determine SQL Server instance uptime