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.
コメント