Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
srajakrishna
Starting Member
1 Post |
 Posted - 2009-06-03 : 07:05:47
|
| Hi everyone,iam just doing a sample task , of restoring 4 databases Parallely as well as sequentially, through C# code. (all together size of DB's are 2GB)sequentially restoring database one by one.Sequetial Total Time: 1 minute 20 Seconds (approx)1st DB: 5 second2nd DB: 30 Second3rd DB: 25 Second4th DB: 20 Second ( Total 1 minute 20 Second)Parallel restoring database all atonce. The UI of sqlserver shows Restoring for all the databases simultaneously using C# threading code.Parallel Total Time: 1 minute 45 Seconds (approx)1st DB: 50 th second2nd DB: 1 minute 20 th second3rd DB: 1 minute 45th second4th DB: 1 minute 45th secondthe total parallel time should have been 30second because that was the max time taken by large database (2nd DB - 620MB approx), but it is not so in above case.after several iteration the total Parallel time always takes more time than total Sequential time.The same C# code other than restoring databases in SQL SERVER like (Copying files in code, Deploying IIS through code or any other processes) saves more than half of the time. When it comes to sql server it takes more time.i need to give more specific reason to my team.i could understand answer like stress will more on sqlserver ( server resources used more) which is not good.can Someone tell me like specific reason does sqlserver can have only one active connection at a time ( Is this true or anything like this).IS parallel restoring possible in Sqlserver, to put it simple.Database Used: Sqlserver 2005looking for an urgent reply.Thanks Raja |
|
|
|
|
|
Parallel Restore of Database