Loading 1TB in 10 Minutes in SSIS – SQL Server Scalability on high end hardware

Monday, November 29, 2010

This is a live post from the session of Henk van der Valk  at Tech Ed Israel 2010 . This session has great tips and tricks for you in SSIS and is in English (just in case you're reading this blog and don't understand Hebrew :)) Checking for problems when test loading data:Select * from sys.dm_os_wait_stats Number 1 wait: pageiolatch_upSolution: add more spindles So - just add more hardware?Number 2 pagelatch_upSolution: add more database files Configure 1 to 4 files per filegroup to get 200+ KB writes IOs. Use Soft Numa - assign a specific port for it Use money data type instead...