sys.dm_os_memory_cache_clock_hands.last_round_start_time clarification

Question

Hello,

Could you please confirm that the measurement unit for last_round_start_time in sys.dm_os_memory_cache_clock_hands differs from 2005 and 2008?

2005:
Total time, in CPU ticks, taken by the clock to complete the previous round. Is not nullable. (http://msdn.microsoft.com/en-us/library/ms173786(SQL.90).aspx)

2008:
Total time, in milliseconds, taken by the clock to complete the previous round. Is not nullable. (http://msdn.microsoft.com/en-us/library/ms173786.aspx)

Thanks,
Rob

Answer 1

The CPU ticks is the number of CPU cycles since the previous round, a CPU tick maybe stand for few minutes, in SQL 2008, replaced by milliseconds, I think it is more exactitude.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 2

OK, thanks for the confirmation ChunSong - I agree the change in 2008 is an improvement.

Cheers,
Rob