April 14, 2010 at 6:32 pm
Hi,
I've been logging the active processes history for some time and found that values for cpu_time, reads and writes sometimes go down for the same process. I thought they were cumulative and would always go up. I've got an example below. It is the same process for sure: the same session_id, login_time and connection_id.
Any ideas?
Thanks.
ReportDatecpu_timesession_idlogin_timeconnection_id
15/04/2010 10:1115755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
15/04/2010 8:3015755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
15/04/2010 8:120755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
15/04/2010 7:3116755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
15/04/2010 6:3316755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
15/04/2010 5:5415755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
15/04/2010 5:3416755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
15/04/2010 4:5416755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
15/04/2010 4:340755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
15/04/2010 2:510755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
15/04/2010 2:3416755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
15/04/2010 1:3515755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
14/04/2010 21:5016755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
14/04/2010 21:3316755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
14/04/2010 17:260755/04/2010 15:423A8FF44D-3ADE-4BB4-BE28-FA24D98E29AD
April 15, 2010 at 4:53 pm
Notice that the time stamp is different for each request. Each of these requests is a new request from the same connection. The CPU would be specific to that particular request and not cumulative.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply