We have been having an issue with one of our super micro servers. Runs windows server 2012 datacentre R2 and sql server 2012 sp1. When trying to import a flat file it takes really long, in the region of 4 days for 6 millions lines. This never used to be the case and we have not done or installed anything on the machine. To ensure everything is in order, i reloaded the server and updated the drivers. what is interesting is that the whole system effectively becomes non responsive. The moment you kill the process everything returns back to normal. Is there anything that i can run or set to see what it is that is causing this lag? Just to mention, when you look at the processes running, CPU is on 2% and memory on 10% with virtually no HDD activity. The HDD is set up in RAID5 with 3 x 1TB enterprise WD drives.