1

Many database tasks (including Data File Auto Grow, Log File Auto Shrink, and Data File Auto Shrink) are completed only by the sa user, but Log File Auto Grow seems to be associated with both sa and my application user via .Net SqlClient Data Provider. Is there a reason for this?

1 Answer 1

1

Whichever transaction requires additional log space will grow the log file within that transaction, so it can complete.

So if userA is performing a bulk load of data and uses up all available space in the log file, you will see a growth event for the log being called by userA.

2
  • In that case, I suppose my question is, what would the sa user be doing that would cause the log file to expand? All my applications use my user login. Would this just be due to background tasks? :) Jan 8, 2016 at 17:57
  • It is a background process that is called.
    – user507
    Jan 8, 2016 at 18:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.