Hi team I am facing a problem with transaction log. The log file become full between 3:10 AM to 3:30 AM EST. Can we check which Queries are running. Is there any Query from which I can find which are the query has run at that time. we have problem that at that time no one can run the trace also. I have check in defaut trace that run by SQL Server and i dinnot find any query in text cloumn of profiler at that particular time. Thanks Basit Khan
There are many DMVs that can assist you in tracking it down but if this is a consistent issue the first places I would check are SQL Server Agent jobs and Windows Scheduled Tasks that run around the same window.