Re: Database Backups & Restores: an in-depth knowledge required

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

From: AnthonyThomas (Anthony.Thomas_at_CommerceBank.com)
Date: 01/04/05 

Date: Tue, 4 Jan 2005 07:27:39 -0600

What are the server manufacturer and model numbers? What are the FSB
speeds? What are the I/O controller speeds? What is the System:Worker
Queue counter throughput? What are the Physical/Logical disk counter
throughput?

Sincerely,

Anthony Thomas 

-- 
"Griff" <Howling@The.Moon> wrote in message
news:%23wUo43l8EHA.1564@TK2MSFTNGP09.phx.gbl...
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: Slow Network Speed over WAN
    ... that they'll fragment as they are shipped into the WAN. ... Windows NIC). ... Copies from the West Coast server to another in the same site happen at ... Those speeds are representative of either site (when testing against a test ...
    (microsoft.public.windows.server.networking)
  • RE: Slow Network Speed over WAN
    ... Have a look to make sure you are not fragmenting encrypted packets on either ... Windows NIC). ... Copies from the West Coast server to another in the same site happen at ... Those speeds are representative of either site (when testing against a test ...
    (microsoft.public.windows.server.networking)
  • Re: SBS 2003 slowing internet by almost 50%
    ... Nvidia nForce4 nic in server machine looks to be the culprit. ... One other workstation was losing connections to the ... all within the same range of speeds. ... No change in speed test. ...
    (microsoft.public.windows.server.sbs)
  • Re: Advice - Terminal Server
    ... I like IPSec VPN between two compatible firewalls/routers. ... However, as we all know, VPN is slooow, and the remote office is ... terminal server for the remote clients to connect to. ... and will quickly forget about their fast speeds and be mad ...
    (microsoft.public.windows.server.sbs)
  • Re: Domain Controller qestion
    ... only upload at 128k because of their own limitations on ADSL. ... If they UPLOAD directly to US server, and I DL from US ... clients, in fact it means I CAN mirrir so it is an advantage. ... >Typically, 'unlimited' AU ADSL is at rather limited speeds, particularly ...
    (microsoft.public.windows.server.sbs)