Parallel Resoring of SQL DataBases

May 27, 2009 at 8:37 AM

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)

Parallel Time: 1 minute 45 Seconds (approx)
1st DB: 50 th second
2nd DB: 1 minute 20 th second
3rd DB: 1 minute 45th second
4th DB: 1 minute 45th second

Sequetial Time: 1 minute 20 Seconds (approx)
1st DB: 5 second
2nd DB: 30 Second
3rd DB: 25 Second
4th DB: 20 Second ( Total 1 munute 20 Second)


after several iteration the parallel time always takes more time. but the same parallel code other than restoring databases in SQL SERVER like (Copying files in code, Deploying IIS through code or any other processes) saves 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 u tell me like specific reason does sqlserver can have only one active connection at a time ( Is this true or anything like this).

Thanks