• A very helpful article but with (at least for me) a number of issues

    a) Collecting data with process monitor

    - Another filter should be set for the Detail column with the condition "begins with" and the value "offset". Else filling the Offset and Length fields might fail

    - Sequence column seems not to be switched on in current Process monitor versions -> it should be switched on

    b) Importing data

    - Like other people in this forum mentioned the CSV output of Process monitor seems to not work for the Sequence number (it shows always "n/a") therefor CSV should first be processed with a CSV compliant tool (e.G. use CSVed to remove the first column and to add a first column with a row number)

    - Importing with leaving the general options in SQL 2008 on the default values failed for me, The Path and Detail column should be set to a higher value (e.G. 4000 in the output column width)

    - The detail column should after the import once be re-filled with removing the double quotes

    e.g.

    Update Iops

    SET DETAIL = REPLACE(DETAIL,'"','')

    GO

    Thanks for the article

    Best regards

    Thorsten