August 29, 2016 at 10:41 am
I have trying to pinpoint a table update via fn_Dump_DBlog. I narrowed the update to a 5 minute window but cannot seem to associate any updates with a specific object. The updates I am seeing all have nulls for partitionid, PageId and SlotID. I am able to associate the transaction sid to a user but not much else. Any other fields I should be using?
August 30, 2016 at 3:34 am
August 30, 2016 at 11:15 pm
This was removed by the editor as SPAM
August 31, 2016 at 5:09 am
jamesforest (8/29/2016)
I have trying to pinpoint a table update via fn_Dump_DBlog. I narrowed the update to a 5 minute window but cannot seem to associate any updates with a specific object. The updates I am seeing all have nulls for partitionid, PageId and SlotID. I am able to associate the transaction sid to a user but not much else. Any other fields I should be using?
Quick suggestion, use an audit trigger on the table whilst analysing which ever issues you have, afterwards you can of course drop or disable the trigger. Much simpler and it's easy to capture any session/connection information this way. Transaction logs can be very busy and 5 minutes may not be frequent enough to capture the action you are after apart from being somewhat cryptic. Extended events are another option but the trigger is far simpler.
😎
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply