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

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.

  • 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? :) – blackorchid Jan 8 '16 at 17:57
  • It is a background process that is called. – Shawn Melton Jan 8 '16 at 18:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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