Jun 03, 2020, 03:32 AM

News:

MyKidsDiary.in :: Capture your kids magical moment and create your Online Private Diary for your kids


@@IDLE

Started by sukishan, Aug 19, 2009, 01:47 AM

previous topic - next topic
Go Down

sukishan

@@IDLE
Returns the time in milliseconds (based on the resolution of the system timer) that Microsoft® SQL Server™ has been idle since last started.

Syntax
@@IDLE

Return Types
integer

Remarks
To display a report containing several SQL Server statistics, run sp_monitor.

Examples
This example shows the number of milliseconds SQL Server was idle between the start time and the current time.

SELECT @@IDLE AS 'Idle ms', GETDATE() AS 'As of'
Here is the result set:

Idle Ms              As of
-----------------    ---------------------------
277593               1998-04-18  16:41:07.160
A good beginning makes a good ending

pradeep prem

this sql server is mainly solve problem
with this easy calculation to solve it

Go Up
 

Quick Reply

With Quick-Reply you can write a post when viewing a topic without loading a new page. You can still use bulletin board code and smileys as you would in a normal post.

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.
Name:
Email:
Verification:
Please leave this box empty:

Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:

shortcuts: alt+s submit/post or alt+p preview
IT Acumens Web Designing Chennai | GinGly :: Build your Personal Website | CineBuzz :: Cinema News | My Kids Diary :: Kids Memories Writing :: Book Website @ 349 Rs monthly
Copyright © 2005 - 2020 :: IT Acumens :: All Rights Reserved. :: Sitemap
ITAcumens Discussion Forum with 2 lakhs post running for 15 years - Powered by IT Acumens Dedicated Server