When trying to import off business hours DTW is really slow, takes about 2 seconds a record importing pricelists , and / or , item's data frgnname + SuppCatNo.
trying to import about ~2000 records a time.
database size is ~ 30 gb.
SAP server is running on dual xeons , windows server 2008 , 96gb ram, sql resides on raid 5 4xSSD 256GB with raid battery controller.
network is 4gb/sec LACP.
thanks for any heads up,