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 |
|
lotek
Starting Member
42 Posts |
 Posted - 2010-05-05 : 12:47:58
|
| I am analyzing the speed of some of my bulk insert queries and have a question.Setup: SQL2005 with seperate OS, DATA, and LOG drives. System databases (master, temp, etc) are on the OS drive.When i am performing a bulk insert from files that are located on a network drive to a database that is on the DATA drive. When i look in perfmon, the majority of the disk writes are happening on the OS drive and that drive has the biggest queue length. Is this becuase of the temp db? I want to leverage the speed of the data drive becuase it is the fastest array. Thoughts?Thanks,Matt |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
lotek
Starting Member
42 Posts |
Posted - 2010-05-05 : 14:22:57
|
| No, not on their own spindles. I have raid1 OS (2 drives), raid10 data (4 drives), and raid1 logs (2 drives). I have space for them on data drive... |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Disk Utilization During Bulk Insert