December 10, 2019 at 9:28 am
Hello everybody.
Does SQL Server Backup Operation use Parallelism ?
Until yesterday I was sure that the answer to this question was no.
Yesterday on the SQL Server instance of a customer i found a maintenance plan created to make sql server backup. The first stage of this maintenance plan set the Max Degree Of Parallelism to 8. Normally this is 1 on the same server.
After the backup operations, Max Degree Of Parallelism is reset to the value of 1.
I found the following Wiki, but it could be outdated.
What is the thrut?
=========================================================
I'm always happy to hear your opinion!
Senior Oracle DBA
Sql Server "learner" and... enthusiast!
December 11, 2019 at 10:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 11, 2019 at 10:20 am
Well, if somebody has set up a server with (at least) eight processors and maxdop 1, I would suspect that they might not know what they're doing.
If the backup is striped, either manually or through being made by a third-party utility, parallelism could come into play. Or, as you suggest, something may have changed since that blog was written.
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply