I have been looking up help (useless in SQL 2012) and googling for days yet cannot find one good article to explain how to interpret sql profile traces. It took a while to find out that on SQL 2012 the duration is milli and not micro seconds. Say I have a query that shows 12353 as the duration, 2714 as CPU, 353071 as reads and 9 as writes. I know this means the query took just over 12 seconds, but what is the 2714 imply? Does the 353071 imply it looked up this many records or is this also a duration? Why is there not a simple help page that describes what each column is and how to interpret it?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.