none
How to find out that because of which query the transaction log got fulled?? RRS feed

  • Question

  • Gurus,

    My users are uploading some data into some of my databases....I have not turned on Profiler or any other Performance tracker....

    So if transaction log gets fulled and their process gets stopped, how can I find out which query caused it..

    .I do have got some scripts which gives currently running transactions.....But I am interested in finding out the text of that query after the transaction log gets fulled.....Because the query will not be running once the transaction log gets fulled....

    and my the scripts which I have only returns currently running queries...


    Harry
    Friday, October 7, 2011 7:02 PM

Answers

  • What ever data you enter in database will first goes and inserted into log file before even goes into data file - only way to keep transaction log size in control would be scheduling regular transactional log backups which will mark the de-active portion of log file to be reuse otherwise it will expand and fillup disk space
    http://uk.linkedin.com/in/ramjaddu
    • Marked as answer by Harry SQL DBA Monday, October 10, 2011 2:27 AM
    Friday, October 7, 2011 8:19 PM

All replies

  • Hey...never mind...I found the query before the transaction log got fulled...you can disregard this question....

    but thanks gurus for taking time in looking into this question...


    Harry
    Friday, October 7, 2011 8:18 PM
  • What ever data you enter in database will first goes and inserted into log file before even goes into data file - only way to keep transaction log size in control would be scheduling regular transactional log backups which will mark the de-active portion of log file to be reuse otherwise it will expand and fillup disk space
    http://uk.linkedin.com/in/ramjaddu
    • Marked as answer by Harry SQL DBA Monday, October 10, 2011 2:27 AM
    Friday, October 7, 2011 8:19 PM