Re: Script to find 'active' IDS 7.2x threads

The Wilcoxons wrote in message <71od2q$u9m$1@nw003t.infi.net>... >Yes, an application pulling from sysmaster could produce a better, cleaner >output. This intended as a simple tool to provide a lot of information at a >glance (the user, locks, reads, writes, ...). It doesn't even have to be an application. One join query (run from a script) against sysmaster would do the trick. Or, even better, a stored procedure. I already have a stored procedure which tells me which users/sessions are locking which tables, in what mode. This has been invaluable. And there's no easy way to get that directly out of onstats. It would take maybe fifteen minutes to write a stored procedure that gives you the same (or better) information at the same glance, in a better format.