Code to analyze the transaction hierarchy in the log |
Over the weekend there was a discussion on the MVP distribution list about the sys.dm_tran_database_transactions DMV and how one cannot use it to accurately determine how much log an operation has generated because it doesnt provide a roll-up of the sub-transaction metrics to the outer transaction. This makes the output somewhat non-intuitive. The discussion prompted me to [&]
The post Code to analyze the transaction hierarchy in the log appeared first on Paul S. Randal.
Комментировать | « Пред. запись — К дневнику — След. запись » | Страницы: [1] [Новые] |