Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Transaction verbose
Mon, Mar 23 2009 8:30 AMPermanent Link

"Eduardo [HPro]"
Tim

I have been playing with a lock situation in my application but I can´t
realize what is going on.

The problem is something like that:
Five tables called A, B, C, D, E
The time to lock these tables is almost zero. But sometimes other processes
are using some of these tables but I don´t know what processes are. My
question is:

In a situation like that is there any way to know what table is "waiting" to
lock ? IOW, table A is locked, table B is locked but table C is waiting
(other process is using it in another transaction). I want to know "Table C
is waiting".

I don´t know if I was clear but I have tried.

Eduardo

Mon, Mar 23 2009 12:00 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Eduardo,

When you say you are trying to lock 5 tables, do you mean you are starting a
restricted transaction involving those 5 tables or you are trying to lock each
one of the tables using the LockTable method?

--
Fernando Dias
[Team Elevate]
Mon, Mar 23 2009 2:49 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Eduardo,

<< The problem is something like that:
Five tables called A, B, C, D, E
The time to lock these tables is almost zero. But sometimes other processes
are using some of these tables but I don´t know what processes are. My
question is:

In a situation like that is there any way to know what table is "waiting"
to lock ? IOW, table A is locked, table B is locked but table C is waiting
(other process is using it in another transaction). I want to know "Table C
is waiting". >>

Unfortunately, no.  However, you can use something like Process Monitor from
SysInternals to do so:

http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Mar 24 2009 7:24 AMPermanent Link

"Eduardo [HPro]"
Fernando

> When you say you are trying to lock 5 tables, do you mean you are starting
> a restricted transaction involving those 5 tables or you are trying to
> lock each one of the tables using the LockTable method?
The first one. I am starting a restricted transaction involving the tables.
Sorry for not mention it.

Eduardo

Wed, Mar 25 2009 1:21 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Eduardo,

> Sorry for not mention it.
No need to appologise - it was just me being sluguish, as usual Smiley
Anyway, it doesn't matter because Tim managed to gave you the answer before
I managed to understand the question Smiley
Cumprimentos.

--
Fernando Dias
[Team Elevate]

Image