SQL @@IDLE Statistical Function returns the total idle time of this SQL Server since it last began. Syntax behind this is @@IDLE is
@@IDLE
SQL @@IDLE Example
Below code snippet shows the total idle time since this SQL Server last started.
SELECT @@IDLE AS 'Idle Time'

You can use @@TIMETICKS to get the idle time in microseconds. Next, we used the GETDATE() function to see the total idle time until today.
SELECT @@CONNECTIONS AS [Total Log In Attempts], SELECT @@IDLE AS 'Idle Time', @@IDLE * CAST(@@TIMETICKS AS FLOAT) AS 'Idle Time in Microseconds', GETDATE() AS 'As Of Today'
