July 23, 2008 at 2:43 pm
Hi,
I am running SS2K5 Profiler for analysis of my queries. What does the value in CPU, Read, Write means? Is this bytes?or wat?
THanks,
usman
July 24, 2008 at 12:58 am
CPU is time spent on the CPU in miliseconds
Reads and Writes are the number of pages (8k) read or written by the query
Duration is the total time taken for the query. In microseconds but may be displayed in milliseconds depending on a setting in the profiler options.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 26, 2008 at 11:53 pm
CPU time will show the amount of time (in milliseconds) taken to execute your query.
Read will indicates the number of reads done to execute this query.
Writes will show, how many write done by this query (if you have any temp table... it will write in the temp table right)
Thanks and Regards,
Venkatesan Prabu, 😛
My Blog:
http://venkattechnicalblog.blogspot.com/
July 27, 2008 at 12:00 pm
Venkatesan Prabu (7/26/2008)
CPU time will show the amount of time (in milliseconds) taken to execute your query.
It shows the amount of CPU time spent while running the query. It's not the same as execution time (the total time that the query took to run). If the query had to wait for resources, the execution time may be higher than the CPU time. If the query ran in parallel, the execution time may be less than the CPU time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply