question

Henrik Staun Poulsen avatar image
Henrik Staun Poulsen asked

NESTING_TRANSACTION_FULL latches

We just upgraded one of our server to a 32 core, 256 GB RAM Itanium based server (HP rx8640), and now we are seeing a LOT of LATCH_EX waits.
Breaking down the latch stats (from sys.dm_os_latch_stats) we can see that we are waiting heavily on NESTING_TRANSACTION_FULL latches.

This class accounts for approx. 89% of the total latch waits!

We cannot, however, find any documentation on this - apart from the fact that it is "internal use only".
Can you help?

wait-type
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered

Are you experiencing performance issues that led you to this, or is this merely an observation?

Is the percentage of waits from this type staying high - i.e. are they continuing?

Have you the opportunity to restart or clear (DBCC SQLPERF(sys.dm_os_wait_stats', clear)) the wait stats and see if the same level appears again over time?

If this continues to be an issue, the fact that is an 'internal use only' latch, would probably prompt me to open a conversation with Microsoft Support.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.