是否有SQL查询来获取SSRS启动时间或开始时间

Question

我正在寻找一种方法来确定SSRS (SQL Server Reporting Services)使用SQL查询运行了多长时间。

任何想法?

Answer 1

使用此参数来确定SQL Server实例已经运行了多长时间
如何查看SQL Server的正常运行时间

USE master;
SET NOCOUNT ON
DECLARE @crdate DATETIME, @hr VARCHAR(50), @min VARCHAR(5)
SELECT @crdate = crdate
FROM sysdatabases
WHERE NAME = 'tempdb'
SELECT @hr = (DATEDIFF(mi, @crdate, GETDATE())) / 60
IF ((DATEDIFF(mi, @crdate, GETDATE())) / 60) = 0
    SELECT @min = (DATEDIFF(mi, @crdate, GETDATE()))
ELSE
    SELECT @min = (DATEDIFF(mi, @crdate, GETDATE())) - ((DATEDIFF(mi, @crdate, GETDATE())) / 60
            ) * 60
PRINT 'SQL Server "' + CONVERT(VARCHAR(20), SERVERPROPERTY('SERVERNAME')) + '" is Online for the past ' + 
    @hr + ' hours & ' + @min + ' minutes'
IF NOT EXISTS (
        SELECT 1
        FROM master.dbo.sysprocesses
        WHERE program_name = N'SQLAgent - Generic Refresher'
        )
BEGIN
    PRINT 'SQL Server is running but SQL Server Agent <<NOT>> running'
END
ELSE
BEGIN
    PRINT 'SQL Server and SQL Server Agent both are running'
END