Restoring 15GB database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Restoring 15GB database

I’m in the process of restoring a 15GB db into our SQL Server 2005 X64 env deployed on iSCSI SAN which takes 2 hours. Lookigninto the Activity Monitor, BACKUP DATABASE process is in SUSPEND mode with the following values:
CPU: 3072
Physical IO: 630
WaitTime : 5570265.
This is a brand new server. We have tested drives using SQLIOSIM which tested OK before deployment.
Appreciate any help

15 GB restore shouldn’t more than couple of minutes…
Where is the backup file located when you are restoring?

I’m restoring of a network drive assigned to this node.

Then check the network link between that network drive and this server, find out what is the network speed allocated on the hub.

Apparently our Network Engineer found errors ona few ports at our Data Center which could be the possible source of this slowness.
Will keep you posted if that resolves it or not..

One of our core switch was spitting errors and is in the mode of being replaced.
Appreciate your help.


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |