Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: Mark Letheren
  Where is Mark Letheren?
 Barrie
 Canada
 Mark Letheren
 Tags
Subject: RE: OLE IDispatch SQL Timeout Errors
Thread ID: 310486 Message ID: 310832 # Views: 18 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Saturday, June 25, 2011 7:22:46 PM         
   


> >
> > Probably other procedure is working with particular table, and this table is blocked.
> >
> >
> > Best Wishes,
> >
> > Yuri Rubinov
>
> Hi Yuri,
>
> How would you trace this? I have run profiler on it but without any luck .. restarting the SQL servers last night improved performance a bit.
>
> Mark

If there are several procedures conflicting with each other, then I doubt that restarting SQL may help.

As of from my experience, then usually I control all the procedures that are using a particular SQL database and table. I force conflicting procedures to run separately from each other, or wait until other procedure finished (one may use procedures log or output files for this).


Best Wishes,

Yuri Rubinov

ENTIRE THREAD

OLE IDispatch SQL Timeout Errors Posted by Mark Letheren @ 6/21/2011 10:44:49 PM
RE: OLE IDispatch SQL Timeout Errors Posted by Yuri Rubinov @ 6/22/2011 6:15:10 PM
RE: OLE IDispatch SQL Timeout Errors Posted by Mark Letheren @ 6/23/2011 8:37:38 PM
RE: OLE IDispatch SQL Timeout Errors Posted by Yuri Rubinov @ 6/25/2011 7:22:46 PM