June 30, 2017 at 10:43 am
Client has scheduled log backup of a database every hour using SQL server agent.
Does it degrade performance of DML operations on database?
June 30, 2017 at 11:12 am
krishna83 - Friday, June 30, 2017 10:43 AMClient has scheduled log backup of a database every hour using SQL server agent.Does it degrade performance of DML operations on database?
No...any effects, if there were some, would be negligible for the most part. And every hour is fairly common. I've seen a lot with every 5 minutes as well.
Log backups should be based on recovery requirements. I wouldn't worry about it, they aren't doing anything unusual or harmful with hourly log backups.
Sue
July 3, 2017 at 8:57 am
Can't tell based on your post. The workload will determine if this is an issue. There will be IO to read the log and write the backup file, however, this should be on separate devices.
In the grand scheme of things, who cares? That's the price of protecting data. The log backup frequency is driven by RPO, not by performance. If you have performance issues, address those in a different way.
July 3, 2017 at 3:36 pm
I have log backups running every 30 minutes and haven't seen any heavy hits on performance.
Then again:
Steve Jones - SSC Editor - Monday, July 3, 2017 8:57 AMIn the grand scheme of things, who cares? That's the price of protecting data. The log backup frequency is driven by RPO, not by performance. If you have performance issues, address those in a different way.
Steve knocked it out of the park with this one. The first duty of a DBA is to protect the data. The log backups are a part of that and need to be done. I don't think I'd entertain a conversation where the log backups were being blamed for poor performance. Find the performance issues and fix them, but don't sacrifice the safety of the data to get there.
Put another way, if your database performed spectacularly but you couldn't get it back in the event of corruption, does stellar performance really matter?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply