Below query gives the SQL Server Start time and Up time details.
This option is available from SQL Server 2008 and above and requires "VIEW SERVER STATE" permission to execute the query
This option is available from SQL Server 2008 and above and requires "VIEW SERVER STATE" permission to execute the query
SELECT sqlserver_start_time AS [SQL Server Start Time] ,CAST (DATEDIFF(MINUTE,sqlserver_start_time,GETDATE())/60 AS VARCHAR) + ' Hours ' +CAST (DATEDIFF(MINUTE,sqlserver_start_time,GETDATE())%60 AS VARCHAR) + ' Minutes' AS [Uptime] FROM sys.dm_os_sys_info
1 comment:
Having a quick and reliable way to monitor SQL Server uptime is exactly the kind of practical, precision-driven solution that every database administrator needs — and it's that same commitment to accuracy, detail, and technical reliability that sits at the heart of the most impactful radiography dissertation topics, where precision, evidence-based practice, and technical expertise are always absolutely everything!
Post a Comment