查询SQL SERVER运行了多长时间

[CN_SQL]

;WITH CTE AS
(
	SELECT
		DATEDIFF(SECOND,sqlserver_start_time,GETDATE()) AS started_last_time_s
	FROM sys.dm_os_sys_info		
)
,CTE2 AS
(
	SELECT
		started_last_days = started_last_time_s / 86400,
		started_last_time_s = started_last_time_s - (started_last_time_s / 86400) * 86400
	FROM CTE
) 
,CTE3 AS
(
	SELECT
		started_last_days,
		started_last_hours = started_last_time_s  / 3600,
		started_last_time_s = started_last_time_s - (started_last_time_s  / 3600) * 3600
	FROM CTE2
)
,CTE4 AS
(
	SELECT
		started_last_days,
		started_last_hours,
		started_last_minutes = started_last_time_s  / 60,
		started_last_time_s = started_last_time_s - (started_last_time_s  / 60) * 60
	FROM CTE3
)
,CTE5 AS
(
	SELECT
		started_last_days,
		started_last_hours,
		started_last_minutes,
		started_last_seconds = started_last_time_s
	FROM CTE4
)

SELECT
	 sqlserver_start_last_time = RTRIM(started_last_days) + ' days '
								+ RTRIM(started_last_hours) + ' hours '
								+ RTRIM(started_last_minutes) + ' minutes '
								+ RTRIM(started_last_seconds) + ' seconds'
								
FROM CTE5


/**
sqlserver_start_last_time
------------------------------------------------------------------------------
5 days 11 hours 27 minutes 47 seconds

(1 row(s) affected)

**/

[百年树人]

厉害！

[百年树人]

学习！

[conan304]

佩服，牛叉

[liangCK]

太强了..学习.

[csdyyr]

学习！

[liangCK]

CN_SQL.貌似2008的sys.dm_os_sys_info动态管理视图才有sqlserver_start_time

[CN_SQL]

[Quote=引用 6 楼 liangCK 的回复:]
CN_SQL.貌似2008的sys.dm_os_sys_info动态管理视图才有sqlserver_start_time
[/Quote]
那确实~

[you_tube]

学习

[ks_reny]

学习，楼主牛人。

[rmini]

好帖就应该顶呀！并且要用力顶呀！LZ

[WFF2999]

太强了..学习

[zhengduan964532]

go on studying ,thank you

[guaguafly]

SQL Server 2005可以使用tempdb的创建时间来代替启动时间