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.
asked May 24 '12 at 01:09 PM in Default
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.
answered May 24 '12 at 01:23 PM