Good day I just like to find out, are there any SQL log files which can be referenced for locks which was created on the database
Scenario :
Every day @ 5:00AM we get a lock on the database, and it affects performance drastically, I logged on earlier this morning to check it shows the user who is excuting SP_EXECUTE.
Sometime before I could see who was creating the lock because each user had an invidual loggon which was easily used for monitoring.Now one of our developers decided to create 1 SQL logon and when the lock is created it shows just that username.
I executed SP_who2 it does not pick up the hostname from where the query is running.
--------------------
I would just like to see in the log file if their is any info of this sort if there are any logfiles for SQL. Do you guys have any information which can assist me please