Tuesday, 14 February 2017

How to find the SQL Server Last Restarted date & time ?

One of the easiest way to find when SQL server was restarted is using Dynamic Management view (DMV).

In some of the scenarios we need to know when the SQL server was restarted.

DMV

SELECT * FROM SYS.DM_OS_SYS_INFO

Example

I have taken the Sqlserver_start_time column from the above view.

So now my SQL server instance restarted time is 2017-02-08.

No comments:

Post a Comment