Is there a way to restrict backups or sql agent jobs with low priority

Question

Post reply

Is there a way to restrict backups or sql agent jobs with low priority

ALIF-662928

SSCertifiable

Points: 6054
More actions
March 31, 2016 at 5:11 pm

#317457

I want to restrict the backups to run in low priority, use low disk reads and writes so the filer is happy and can I use resource governor to restrict only backups and sql agent jobs? Iops restriction is not helping in governor.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 1

Not sure if you've seen the following...

https://msdn.microsoft.com/en-us/library/cc280384(v=sql.120).aspx

https://www.mssqltips.com/sqlservertip/3370/use-sql-server-2014-resource-governor-to-throttle-processes-for-io-usage/

Disclaimer... I'm still stuck in 2005 and haven't actually tried either of these methods, yet.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ALIF-662928 SSCertifiable Points: 6054 More actions · Answer 2

I have tried using resource governor, but whenever the job runs it show the sql server service account in the activity monitor, where as i have another login which i created for backup purpose, this new login i created is not shown in the activity monitor when the backup job is running, so i do not want restrict the service account,