Database Backups & Restores: an in-depth knowledge required

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Griff (Howling_at_The.Moon)
Date: 01/04/05 

Date: Tue, 4 Jan 2005 13:04:46 -0000

I have two servers.

Server A:
    Dual 2.8 Xeon Processor
    4 GB RAM
    SQL Server 2000 Enterprise

Server B
    Single 3.0 Xeon Processor
    2.5 GB RAM
    SQL Server 2000 Standard

I have an identical database on both. The backup file is 1.22 GB, the data
file is 1.44 GB and the log file is 504 KB.

When I restore these databases, the restore on server A takes 2.58 minutes,
but on server B it takes 6.48 minutes (over twice as long).

Similar discrepancies are found when I backup these databases.

I don't understand why!

Studying task manager shows that the CPU usage is minimal and the amount of
memory used is minimal, presumably ruling out the speed of the processors
and the amount of RAM available. If I had multiple data devices then I
could see the Enterprise version being quicker because it could create more
threads for parallel processing, but I don't so this should rule out the
Enterprise/Standard differences. Oh and both servers run on multiple
spindle, fast RAID5+1 disks, and these are identical.

So....what is occurring that actually takes the ~ 3 minutes or ~ 7 minutes?

Many thanks

Griff

Relevant Pages

  • Re: Which Version of Windows 2003?
    ... The performance difference between standard and enterprise is really a ... I actually run the same server you do, ... 4GB of RAM and because of this limitation (and other reasons that need not be ...
    (microsoft.public.windows.terminal_services)
  • Re: Which Version of Windows 2003?
    ... The performance difference between standard and enterprise is really a ... I actually run the same server you do, ... 4GB of RAM and because of this limitation (and other reasons that need not be ...
    (microsoft.public.windows.terminal_services)
  • Re: Which Version of Windows 2003?
    ... The performance difference between standard and enterprise is really a ... I actually run the same server you do, ... 4GB of RAM and because of this limitation (and other reasons that need not be ...
    (microsoft.public.windows.terminal_services)
  • RE: Windows 2003 Enterprise Server, Memory not showing up
    ... Microsoft Enterprise Platforms Support ... Windows 2003 Enterprise Server, ... <We loaded Window Storage Server on a system with 12 Gig of ram. ...
    (microsoft.public.windows.server.general)
  • Re: Windows 2003 Server Enterprise : 32Bit oder 64Bit
    ... Du bekommst auch den Standard Server als 64Bit System. ... Der unterstützt bis zu 32GB RAM. ... Die Enterprise Edition macht z.B. nur Sinn wenn Du Clustering einsetzen willst oder den Sitzungsverzeichnisdienst für die TS Geschichte nutzen möchtest. ...
    (microsoft.public.de.german.windows.server.general)