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/techinfo/productdoc/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