aba_lockinfo - new version available

If you are using my lock-monitoring procedure aba_lockinfo, there is now a
new version available at http://www.sommarskog.se/sqlutil/aba_lockinfo.html.
I recommend that you replace your existing version with this one.
Functionally, there are only minor difference, but the older version did
not have acceptable performance when there were a large number of locks.
This version is designed to be more lean on resources.
If you are using text mode from Query Analyzer, there is a new parameter
@.fancy that may be of interest to you. The default is zero, but if you
set it to 1, aba_lockinfo dynamically sets the column widths, and you also
get a blank line between processes. (This requires some extra steps, which
it is not the default.) In grid mode, @.fancy does not matter much.
The change applies to the versions for SQL7, SQL 2000 and SQL 2000 SP3. The
one for SQL 6.5 is untouched.
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns949A1D178D27Yazorman@.127.0.0.1...
> If you are using my lock-monitoring procedure aba_lockinfo, there is now a
> new version available at
http://www.sommarskog.se/sqlutil/aba_lockinfo.html.
> I recommend that you replace your existing version with this one.
...[trim]...
Excellent tool Erland!
Thanks for sharing it.
Pete Brown
Falls Creek
Oz
www.mountainman.com.au