June 24, 2009 at 2:09 pm
I am not sure why the sequence column would say n/a.
If you go to the "Options" menu the "Select Columns" it might be setup differently, just add the columns you need and untick the ones you don't.
Also there is an additional column "Duration" which I didn't add because I think that using procmon will add some overhead so the results are not 100% accurate, but it is potentially a useful metric to compare servers / response times.
Ed
June 30, 2009 at 3:16 pm
Just added her to the brief case. Will have to get back to this when we leave logical and I have some damn transactional data to play with...!
September 6, 2010 at 11:47 am
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
January 13, 2014 at 9:50 am
I had the BIGINT issue as well - a few years has past 😉
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply