There may be a situation where you want to know the SQL Server service start date, time and total up time. I have written a simple T-Sql script using DMV to find the same, which is as below:
--======================================================================
SELECT 'Your Microsoft SQL server started On ' +
CAST( (DATEname (WEEKDAY , sqlserver_start_time ))as varchar(12))
+' '+ CONVERT( varchar(20), sqlserver_start_time, 107)+' ' +'At'+ CONVERT( varchar(20), sqlserver_start_time, 108)
+' and is UP and Running From '+
CAST((DATEDIFF(MINUTE,sqlserver_start_time,GETDATE()))/60 AS VARCHAR(5)) + ' Hours and '
+RIGHT('0' + CAST(((DATEDIFF(MINUTE,sqlserver_start_time,GETDATE()))%60) AS VARCHAR(2)),2) + ' Minutes. '
AS [SQl Server Start Time & Total UpTime] FROM sys.dm_os_sys_info
--==================================================================
You can also check temp DB Creation time for same as every time when we start sql server, temp db is created.
--======================================================================
SELECT 'Your Microsoft SQL server started On ' +
CAST( (DATEname (WEEKDAY , sqlserver_start_time ))as varchar(12))
+' '+ CONVERT( varchar(20), sqlserver_start_time, 107)+' ' +'At'+ CONVERT( varchar(20), sqlserver_start_time, 108)
+' and is UP and Running From '+
CAST((DATEDIFF(MINUTE,sqlserver_start_time,GETDATE()))/60 AS VARCHAR(5)) + ' Hours and '
+RIGHT('0' + CAST(((DATEDIFF(MINUTE,sqlserver_start_time,GETDATE()))%60) AS VARCHAR(2)),2) + ' Minutes. '
AS [SQl Server Start Time & Total UpTime] FROM sys.dm_os_sys_info
--==================================================================
You can also check temp DB Creation time for same as every time when we start sql server, temp db is created.
Thanks!!!
No comments:
Post a Comment