RadhaKrishnaKiJaya
asked on
How to Monitor database update
Hello Experts,
There are few tables in a database being updated randomly. As much as I know, there is no other process running and it cannot be done manually either. But, I think I am wrong. There must be some other process running to update those tables, which I don't know. Any idea, how can we monitor these tables? There is timestamp, but not sure who does it. The Signature field is always blank. If the user did the updates, the signature field would have been updated. Also, in the program there is check, so that user needs to follow the procedure to update it. Any idea how to Monitor or troubleshoot?
Thank you in advance!
There are few tables in a database being updated randomly. As much as I know, there is no other process running and it cannot be done manually either. But, I think I am wrong. There must be some other process running to update those tables, which I don't know. Any idea, how can we monitor these tables? There is timestamp, but not sure who does it. The Signature field is always blank. If the user did the updates, the signature field would have been updated. Also, in the program there is check, so that user needs to follow the procedure to update it. Any idea how to Monitor or troubleshoot?
Thank you in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Eric and Arnold,
I am thinking of using Profiler. Can we specifically target one table?
Thank you again!
I am thinking of using Profiler. Can we specifically target one table?
Thank you again!
Yes, prior to beginning a trace, you can spevify how much data and what database/tales you want captured.
ASKER
Guys, Thank you very much for your help. I am still working on it the Profile Trace. For some reason it is not creating log for the table Updates and Inserts. The Select statements are logged properly though. I will update you as soon as I know something.
>> it is not creating log for the table Updates and Inserts
You don't see them in the Profiler trace? They are not reaching the database then, something stops them before.
You don't see them in the Profiler trace? They are not reaching the database then, something stops them before.
ASKER
Hello,
I am able to trace the SP used for the update. Next trying who ran it. I can see the Host Name, DB, Server nams etc. But not able to see the User name and Work Station name to trace the User. Any idea? Thank you!
I am able to trace the SP used for the update. Next trying who ran it. I can see the Host Name, DB, Server nams etc. But not able to see the User name and Work Station name to trace the User. Any idea? Thank you!
Open the template and check if NTUserName and LoginName are selected
ASKER
I see NTUserName is NULL and LoginName is database login name.
strange, mine are filled!
ASKER
Thank you Eric. This worked as expected, except the Login Name. This helped me a lot. Thank you again!
I.e. An update/insert into one table impacts/affects other tables.