There's a new PSS supplied blocking/locking analysis tool been released called "Sherlock". Checkout -http://www.sql-server-performance.com/absolutenm/templates/?a=210&z=1 link. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thank you Satya for Update.<br /><br /><br />[<img src='/community/emoticons/emotion-1.gif' alt='' />]<br />Regards.<br /><br /><br />hsGoswami<br />ghemant@gmail.com
I downloaded and tried this tool and I am having some problems - I am wondering if anyone else has experienced this issue and knows how to correct... First of all, it has only happened when the output from sp_blocker_pss80 contained blocks. When there are no blocks found, the tool does not get the following fatal error. "Fatal error An exception was raised, please see Internals.dat file! Exception = Input string was not in a correct format." And inside the Internals.dat..... "Input string was not in a correct format. at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at m.a(TreeView A_0) at o.a(String A_0, i A_1, TreeView A_2)" I am running Windows 2000 Professional sp4 and I have tried this with both .Net 1.1 and also 2.0 beta. I also tried on an XP Professional computer with .Net 1.1. Any suggestions would be appreciated - this tool has the potential to be very handy if I can get it to work. Thanks.
I believe the problem related to the conversion of datatype, for instance it is trying to change a character to an Integer. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
