从 t-sql 中找出 sql server 服务已经运行了多长时间 [英] Find out how long the sql server service has been running, from t-sql

问题描述

我想知道是否可以从 sql server 内部算出 sql server 已经运行了多长时间.

I'd like if its possible to work out from inside sql server how long sql server has been running.

希望将其与 DMV 之一结合用于未使用的索引，但每次 sql server 加载时计数器都会重新设置，所以我想知道它们会有多大用处.

Would like to use this in conjunction with one of the DMV's for unused indexes, but the counters are re-set every time sql server loads, so I'd like to know how useful they're going to be.

推荐答案

SELECT
    login_time
FROM
    sys.dm_exec_sessions
WHERE
    session_id = 1

将为您提供服务器启动时间的datetime.

will give you a datetime for when the server was started.

这篇关于从 t-sql 中找出 sql server 服务已经运行了多长时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！