Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can a backup of an online database affect transaction throughput?

April 26, 2017affect backup database online throughput transaction

0

10 Posted

How can a backup of an online database affect transaction throughput?

1 Answer

0

10 Posted

For one thing, if the read size is so big such that these I/Os are saturating the disks, then it’s possible that the transaction throughput will be affected if I/Os are needed from the same disks. Same goes for cpu utilization. Use “iostat” to check on disk activity.