Hi,
What does a zero value in the Duration column of SQL
Profiler trace mean for SQL:BatchCompleted and
RPC:Completed events?
Thanks,
OskOsk wrote:
> Hi,
> What does a zero value in the Duration column of SQL
> Profiler trace mean for SQL:BatchCompleted and
> RPC:Completed events?
It means the duration was so fast SQL Server recorded it as 0. The
granularity of the timer is probably about 15 ms in most cases.
David Gugick
Imceda Software
www.imceda.com
Friday, March 30, 2012
Profiler -> Duration
Labels:
andrpccompleted,
column,
database,
duration,
microsoft,
mysql,
oracle,
profiler,
server,
sql,
sqlbatchcompleted,
sqlprofiler,
trace,
value,
zero
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment