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