Re: Database Backups & Restores: an in-depth knowledge required
From: evan b (evan_at_cheapaschips.com.au_removethis)
Date: 01/04/05
- Next message: Mark Evans via SQLMonster.com: "Re: dts import/export problems"
- Previous message: Uri Dimant: "Re: SQL2000 TLogs Growth Issue"
- In reply to: Griff: "Database Backups & Restores: an in-depth knowledge required"
- Next in thread: Griff: "Re: Database Backups & Restores: an in-depth knowledge required"
- Reply: Griff: "Re: Database Backups & Restores: an in-depth knowledge required"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 5 Jan 2005 00:54:07 +1030
Well perhaps it's your specs
btw u can run CPUZ to identify bus speeds etc.
If the machines have same quality of equipment and are configured similarly
then I would suggest your ram and dual CPU vs single CPU
If you run the profiler on them as they are backing perhaps you will see
something like mem utilisation etc.
Another thought is how much are the files fragmented the dbs arent huge but
there may be a degree of fragmentation on the file system which slows things
down.
Also how are you restoring from Server A to Server B?
"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
>
>
>
>
- Next message: Mark Evans via SQLMonster.com: "Re: dts import/export problems"
- Previous message: Uri Dimant: "Re: SQL2000 TLogs Growth Issue"
- In reply to: Griff: "Database Backups & Restores: an in-depth knowledge required"
- Next in thread: Griff: "Re: Database Backups & Restores: an in-depth knowledge required"
- Reply: Griff: "Re: Database Backups & Restores: an in-depth knowledge required"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
