How to find longest running transaction in Sybase

This tip allows you to access the table that tracks server transactions.

Everything in Sybase is maintained in tables. There is a table called syslogshold that will keep track of server

transactions. It's very simple to access this information with version 11.0 onward:

SELECT * FROM master..syslogshold

For More Information


This was first published in May 2001

Dig deeper on Oracle and SQL

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close