Blocking sql statement?
- From: Thorsten Kleinhenz <Thorsten Kleinhenz@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 5 Jul 2005 05:13:02 -0700
Hello NG,
we use SQLServerCE 2.0 in our VB.NET-application and have sometimes problems
with how it seems blocking sql statements (statements that normally works a
100times a day...).
We have about 1000 rows in our database in ~10 tables. There are made a lot
of reads, some inserts, some updates. The data changes about every 3 hours -
it's deleted and new data is inserted - with this "update" we compact the
database (before new data is inserted).
Now the problem that occurs is that some clients (total count is ~30)
sometimes hang, meaning that in my application's logfile I can see the last
executed sql statement, but this method does not return or throws any
exception. It seems that the application waits for the resultset and doesn't
get it. Curiously, after exiting and restarting the application, which means
compacting the database, too, the error doesn't occur any longer - until next
time...
So my question is, does anybody knows/recognises this behaviour or can give
me some information about debugging a SQLServerCE? Is there a trace/logfile?
Kind regards,
Thorsten
.
- Follow-Ups:
- RE: Blocking sql statement?
- From: "Syed N. Yousuf [MS]"
- RE: Blocking sql statement?
- From: Thorsten Kleinhenz
- RE: Blocking sql statement?
- Prev by Date: error pulling data : err code: 80072EFF
- Next by Date: RE: Blocking sql statement?
- Previous by thread: error pulling data : err code: 80072EFF
- Next by thread: RE: Blocking sql statement?
- Index(es):
Relevant Pages
|
