SQL Server Performance Forum – Threads Archive
RPC:Completed, but notEssentially 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:
â€¢ 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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.