January 25, 2012 1 Comment
Answer Q no 1
Enable backup compression, Create a user that is classified into a limited CPU workload group in Resource Governor.
Enable backup compression –> To reduce the disk space used for backup operations.
Create a user that is classified into a limited CPU workload group in Resource Governor –> minimize the impact to your production systems’ performance when performing backups
By default, backing up using compression significantly increases CPU usage, and the additional CPU consumed by the compression process can adversely impact concurrent operations.
Therefore, you might want to create a low-priority compressed backup in a session whose CPU usage is limited by Resource Governor when CPU contention occurs.