|
Home > Archive > ASE Database forum > March 2006 > Monitoring open transactions in ASE
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Monitoring open transactions in ASE
|
|
| Dusan Vujosevic 2006-03-23, 8:40 pm |
| Hi,
Is starttime column in master..syslogshold the time that a transaction
started? I see rows appear in the table that weren't there five minutes ago
with the starttime an hour in the past. Why weren't those rows in there five
minutes ago if the transaction is an hour old and there weren't any other
rows for that database? I think I'm misunderstanding the meaning of the
table. Can anybody fill me in please?
Thanks.
| |
| Sherlock, Kevin 2006-03-24, 8:27 pm |
| One possibility is that a transaction starts (begin tran), but then there is no
modification activity that "holds" the log until minutes/hours/days later. IE:
begin tran /* begin time of transaction marked */
go
select ...
select ...
exec ...
select ...
exec ...
select ... /* above statements take two hours to run */
update ... /* now you might see a row in syslogshold, but the tran began hours
ago */
....
"Dusan Vujosevic" <dvujosev@ppt.gc.ca> wrote in message
news:442326f4@forums
-1-dub...
> Hi,
>
> Is starttime column in master..syslogshold the time that a transaction
> started? I see rows appear in the table that weren't there five minutes ago
> with the starttime an hour in the past. Why weren't those rows in there five
> minutes ago if the transaction is an hour old and there weren't any other
> rows for that database? I think I'm misunderstanding the meaning of the
> table. Can anybody fill me in please?
>
> Thanks.
>
>
>
| |
|
| You probably already know but just in case; the table master.systransactions
(http://infocenter.sybase.com/help/i...e.help.ase_12.5
..1.tables/html/tables/tables64.htm) will give you the date/time a
transaction started.
This may help with an understanding of what's happening.
Cheers
BK
"Sherlock, Kevin" <ksherlock@saionline.com> wrote in message
news:44244d50$1@foru
ms-2-dub...
> One possibility is that a transaction starts (begin tran), but then there
is no
> modification activity that "holds" the log until minutes/hours/days later.
IE:
>
> begin tran /* begin time of transaction marked */
> go
> select ...
> select ...
> exec ...
> select ...
> exec ...
> select ... /* above statements take two hours to run */
> update ... /* now you might see a row in syslogshold, but the tran began
hours
> ago */
> ...
>
>
>
> "Dusan Vujosevic" <dvujosev@ppt.gc.ca> wrote in message
> news:442326f4@forums
-1-dub...
ago[color=darkred]
five[color=darkred]
other[color=darkred]
>
>
| |
| Dusan Vujosevic 2006-03-27, 1:37 pm |
| Thanks.
"Sherlock, Kevin" <ksherlock@saionline.com> wrote in message
news:44244d50$1@foru
ms-2-dub...
> One possibility is that a transaction starts (begin tran), but then there
is no
> modification activity that "holds" the log until minutes/hours/days later.
IE:
>
> begin tran /* begin time of transaction marked */
> go
> select ...
> select ...
> exec ...
> select ...
> exec ...
> select ... /* above statements take two hours to run */
> update ... /* now you might see a row in syslogshold, but the tran began
hours
> ago */
> ...
>
>
>
> "Dusan Vujosevic" <dvujosev@ppt.gc.ca> wrote in message
> news:442326f4@forums
-1-dub...
ago[color=darkred]
five[color=darkred]
other[color=darkred]
>
>
|
|
|
|
|