Capture Sql Server back end Jobs/processes details
We are using SQL Monitor tool for all of our SQL Server instances. Now for one of our application there is an issue where by they are experiencing "Time out error" for specific time (2:20 AM to be exact) period every once a week.
I have shared the Top 10 Queries that got executed in that period, however they want more details.
They want us to capture the exact activities/processes details (apart from queries execution) that were running on the database for that specific period of time where they are experiencing this time out issue.
For e.g. When the issue is occurring is there any SQL jobs were running or is there any replication happening that is pushing the data to tables in that particular period of time.
Just want to know the root cause of this time out error. Because for other interval there is no time out issue
Please let me know how to capture all the details through SQL Monitor.