Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: Examing SQL Server Trace Files

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-05-15 : 19:02:48
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

1 Post

Posted - 2007-04-26 : 00:33:23
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
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-04-26 : 12:44:14
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
   

- Advertisement -