I've developed a process that uses XML bulk upload classes (SQLXMLBulkLoad4Class) to upload from a c# wcf service to a SQL server 2005 enterprise
database. Performance of the upload step on my Dev and TST servers is good with 61 XML files (748MB combined size) being uploaded in 7 - 10 mins. When I release this code to the UAT and Prod environments the same set of files takes 30 - 60 mins to upload.
I've looked at IO and CPU performance counters in these environments and if anything the Dev and TST counts are worse. What can I do to improve performance?
View Complete Post