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.
JonathanHi,
I seriously doubt it, because I backup 45 Gb database in less than 20 min
time.
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"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|||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...
> > 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
>
>|||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...
> > 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
>
>|||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.|||The disk queue length should be < 2 X the number of spindles = 12, in your
case. Thus, the disk queue length is fine. (Disk queue lengths are
absolute numbers, not percentages. I suspect that the scale for your
counter is set to the default.) Are these numbers from when the actual file
copy is taking place?
--
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:71B84BFD-943A-42E8-875B-FD2D2559928F@.microsoft.com...
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.