Strange durations in Profiler
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 12 articles for 0.004 sec
Re: Strange durations in Profiler     

Group: microsoft.public.sqlserver.tools · Group Profile · Search for Strange durations in Profiler in microsoft.public.sqlserver.tools
Author: Anand
Date: Jul 30, 2008 07:32

...recently discovered that SQL Server 2005 reports duration in microseconds (as opposed to milliseconds in previous versions), but Profiler still shows it in milliseconds. This ... larger numbers than when viewing it through Profiler. I have never seen Duration in trillions though - looks like some proc of....com" wrote: When running profiler I am seeing strange duration times on some ...
Show full article (1.30Kb) · Show article thread
RE: Strange durations in Profiler     

Group: microsoft.public.sqlserver.tools · Group Profile · Search for Strange durations in Profiler in microsoft.public.sqlserver.tools
Author: Linchi Shea
Date: Jul 17, 2008 17:36

...CPU on scheduler id 2 is not synchronized with other CPUs" in the errorlog? Linchi "jim.steiner@rackspace.com" wrote: 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...
Show full article (0.67Kb) · Show article thread
Re: Strange durations in Profiler     

Group: microsoft.public.sqlserver.tools · Group Profile · Search for Strange durations in Profiler in microsoft.public.sqlserver.tools
Author: Andrew J. Kelly
Date: Jul 17, 2008 12:55

... Mentors <jim.steiner@rackspace.com> wrote in message news:ee8f6d77-3fe3-4597-8a65-815a880f6745@59g2000hsb.googlegroups.com... 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 ...
Show full article (0.79Kb) · Show article thread
Re: Strange durations in Profiler     

Group: microsoft.public.sqlserver.tools · Group Profile · Search for Strange durations in Profiler in microsoft.public.sqlserver.tools
Author: Denny Cherry
Date: Jul 17, 2008 10:15

... 2008 GUI on my workstation. Denny On Thu, 17 Jul 2008 09:31:02 -0700 (PDT), jim.steiner@rackspace.com wrote: 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 ...
Show full article (0.89Kb) · Show article thread
Strange durations in Profiler     

Group: microsoft.public.sqlserver.tools · Group Profile · Search for Strange durations in Profiler in microsoft.public.sqlserver.tools
Author: jim.steiner
Date: Jul 17, 2008 09:31

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: ...
Show full article (0.41Kb)
strange arguments passing problem (from vba to fortran dll)     

Group: comp.lang.fortran · Group Profile · Search for Strange durations in Profiler in comp.lang.fortran
Author: formulae translator
Date: May 28, 2007 15:01

Dear all, I encounter a strange problem when I am trying ...(control, ma, f_max, ppw, & acc, profile, degradation, & tabk, para_H2, node_depth, layer_depth,... rho_r, v_in_0, a_in_0, dt, d_t, duration ,& v_in_1, a_in_1, eps, ac1, ac2,...ByRef acc As Double, ByRef profile As Double, ByRef degradation As...For i = 1 To nlayer + 1 profile(i, 1) = CDbl(Worksheets...
Show full article (6.34Kb)
Re: SQL 2205, Profiler and Deadlocks     

Group: microsoft.public.sqlserver.tools · Group Profile · Search for Strange durations in Profiler in microsoft.public.sqlserver.tools
Author: Kalen Delaney
Date: Nov 25, 2006 18:37

...> the event should appear in the trace. That is, in theory it should, but in practice it doesn't. It's all quite strange, because if you filter for NTUserName or Duration instead, you do get the Deadlock Graph, and neither these two columns are populated by DeadlockGraph. And if filter for Database name ...
Show full article (1.45Kb)
Re: SQL 2205, Profiler and Deadlocks     

Group: microsoft.public.sqlserver.tools · Group Profile · Search for Strange durations in Profiler in microsoft.public.sqlserver.tools
Author: Erland Sommarskog
Date: Nov 25, 2006 09:19

... the event should appear in the trace. That is, in theory it should, but in practice it doesn't. It's all quite strange, because if you filter for NTUserName or Duration instead, you do get the Deadlock Graph, and neither these two columns are populated by DeadlockGraph. And if filter for Database name and add...
Show full article (1.22Kb) · Show article thread
Re: SQL Profile - Duration value more than Profiler run time     

Group: microsoft.public.sqlserver.tools · Group Profile · Search for Strange durations in Profiler in microsoft.public.sqlserver.tools
Author: Greg Linwood
Date: Aug 19, 2006 09:20

...the event RPC:Completed in SQL Profiler for a web-service call, ...Stored Procedure and the results were strange. The output came very quick, ...query was in milliseconds, whereas, SQL Profiler show around 8minutes(after converting data...Start and End time. SP:Completed Duration: 504536789 (microseconds from trace table) ...Service Pack 1) The duration value is really strange to look at. ...
Show full article (1.77Kb)
Re: SQL Profiler - Strange data in RPC:Completed     

Group: microsoft.public.sqlserver.tools · Group Profile · Search for Strange durations in Profiler in microsoft.public.sqlserver.tools
Author: kart
Date: Aug 17, 2006 08:31

...specified as 30 sec. Eventhough, the duration is very high value, the Start...access APIs such as DAO) The Duration column includes not only the execution..., we found a strange behaviour in SQL Profiler. We validated the same...RPC:Completed is captured using SQL Profiler and it is found that the...:14.440 , which says the duration is only in millis sec....
Show full article (2.54Kb) · Show article thread
1 · 2 · next