Post reply

waittime in sysprocesses table

  • October 1, 2007 at 12:16 pm

    #70130

    waittime is int data type, which means it is up to 2,147,483,647 millionseconds (35 minutes). What if I need to monitor a process which takes longer than 35 minutes, for example 1 hour? Is there a way to bypass this limitation?

  • October 1, 2007 at 3:29 pm

    #737919

    Erm ...

    waittime is in MILLISECONDS ...

    select 2147483647 / (1000*60*60)

    -- 596 Hrs


    * Noel

  • October 1, 2007 at 5:31 pm

    #737938

    Thank you. Math mistake 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply