INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SQL 2012 Profiler

SQL 2012 Profiler

(OP)
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?

RE: SQL 2012 Profiler

Admittedly, this is from SQL 2000, but it covers the basics. CPU is displayed in Milliseconds in SQL Profiler, but when you save it to a table, the value is converted to microseconds. Reads would be page reads, rather than row reads. You appear to have a query in need of tuning.

RE: SQL 2012 Profiler

(OP)
I've checked another random trace and in the trace file that I saved and view within profiler I have CPU 265 and Duration 275. In the SQL table that I saved it to the CPU is 265 and the Duration is 275793. The CPU doesn't change. I'm assuming that 275 in the trace is actually 0.275 (millisecond) and the table is 275793/1,000,000=0.275793 (microseconds). The CPU is 0.265 seconds?

The query was traced on purpose as it has to query a lot of data and was using that as a test trace to try and figure out what these values are. I still don't know.

RE: SQL 2012 Profiler

Maybe you did not read the article I linked.

Quote (Microsoft)

CPU 18 Amount of CPU time (in milliseconds) used by the event.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

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.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close