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.
| 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. |
 |
|
|
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 |
|
|
|
|
|
|
Article: Examing SQL Server Trace Files