Backup Proformance

What is the best way to estimate the strain a backup will place on a server currenly being used?
Is there a way to limit the amout of resources given to the backup process?
Basically, i'm trying to figure out if I can run a backup up in the middle of a high usage time, even thou I relize it would be better to backup up off hours.
The best way is to try it and see. You can always kill the backup if you
need to. Backups usually don't use much CPU but will hit the disks (Both
Logs and Data Drives) pretty hard.
Andrew J. Kelly SQL MVP
"mannie" <anonymous@.discussions.microsoft.com> wrote in message
news:99231A3C-9711-4398-A530-568906D1DEAD@.microsoft.com...
> What is the best way to estimate the strain a backup will place on a
server currenly being used?
> Is there a way to limit the amout of resources given to the backup
process?
> Basically, i'm trying to figure out if I can run a backup up in the middle
of a high usage time, even thou I relize it would be better to backup up off
hours.
|||Hi,
What is the best way to estimate the strain a backup will place on a server currenly being used?
use the performance monitor counters:-
1. SQL Server Backup Device Object: Device Throughput Bytes/sec
2. Physical Disk: % Disk Time
3. Physical Disk Object: Avg. Disk Queue Length
Normally backup process will utilize a bit of more I/O ,, since it is writing into the disk.
If you have multiple disk controllers in your server you can create multiple backup devices spanned
across. And while backing up you can give both the backup devices, this will speed up the backup
process as well as reduces the resource usage.
Sample
sp_addumpdevice 'disk','backup1','D:\backup\backup1.bak'
go
sp_addumpdevice 'disk','backup2','F:\backup\backup2.bak'
go
Backup database dbname to backup1,backup2
Have a look into the SQL LITESPEED backup tool. This tool will speedup the backup and reduces I/O.
http://www.imceda.com/
Thanks
Hari
MCDBA
-- mannie wrote: --
What is the best way to estimate the strain a backup will place on a server currenly being used?
Is there a way to limit the amout of resources given to the backup process?
Basically, i'm trying to figure out if I can run a backup up in the middle of a high usage time, even thou I relize it would be better to backup up off hours.