Problem with Automatic Block Detection (SSI Version)

MartinFK
MartinFK Member Posts: 43
edited 2008-10-27 in SQL Performance
Hi,

I have a problem with the Automatic Block Detection tool, maybe someone encountered the same problems.
(http://dynamicsuser.net/blogs/stryk/default.aspx)

It is running fine for a while but all of the sudden it is not writing anymore the tables and idexed into the log-table.
There were no changes on the server during that time.
2521	23.10.2008 08:17	OBJECT: 5:1959599411:0 	GSS$Sales Line	
2526	23.10.2008 08:46	OBJECT: 5:1959599411:0 	GSS$Sales Line	
2527	23.10.2008 08:47	OBJECT: 5:1959599411:0

Any ideas?
Thanks for your help,
Martin

Comments

  • stryk
    stryk Member Posts: 645
    Hi Martin!

    Yes, there is an issue with this process: Once the "translation" of the waitresource into table name etc. fails - for whatever reason - the whole thing could get stuck ... :bug:

    As some sort of firts aid you could run this TSQL: 
    update ssi_BlockLog set [table_name] = 'unkown' where [table_name] = null
    Afterwards the parsing should work again ...

    Actually the code I published in my BLOG is pretty old - but compatible with SQL 2000. I will publish an improved version (SQL Server 2005 only) shortly, providing more features and "stability".

    Sorry about the inconvenience :-k

    Best regards,
    Jörg
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • MartinFK
    MartinFK Member Posts: 43
    Hello Jörg,

    thanks for the reply. Looking forward to the renewed routines, meanwhile I am calling the update-code after an insert to make sure the stored procedure is behaving fine. Seems to work.

    kind regards,
    Martin

Categories