November 10, 2016 at 9:59 am
Hello All,
I am trying to find the difference of each buffer latch type -Type1,Type2,Type3, Type4. I did lot online research but didn't find any document. I believe some experts are here to advice on this, if you have some idea about these differences, kindly share it. Thank you.
Ex:
A time-out occurred while waiting for buffer latch -- type 2, bp 000000059573F9C0, page 1:36497069, stat 0x40d, database id: 11, allocation unit Id: 72057594049724416, task 0x00000005713690C8 : 5, waittime 300 seconds, flags 0x1a, owning task 0x00000005713690C8. Not continuing to wait.
Regards,
San.
November 11, 2016 at 6:41 am
nervermind. I was able to figure it out using below query.
select * from sys.dm_xe_map_values where name='latch_mode'
order by map_key asc
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply