Hi all, We are facing a strange issue on our DB from last one week. Every night from 12:01 AM onwards event table is not getting updated. The issue will last for few hours. At the same time period, I logged in and tried opening few pages, ran report as well as tested few monitors. All that are working fine. I checked, is there any scheduled job running at the time in DB or main server. No jobs are running during that time. DB archiving is scheduled at 2:15 AM. I checked the SQL queries which is running at that time and I can see many suspended session at that time. Any suggestion on what should I do, how can I troubleshoot further? I am fearing this might be affecting some other tables also.. Regards, Dilu
