SQL Server Performance Forum – Threads Archive
RPC:Completed, but not
Essentially I have a stored procedure that runs fine once a minute for any number of hours, then fails. The log shows one start and 2 finishes. <br /><br />I am using VB6 and the Data Environment to run a stored prodecure on SQL 2k.<br />A trace shows the RPC<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />tarting and the 2 lines of the stored procedure being run.<br />.017 ms later, the RPC:Completed Event is logged. <br />However, the application times out and the log shows another identical RPC:Completed Event except that the StartTime and EndTime are both the same and 100 seconds later than the RPC<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />tarting. There is no RPC<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />tarting for this second RPC:Completed event.<br />Any thoughts?<br />Many thanks in advance!Possible causes include:
• Blocking.
• System resource contention.
• Application design problems.
• A particular set of queries or stored procedures with long execution times. Use Performance Monitor to capture Windows NT and SQL Server counters and also PROFILER for SP:RECOMPILE event. To see if blocking is occurring, run the sp_who system stored procedure:
exec sp_who Check this KBAhttp://support.microsoft.com/kb/224453/EN-US/ to resolve the blocking andhttp://support.microsoft.com/kb/243589/EN-US/ to troubleshoot slow running queries. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>