Re: performance degradation during backup
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 12/09/04
- Next message: Andrew J. Kelly: "Re: Sproc using nolock for table showing shared lock in sp_lock output"
- Previous message: Mark Walsh: "Re: New User causes 'Cannot resolve collation conflict error'"
- In reply to: anonymous_at_discussions.microsoft.com: "RE: performance degradation during backup"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 8 Dec 2004 23:12:12 -0500
Not only is that a poor choice for performance since you will most likely
max out the bandwidth but you are risking your database as well. If the
disk array died you would loose the database and your most recent backups.
-- Andrew J. Kelly SQL MVP <anonymous@discussions.microsoft.com> wrote in message news:247101c4dd6c$60b0ea30$a301280a@phx.gbl... > Raid-10. Same LUN/set of disks. >>-----Original Message----- >>Hi >> >>What you are seeing is a Disk performance issue. Whaqt > is your disk >>configuration? >>Is your SAN setup with RAID-5 and the Data and dumps are > on the same LUN/set >>of disks? Reading and writing to and from the same LUN > will really hamper >>performance. What does performance monitor say about > Disk Queue Length? >> >>We dump at 2.5Tb per hour on our Clustered SQL Servers > with SANs. >> >>Regards >>Mike >> >>"L Gonzales" wrote: >> >>> Whenever I run database backup during normal operating >>> hours I see a performance degradation and somtimes >>> blocking. We are running on active/passive config on > MS >>> Cluster. The database size is 40GB and the backup > takes >>> about an hour to complete. I have it set to run at >>> midnight but there are cases where I need to run the >>> backup during normal hrs. I have no experience in MS >>> Cluster and my gut feeling is that the I/O rate max > data >>> thruput is getting maxed out when I run the backup > during >>> normal operating hrs. I can not let the backup run > and >>> run the perfmon to figure out what is going on > because >>> the end users are annoyed and calling my COO ... >>> >>> >>> >>. >>
- Next message: Andrew J. Kelly: "Re: Sproc using nolock for table showing shared lock in sp_lock output"
- Previous message: Mark Walsh: "Re: New User causes 'Cannot resolve collation conflict error'"
- In reply to: anonymous_at_discussions.microsoft.com: "RE: performance degradation during backup"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
