Strange durations in Profiler

#1

When running profiler I am seeing strange duration times on some of
the processes. I have seen large numbers before on a logout, but this
is on stored procedure exectution times. It shows up about every 30
lines or so. The value is in the trillions, so it can not be
correct. The values always start with the same numbers only the last
2 or 3 numbers vary. Example: 18446744073709478. Anyone seen this
before?

#2

I have seen that before. Unfortunately I was unable to find a fix. My
best guess is that it's either a calculation error in the code which
produces the trace, or the command is running so quickly that SQL
can't come up with an actual run time for it. (My best guess is the
first one.)

I haven't seen the problem in a while, but I'm currently running the
SQL 2008 GUI on my workstation.

Denny

On Thu, 17 Jul 2008 09:31:02 -0700 (PDT), jim.steiner (AT) rackspace (DOT) com
wrote:

Quote:

When running profiler I am seeing strange duration times on some of
the processes. I have seen large numbers before on a logout, but this
is on stored procedure exectution times. It shows up about every 30
lines or so. The value is in the trillions, so it can not be
correct. The values always start with the same numbers only the last
2 or 3 numbers vary. Example: 18446744073709478. Anyone seen this
before?

#3

I have seen that before. Unfortunately I was unable to find a fix. My
best guess is that it's either a calculation error in the code which
produces the trace, or the command is running so quickly that SQL
can't come up with an actual run time for it. (My best guess is the
first one.)

I haven't seen the problem in a while, but I'm currently running the
SQL 2008 GUI on my workstation.

Denny

On Thu, 17 Jul 2008 09:31:02 -0700 (PDT), jim.steiner (AT) rackspace (DOT) com
wrote:

Quote:

When running profiler I am seeing strange duration times on some of
the processes. I have seen large numbers before on a logout, but this
is on stored procedure exectution times. It shows up about every 30
lines or so. The value is in the trillions, so it can not be
correct. The values always start with the same numbers only the last
2 or 3 numbers vary. Example: 18446744073709478. Anyone seen this
before?

#4

I have seen that before. Unfortunately I was unable to find a fix. My
best guess is that it's either a calculation error in the code which
produces the trace, or the command is running so quickly that SQL
can't come up with an actual run time for it. (My best guess is the
first one.)

I haven't seen the problem in a while, but I'm currently running the
SQL 2008 GUI on my workstation.

Denny

On Thu, 17 Jul 2008 09:31:02 -0700 (PDT), jim.steiner (AT) rackspace (DOT) com
wrote:

Quote:

When running profiler I am seeing strange duration times on some of
the processes. I have seen large numbers before on a logout, but this
is on stored procedure exectution times. It shows up about every 30
lines or so. The value is in the trillions, so it can not be
correct. The values always start with the same numbers only the last
2 or 3 numbers vary. Example: 18446744073709478. Anyone seen this
before?

#5

I have seen that before. Unfortunately I was unable to find a fix. My
best guess is that it's either a calculation error in the code which
produces the trace, or the command is running so quickly that SQL
can't come up with an actual run time for it. (My best guess is the
first one.)

I haven't seen the problem in a while, but I'm currently running the
SQL 2008 GUI on my workstation.

Denny

On Thu, 17 Jul 2008 09:31:02 -0700 (PDT), jim.steiner (AT) rackspace (DOT) com
wrote:

Quote:

When running profiler I am seeing strange duration times on some of
the processes. I have seen large numbers before on a logout, but this
is on stored procedure exectution times. It shows up about every 30
lines or so. The value is in the trillions, so it can not be
correct. The values always start with the same numbers only the last
2 or 3 numbers vary. Example: 18446744073709478. Anyone seen this
before?

#6

I have seen that before. Unfortunately I was unable to find a fix. My
best guess is that it's either a calculation error in the code which
produces the trace, or the command is running so quickly that SQL
can't come up with an actual run time for it. (My best guess is the
first one.)

I haven't seen the problem in a while, but I'm currently running the
SQL 2008 GUI on my workstation.

Denny

On Thu, 17 Jul 2008 09:31:02 -0700 (PDT), jim.steiner (AT) rackspace (DOT) com
wrote:

Quote:

When running profiler I am seeing strange duration times on some of
the processes. I have seen large numbers before on a logout, but this
is on stored procedure exectution times. It shows up about every 30
lines or so. The value is in the trillions, so it can not be
correct. The values always start with the same numbers only the last
2 or 3 numbers vary. Example: 18446744073709478. Anyone seen this
before?

#7

I have seen that before. Unfortunately I was unable to find a fix. My
best guess is that it's either a calculation error in the code which
produces the trace, or the command is running so quickly that SQL
can't come up with an actual run time for it. (My best guess is the
first one.)

I haven't seen the problem in a while, but I'm currently running the
SQL 2008 GUI on my workstation.

Denny

On Thu, 17 Jul 2008 09:31:02 -0700 (PDT), jim.steiner (AT) rackspace (DOT) com
wrote:

Quote:

When running profiler I am seeing strange duration times on some of
the processes. I have seen large numbers before on a logout, but this
is on stored procedure exectution times. It shows up about every 30
lines or so. The value is in the trillions, so it can not be
correct. The values always start with the same numbers only the last
2 or 3 numbers vary. Example: 18446744073709478. Anyone seen this
before?

#8

I have seen that before. Unfortunately I was unable to find a fix. My
best guess is that it's either a calculation error in the code which
produces the trace, or the command is running so quickly that SQL
can't come up with an actual run time for it. (My best guess is the
first one.)

I haven't seen the problem in a while, but I'm currently running the
SQL 2008 GUI on my workstation.

Denny

On Thu, 17 Jul 2008 09:31:02 -0700 (PDT), jim.steiner (AT) rackspace (DOT) com
wrote:

Quote:

When running profiler I am seeing strange duration times on some of
the processes. I have seen large numbers before on a logout, but this
is on stored procedure exectution times. It shows up about every 30
lines or so. The value is in the trillions, so it can not be
correct. The values always start with the same numbers only the last
2 or 3 numbers vary. Example: 18446744073709478. Anyone seen this
before?

#9

I have seen that before. Unfortunately I was unable to find a fix. My
best guess is that it's either a calculation error in the code which
produces the trace, or the command is running so quickly that SQL
can't come up with an actual run time for it. (My best guess is the
first one.)

I haven't seen the problem in a while, but I'm currently running the
SQL 2008 GUI on my workstation.

Denny

On Thu, 17 Jul 2008 09:31:02 -0700 (PDT), jim.steiner (AT) rackspace (DOT) com
wrote:

Quote:

When running profiler I am seeing strange duration times on some of
the processes. I have seen large numbers before on a logout, but this
is on stored procedure exectution times. It shows up about every 30
lines or so. The value is in the trillions, so it can not be
correct. The values always start with the same numbers only the last
2 or 3 numbers vary. Example: 18446744073709478. Anyone seen this
before?

#10

I have seen that before. Unfortunately I was unable to find a fix. My
best guess is that it's either a calculation error in the code which
produces the trace, or the command is running so quickly that SQL
can't come up with an actual run time for it. (My best guess is the
first one.)

I haven't seen the problem in a while, but I'm currently running the
SQL 2008 GUI on my workstation.

Denny

On Thu, 17 Jul 2008 09:31:02 -0700 (PDT), jim.steiner (AT) rackspace (DOT) com
wrote:

Quote:

When running profiler I am seeing strange duration times on some of
the processes. I have seen large numbers before on a logout, but this
is on stored procedure exectution times. It shows up about every 30
lines or so. The value is in the trillions, so it can not be
correct. The values always start with the same numbers only the last
2 or 3 numbers vary. Example: 18446744073709478. Anyone seen this
before?