Time for another fun survey, this time around factors causing the transaction log to grow.
Imagine you’re the DBA for a company and you come to work Monday morning and find that the transaction log on one of the most critical databases, which has a 24×7 workload, is growing repeatedly. You check the log_reuse_wait_desc field in sys.databases to get an idea what the problem is.
Without any other information, which of the following values for log_reuse_wait_desc would you be most concerned to see for this database? (And these are listed in the order they appear in Books Online…) Give it some serious thought – and look at the results of the previous survey I did about wait stats to help guide your thinking, as the most common value you’ve seen in your environment isn’t necessarily the most worrying one.
Edit: the survey is over – please see here for the results.
(Note – if you’re using Internet Explorer, you may not see a Vote button. Just hit Enter after selecting your choice.)
Once again it’s deliberate that there is no ‘it depends’ option, and no ‘Other’ option for you to type something, so please don’t leave comments complaining about that.
I’ll editorialize the results next week, along with what my pick would be and rationales for picking each of them.