Senin, 29 November 2010

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

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 spindlesSo - just add more hardware?Number 2

Tidak ada komentar:

Posting Komentar