Backup 19 gig 2 hours

Hi all.
I have a Windows Server Enterprise 2003 with SQL Server SP1 installed on it.
I take every night a full backup of my CRM database. This CRM database grow
every day and I'm now at 19 gig of size.
I backup this database on an another server (Backup to disk), a Windows
Server 2003 standard with 1 CPU (3.4gig) and 1 gig of ram. This server do
absolutely nothing during the time of the backup. The server is idle.
Both servers are connected with 2 NIC at 1 gig each, so .... both are
connected at 2 gig on the network.
Is it normal that the backup of a 19 gig database take 2 hours ?
Thanks.
Jonathan
I suspect that the disk subsystem of the target server is slow. Is it RAID?
If so, what level - 0, 2, 5 or 10? How many disks are in the RAID array for
the volume you are using? If you use PerfMon, what is the write queue
length?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Jonathan" <Jonathan@.discussions.microsoft.com> wrote in message
news:6803F80E-1369-4351-A3DD-7646B93F8ACA@.microsoft.com...
Hi all.
I have a Windows Server Enterprise 2003 with SQL Server SP1 installed on it.
I take every night a full backup of my CRM database. This CRM database grow
every day and I'm now at 19 gig of size.
I backup this database on an another server (Backup to disk), a Windows
Server 2003 standard with 1 CPU (3.4gig) and 1 gig of ram. This server do
absolutely nothing during the time of the backup. The server is idle.
Both servers are connected with 2 NIC at 1 gig each, so .... both are
connected at 2 gig on the network.
Is it normal that the backup of a 19 gig database take 2 hours ?
Thanks.
Jonathan
|||Is your network configured properly? Is there other network traffic during
backup? How long does it take to backup to local disk? How long does it
take to copy a 19GB backup file on the backup server to the same drive? One
of these will likely tell you where the root cause is.
TheSQLGuru
President
Indicium Resources, Inc.
"Jonathan" <Jonathan@.discussions.microsoft.com> wrote in message
news:6803F80E-1369-4351-A3DD-7646B93F8ACA@.microsoft.com...
> Hi all.
> I have a Windows Server Enterprise 2003 with SQL Server SP1 installed on
> it.
> I take every night a full backup of my CRM database. This CRM database
> grow
> every day and I'm now at 19 gig of size.
> I backup this database on an another server (Backup to disk), a Windows
> Server 2003 standard with 1 CPU (3.4gig) and 1 gig of ram. This server do
> absolutely nothing during the time of the backup. The server is idle.
> Both servers are connected with 2 NIC at 1 gig each, so .... both are
> connected at 2 gig on the network.
> Is it normal that the backup of a 19 gig database take 2 hours ?
> Thanks.
> Jonathan
|||Hello,
The recommended method is do the backup locally and copy the backup file to
other server. You can do this using a BAT file and schedule it using SQL
Server Agent
Thanks
Hari
"Jonathan" <Jonathan@.discussions.microsoft.com> wrote in message
news:6803F80E-1369-4351-A3DD-7646B93F8ACA@.microsoft.com...
> Hi all.
> I have a Windows Server Enterprise 2003 with SQL Server SP1 installed on
> it.
> I take every night a full backup of my CRM database. This CRM database
> grow
> every day and I'm now at 19 gig of size.
> I backup this database on an another server (Backup to disk), a Windows
> Server 2003 standard with 1 CPU (3.4gig) and 1 gig of ram. This server do
> absolutely nothing during the time of the backup. The server is idle.
> Both servers are connected with 2 NIC at 1 gig each, so .... both are
> connected at 2 gig on the network.
> Is it normal that the backup of a 19 gig database take 2 hours ?
> Thanks.
> Jonathan
|||Thanks all for your answer.
For the target server, it's a RAID 5 with two partition and the one where I
backup my database has 453gig of free space. I have 6 disk at 10k rpm.
I have no other network communication during my SQL backup except 10 to 20
computer that can contact the target server randomly to verify if a new virus
definition is availaible.
I do not test to backup locally on the server to verify how much time it can
take to backup locally. I will try to test this.
Thanks.
Jonathan
"Hari Prasad" wrote:

> Hello,
> The recommended method is do the backup locally and copy the backup file to
> other server. You can do this using a BAT file and schedule it using SQL
> Server Agent
> Thanks
> Hari
> "Jonathan" <Jonathan@.discussions.microsoft.com> wrote in message
> news:6803F80E-1369-4351-A3DD-7646B93F8ACA@.microsoft.com...
>
>
|||RAID5 is slow for writes, so that may be your problem. Also, 6 spindles are
not a lot, so you may have a disk bottleneck.
Run PerfMon and check the disk write queue length. If it is greater than 2
X the number of spindles - i.e. 12, in your case - then you have a disk
bottleneck. With 6 disks in RAID5, you have the effective storage of 5
disks. If you reconfigure as RAID10, that will drop to 3. If you can
handle the decreased capacity, then you should get better performance out of
a RAID10 set. That said, I would buy more disks. Spindles are your friend.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Jonathan" <Jonathan@.discussions.microsoft.com> wrote in message
news:C53A87AA-17B6-4157-81A5-7117353274D1@.microsoft.com...
Thanks all for your answer.
For the target server, it's a RAID 5 with two partition and the one where I
backup my database has 453gig of free space. I have 6 disk at 10k rpm.
I have no other network communication during my SQL backup except 10 to 20
computer that can contact the target server randomly to verify if a new
virus
definition is availaible.
I do not test to backup locally on the server to verify how much time it can
take to backup locally. I will try to test this.
Thanks.
Jonathan
"Hari Prasad" wrote:

> Hello,
> The recommended method is do the backup locally and copy the backup file
> to
> other server. You can do this using a BAT file and schedule it using SQL
> Server Agent
> Thanks
> Hari
> "Jonathan" <Jonathan@.discussions.microsoft.com> wrote in message
> news:6803F80E-1369-4351-A3DD-7646B93F8ACA@.microsoft.com...
>
>
|||My target server is a RAID 5 with 6 disk at 10k RPM. I have 1 CPU (3.4gig)
and 1 gig of ram. On the partition where I backup the SQL Server, I have 453
gig of free space.
I have no other network traffic during the backup, except 10-20 computers
that can verify if a new virus definition is availaible. The Virus definition
is download outside of the backup period once a day.
The network cards of my target server and my SQL server are configure at
1000/Full Duplex each and my target server File and Printer Sharing option is
configure for "Maximize for File Sharing".
I did the backup locally and it took 5 minutes to backup 19 gig. Much
faster. =) But I still have the problem if I need to transfer the backup on
the target server with a bat file.
What can be the problem ?
I need to solve this backup problem because my database will continue to grow.
Thanks guy.
Jonathan
|||Have you got a large file on the destination server that you can copy to the
same (i.e. destination) server? I just want to confirm that it is a disk
issue and not a network issue. As I mentioned earlier, RAID5 is not your
friend when it comes to heavy writing.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Jonathan" <Jonathan@.discussions.microsoft.com> wrote in message
news:6F793F0F-D271-4032-955C-E04129246EEB@.microsoft.com...
My target server is a RAID 5 with 6 disk at 10k RPM. I have 1 CPU (3.4gig)
and 1 gig of ram. On the partition where I backup the SQL Server, I have 453
gig of free space.
I have no other network traffic during the backup, except 10-20 computers
that can verify if a new virus definition is availaible. The Virus
definition
is download outside of the backup period once a day.
The network cards of my target server and my SQL server are configure at
1000/Full Duplex each and my target server File and Printer Sharing option
is
configure for "Maximize for File Sharing".
I did the backup locally and it took 5 minutes to backup 19 gig. Much
faster. =) But I still have the problem if I need to transfer the backup on
the target server with a bat file.
What can be the problem ?
I need to solve this backup problem because my database will continue to
grow.
Thanks guy.
Jonathan
|||Funny, I thought I mentioned that (copying file on destination server) 2
days ago . . . :-D
Given the network setup (1GB full duplex) it sure sounds like it will be
something on the destination server (antivirus, severe disk frag, very full
disk, etc) causing the problem.
TheSQLGuru
President
Indicium Resources, Inc.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23vMFLORqHHA.4132@.TK2MSFTNGP05.phx.gbl...
> Have you got a large file on the destination server that you can copy to
> the
> same (i.e. destination) server? I just want to confirm that it is a disk
> issue and not a network issue. As I mentioned earlier, RAID5 is not your
> friend when it comes to heavy writing.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Jonathan" <Jonathan@.discussions.microsoft.com> wrote in message
> news:6F793F0F-D271-4032-955C-E04129246EEB@.microsoft.com...
> My target server is a RAID 5 with 6 disk at 10k RPM. I have 1 CPU (3.4gig)
> and 1 gig of ram. On the partition where I backup the SQL Server, I have
> 453
> gig of free space.
> I have no other network traffic during the backup, except 10-20 computers
> that can verify if a new virus definition is availaible. The Virus
> definition
> is download outside of the backup period once a day.
> The network cards of my target server and my SQL server are configure at
> 1000/Full Duplex each and my target server File and Printer Sharing option
> is
> configure for "Maximize for File Sharing".
> I did the backup locally and it took 5 minutes to backup 19 gig. Much
> faster. =) But I still have the problem if I need to transfer the backup
> on
> the target server with a bat file.
> What can be the problem ?
> I need to solve this backup problem because my database will continue to
> grow.
> Thanks guy.
> Jonathan
>
|||I ran PerfMon and the result is very bad.
My Avg Queue Length at 6 and more and my Memory Pages/sec is at an average
of 225.
In summary, if I look at the graph, the Memory Pages/Sec and the Avg Disk
Queue Length is at 100%.
Is it a Memory problem or a disk problem ?
I have 1 gig of RAM and 6 disk at 10k rpm in Raid 5.
Thanks.