Thanks for your quick reply, Eddie. It happens everyday at the same time the VM backups kick off, so I'm 99% percent sure that's what is causing the backups. I...

CELKO (12/7/2012)

---

>> Here's the SQL to create the table and populate it with data. <<

Do you really want to do FLOAT? How will you handle the rounding errors and slowness...

Jeff Moden (12/6/2012)

---

Heh... suffering from a NEC (Not Enough Coffee)...

dwain.c & Jeff Moden, your solutions worked great! Thank you both so much!

Jeff - "Data smears" sounds good to me. Regarding the "clear requirements and readily consumable data" comment,...

Wow, Gail Shaw on the first response. I feel honored.

I think I must have worked too late last night. When I first wrote the trigger I fully expected...

Thanks for the quick reply. I was using the Profiler GUI on the server itself through a Remote Desktop session. I've never run it non-GUI, but if that...

Ninja's_RGR'us (3/30/2010)

---

errh what did you understand when I said that the server could possibly handly 8 queries at the SAME TIME giving you 8 seconds of processing power PER SECOND?...

Stefan_G (3/30/2010)

---

You probably have lots of overlapping queries. If your application generates 20 simultaneous queries that all start at 00:00:00 and then all finish at 00:00:02 the elapsed time would...

Ninja's_RGR'us (3/29/2010)

---

I'm not sure I understand your conclusion. If you assume you can trust the duration of 1 transaction, then you should also be able to trust the 67...

I've come to the realization that I won't be able to rely on the sum of the duration column for reporting the accumulated time it takes SQL Server to execute...

Thank you for your reply. This is driving me nuts, and I'm sure I'm not the only one out there who has run accross this issue.

Ninja's_RGR'us (3/27/2010)

---

are you using...

I'm not sure I understand. It sounds like you're saying that it's normal for the SQL Duration time to be less than the elapsed time, and I agree. ...

I was able to reproduce the issue. The total duration below is correct, but the sum of the Duration column is way off.

Total Duration in Minutes: 273 (4.5...

We ran a long test overnight, so I'll check it when I get in and report back. I didn't do the original Profile capture, so it might be a...

I have an odd situation in which the total duration for a period of time exceeds that of the given time period. For example, I run Profiler for 3-hours,...