SQL Server Performance

Sherlock

Discussion in 'Forum Announcements' started by satya, Jul 7, 2005.

  1. satya Moderator

  2. ghemant Moderator

    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
  3. Madhivanan Moderator

    Satya, Thanks for the update


    Madhivanan

    Failing to plan is Planning to fail
  4. jhinds New Member

    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.
  5. satya Moderator

    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.

Share This Page