Startup

• williamminor

  SSCommitted

  Points: 1724

  More actions

  September 7, 2007 at 7:34 am

  #176560

  Is there a function or way to determine how many seconds have have gone by since server startup.  @@?

   

  I need to calculated some stuff with sys.dm_os_performance_counters and I think the operations/sec counters are cummulative.

   

  Thanks

  -WM

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  September 7, 2007 at 7:40 am

  #732136

  You can calculate the uptime using the sysprocesses.

  select

  DateDiff(ss,login_time, getdate())

  from sysprocesses

  where spid = 1

  Markus

  [font="Verdana"]Markus Bohse[/font]

• williamminor

  SSCommitted

  Points: 1724

  More actions

  September 7, 2007 at 7:45 am

  #732141

  thanks

  In addition to that are there any other functions that contain this info?

   

  -WM

• David McFarland

  SSChampion

  Points: 11815

  More actions

  September 7, 2007 at 8:42 am

  #732177

  Since you're using DMVs, I'm assuming this is on SS2005. If so, does the following return what you want?

  SELECT

  ms_ticks / 1000 FROM sys.dm_os_sys_info

   

• williamminor

  SSCommitted

  Points: 1724

  More actions

  September 7, 2007 at 8:49 am

  #732180

  That's what I was looking for thanks

   

  -WM