C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




How to find the time SQL Server has spent working since SQL Server was started


Posted Date: 05 Mar 2008    Resource Type: Code Snippets    Category: SQL
Posted By: Ashwini Rupert       Member Level: Diamond
Rating:     Points: 10



This code snippet returns the time that SQL Server has spent working since it was last started. Result is in CPU time increments, or "ticks," and is cumulative for all CPUs, so it may exceed the actual elapsed time. @@CPU_BUSY has to be Multiplied by @@TIMETICKS to convert to microseconds.




								
SELECT 
     @@CPU_BUSY * CAST(@@TIMETICKS AS FLOAT) AS 'CPU microseconds', 
    GETDATE() AS 'As of'



Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks      
Popular Tags   What are tags ?   Search Tags  
(No tags found.)

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: How to find out the number of attempted connections to an SQL Server since last started
Previous Resource: How to get the maximum precision used by data types
Return to Discussion Resource Index
Post New Resource
Category: SQL


Post resources and earn money! 		 
Related Resources


dotNet Slackers   BizTalk Adaptors    Web Design

doors in nj

Contact Us    Privacy Policy    Terms Of Use