Posted - 07/05/2012 : 10:01:23
| Hey guys,
I'm a s/w developer and we have a client where running insert statements into a SQL Server 2008 database seems to take a long time.
To run 1955 individual insert statements takes 55 seconds on my client's SQL Server however when we move the database to a simple USB pen drive (plugged into the SQL Server) the insert statement takes 25-30 seconds. I'm at a loss as to what is causing this problem.
I've analysed the client statistics (via Management Studio) on the inserts on each database and the "Wait time on server replies" is 13 on the USB but 37 on the server HDD.
The server has the below.
2-Quad-Core E5320 CPU’s, and a Smart Array E200i RAID controller and 2 x HP 146GB 10Krpm SAS Drives in RAID/1 configuration.
Does anyone have any suggestions as to what maybe making this write process so slow?
Thanks in advance,