Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    Unanswered: SQL query timestamp

    How to find the starting timestamp and end timestamp of a sql that executed on the database. I tried snapshot on dynamic sql. It does not provide when the query started

  2. #2
    Join Date
    Aug 2002
    Location
    St. Louis
    Posts
    16
    You can use an event monitor for statements and capture detail about the execution of a statement including elapsed time, operation start and end times etc.

  3. #3
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    I cannot use event monitors. Does any of the snapshots provide this information ?

  4. #4
    Join Date
    Aug 2002
    Location
    St. Louis
    Posts
    16
    Using a command line window I can do a get snapshot for application agentid n - I get to see the start and end times of previous unit of work and operation. What uow or op that was is questionable. I find the snapshot to be most valuable when looking at cumulative counters - rows read by an app since connect etc. Capturing current operation is difficult and probably error prone. I'm working in V7.2 still so there may be improved facilities in 8/9.

    I know an event monitor gives that information - really useful info. You didn't say why you can't use an event monitor but I would feel naked without that functionality.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •