.::: Query Check SQL Server Uptime MSSQL :::.

 1. Check

SELECT @@servername as servername,getdate() as TimeCollect,sqlserver_start_time, DATEDIFF(Day, sqlserver_start_time,getdate()) as sql_uptime_day ,
DATEDIFF(hour, sqlserver_start_time,getdate()) as sql_uptime_hours,DATEDIFF(minute, sqlserver_start_time,getdate()) as sql_uptime_minutes,
DATEDIFF(second, sqlserver_start_time,getdate()) as sql_uptime_second,DATEDIFF(millisecond, sqlserver_start_time,getdate()) as sql_uptime_milisecond
FROM sys.dm_os_sys_info;

 2.  Query 2

DECLARE @start_time datetime;
DECLARE @uptime_seconds int;

-- Mendapatkan waktu awal saat layanan SQL Server mulai
SELECT @start_time = create_date FROM sys.databases WHERE name = 'tempdb';

-- Mendapatkan waktu sekarang
DECLARE @current_time datetime = GETDATE();

-- Menghitung jumlah detik uptime
SELECT @uptime_seconds = DATEDIFF(SECOND, @start_time, @current_time);

-- Konversi detik ke hari, jam, menit, detik
DECLARE @days int, @hours int, @minutes int, @seconds int;

SET @days = @uptime_seconds / (24 * 3600);
SET @hours = (@uptime_seconds % (24 * 3600)) / 3600;
SET @minutes = (@uptime_seconds % 3600) / 60;
SET @seconds = @uptime_seconds % 60;

-- Output
SELECT @@servername as ServerName,@days AS 'Days', @hours AS 'Hours', @minutes AS 'Minutes', @seconds AS 'Seconds',@@version as VersionSQL;

 

 

DECLARE @start_time DATETIME;
DECLARE @current_time DATETIME;
DECLARE @uptime_seconds INT;

-- Mendapatkan waktu awal saat layanan SQL Server mulai
SELECT @start_time = create_date
FROM sys.databases
WHERE name = 'tempdb';

-- Waktu sekarang
SET @current_time = GETDATE();

-- Menghitung jumlah detik uptime
SET @uptime_seconds = DATEDIFF(SECOND, @start_time, @current_time);

-- Konversi detik ke hari, jam, menit, detik
DECLARE @days INT,
        @hours INT,
        @minutes INT,
        @seconds INT;

SET @days = @uptime_seconds / (24 * 3600);
SET @hours = (@uptime_seconds % (24 * 3600)) / 3600;
SET @minutes = (@uptime_seconds % 3600) / 60;
SET @seconds = @uptime_seconds % 60;

-- Output
SELECT
    @@SERVERNAME AS ServerName,
    @current_time AS CurrentDateTime,
    @start_time AS ServiceStartTime,
    @days AS [Days],
    @hours AS [Hours],
    @minutes AS [Minutes],
    @seconds AS [Seconds],
    @@VERSION AS VersionSQL;

3. query 3

 
DECLARE @start_time datetime;
DECLARE @uptime_seconds int;

-- Mendapatkan waktu awal saat layanan SQL Server mulai
SELECT @start_time = create_date FROM sys.databases WHERE name = 'tempdb';

-- Mendapatkan waktu sekarang
DECLARE @current_time datetime = GETDATE();

-- Menghitung jumlah detik uptime
SELECT @uptime_seconds = DATEDIFF(SECOND, @start_time, @current_time);

-- Konversi detik ke hari, jam, menit, detik
DECLARE @days int, @hours int, @minutes int, @seconds int;

SET @days = @uptime_seconds / (24 * 3600);
SET @uptime_seconds = @uptime_seconds % (24 * 3600);

SET @hours = @uptime_seconds / 3600;
SET @uptime_seconds = @uptime_seconds % 3600;

SET @minutes = @uptime_seconds / 60;
SET @seconds = @uptime_seconds % 60;

-- Output dalam format hari:jam:menit:detik
SELECT @@servername as ServerName,
    CAST(@days AS varchar(10)) + ':' +
    RIGHT('0' + CAST(@hours AS varchar(2)), 2) + ':' +
    RIGHT('0' + CAST(@minutes AS varchar(2)), 2) + ':' +
    RIGHT('0' + CAST(@seconds AS varchar(2)), 2) AS 'Uptime',@@version as VersionSQL;
 

4. query with start time 

DECLARE @start_time DATETIME;
DECLARE @current_time DATETIME;
DECLARE @uptime_seconds INT;

-- Waktu SQL Server mulai (berdasarkan tempdb)
SELECT @start_time = create_date
FROM sys.databases
WHERE name = 'tempdb';

-- Waktu saat ini
SET @current_time = GETDATE();

-- Hitung uptime dalam detik
SET @uptime_seconds = DATEDIFF(SECOND, @start_time, @current_time);

-- Konversi ke hari, jam, menit, detik
DECLARE @days INT,
        @hours INT,
        @minutes INT,
        @seconds INT;

SET @days = @uptime_seconds / 86400;
SET @uptime_seconds = @uptime_seconds % 86400;

SET @hours = @uptime_seconds / 3600;
SET @uptime_seconds = @uptime_seconds % 3600;

SET @minutes = @uptime_seconds / 60;
SET @seconds = @uptime_seconds % 60;

SELECT
    @@SERVERNAME AS ServerName,
    @current_time AS CurrentDateTime,
    @start_time AS ServiceStartTime,
    CAST(@days AS VARCHAR(10)) + ':' +
        RIGHT('00' + CAST(@hours AS VARCHAR(2)), 2) + ':' +
        RIGHT('00' + CAST(@minutes AS VARCHAR(2)), 2) + ':' +
        RIGHT('00' + CAST(@seconds AS VARCHAR(2)), 2) AS Uptime,
    @@VERSION AS VersionSQL;