Different ways to check the last Restart time of SQL Server

Knowing when your SQL Server instance was last started can be helpful for various reasons. In this tip, we will explore a few methods you can use to determine when your SQL Server instance was last started up.



Method 1: Use Dynamic Management View sys.dm_os_sys_info

Use the DMV sys.dm_os_sys_info to check the SQL Server start time.

SELECT sqlserver_start_time FROM sys.dm_os_sys_info


Method 2: Use TempDB database creation time

SQL Server creates a new TempDB database every time SQL Services starts. Therefore, you can check the database creation timestamp using the below query to find out when SQL Services were started.

SELECT create_date FROM sys.databases WHERE name = 'tempdb'
Method 3: Use SQL Server Dashboard Reports

Right-click on the SQL instance and navigate to Reports-> Standard Reports and Server Dashboard.


It shows the server start-up time in the configuration details section below.



85 views0 comments