Re: Duration values misreported in Profiler

Running the trace again, it's continuing to misreport. For example,

StartTime: 2007-11-01 14:52:17.153
EndTime: 2007-11-01 14:52:17.170
Duration: 18446744073709539

It's pretty much arbitrary between stored procedures and times.. This is a
production box, so I'm not keen to reboot it to fix what may just be
curiosity, but I'll update this discussion as and when I have more
information.

dvc

"Andrew J. Kelly" wrote:

That is what I run as well and I have not noticed this behavior. It would be
interesting to see if it can be repeated or even happens again.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"dvc" <dvc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3F356125-5D4F-4CBC-B7CF-3427206CF5EC@xxxxxxxxxxxxxxxx
The server is at 9.00.3054.00, so nothing unusual there, I would have
thought.

"Andrew J. Kelly" wrote:

Exactly which rollups do you have? I have some minor hot fixes and have
never noticed this behavior.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"dvc" <dvc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F34C874F-B9FE-468D-89F0-79E4B73C10C0@xxxxxxxxxxxxxxxx
Profiler (this is SQL Server 2005 SP2 with rollups) is reporting some
interesting duration values for stored procedure execution:
StartTime: 2007-11-01 10:17:58.180.
EndTime: 2007-11-01 10:17:58.180.
Duration: 18446744073709532

I wonder if anyone else has seen this, or is my server just doing a bit
of
time travelling?

Thank you.

DVC




.

Relevant Pages

  • Re: How to improve SQL Server 2000 performance?
    ... > But a few stored procedures to be rewritten if you switch back ends should ... > Andrew J. Kelly SQL MVP ... >> parameterized statements is that the SQL statement only compiles for the ... >>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Duration values misreported in Profiler
    ... it may be causing problems. ... Time calculations for the duration value are done using the processor frequency as parameter. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Duration values misreported in Profiler
    ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... > interesting duration values for stored procedure execution: ...
    (microsoft.public.sqlserver.tools)
  • Re: Duration values misreported in Profiler
    ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... interesting duration values for stored procedure execution: ...
    (microsoft.public.sqlserver.tools)
  • Re: Stored Procedure VS Trigger
    ... Stored procedures will not catch any activity directly against the tables, ... Andrew J. Kelly SQL MVP ... "Silaphet" wrote in message ...
    (microsoft.public.sqlserver.programming)
Loading