November 4, 2002 at 9:45 am
I have a situation where SP:Completed does not have a corresponding duration.
This is what it looks like:
SP:Starting
SP:StmtStarting
SP:StmtCompleted - has a duration
SP:StmtStarting
SP:StmtCompleted - has a duration
SP:Completed - no duration.
I am using a SQL Server 2000 Profiler Tool profiling a 7.0 database.
Anyone see this before?
(It was a heavy stress test I was running.)
November 4, 2002 at 12:23 pm
Are you trying to execute the nested stored procedures.I am having an inclination that it is because of nested procedures.
November 4, 2002 at 12:24 pm
Are you trying to execute the nested stored procedures.I am having an inclination that it is because of nested procedures, though not sure.
November 4, 2002 at 2:08 pm
not a nested stored procedure.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply