srajakrishna (6/3/2009)
Hi Markus,I used to run my code for restoring using
Single Cpu System
1.5 GB RAM
Pentium4 2.4 gig
i want to know does parallel restore in possible and that to faster than sequential restoring.
If possible: will it be faster with more number of Processors.
How can we implement parallelism for each CPU or multicore.
Thanks,
eagerly waiting for your reply
Raja
As I wrote before you should look through performance counters what is your bottleneck. I would imagine that having more than one CPU will be faster, but if IO is your bottleneck then adding extra CPU's won't make a difference.
Also where are your backupfiles stored, what kind of RAID if any are you using, what edition of SQL Server are you using, etc.
Lot's of things which have an impact on the overall performance.
So to answer your questions is it possible to resotre several database in parallel? Yes it is, as you already proved yourself.
Is it faster than serial restore ? It depends.
[font="Verdana"]Markus Bohse[/font]