SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Examing SQL Server Trace Files
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 05/15/2006 :  19:02:48  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
sqlec writes "I am attempting to analyze a stored procedure that I have written and have a question regarding profiler, What exactly are reads? and what is the correlation between cpu, reads and duration? is that correlation direct?" It's been a while since I answered any of the posted questions. This looked like a great one to start with.

Article Link.

saketmittal
Starting Member

India
1 Posts

Posted - 04/26/2007 :  00:33:23  Show Profile  Click to see saketmittal's MSN Messenger address  Send saketmittal a Yahoo! Message  Reply with Quote
The data read from the disk i.e. number of logical disk reads performed by the server on behalf of the event.
CPU is Amount of time (in milliseconds) spend by CPU for that event.
Reads are number of logical disk reads performed by the server on behalf of the event.
Duration is the total time taken to execute any particular command.
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 04/26/2007 :  12:44:14  Show Profile  Reply with Quote
quote:
Originally posted by saketmittal

The data read from the disk i.e. number of logical disk reads performed by the server on behalf of the event.
CPU is Amount of time (in milliseconds) spend by CPU for that event.
Reads are number of logical disk reads performed by the server on behalf of the event.
Duration is the total time taken to execute any particular command.





why are you restating what was written in the linked article?



-ec
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000