Using ‘sys.dm_os_wait_stats’ to measure SSIS Package Performance
Using ‘sys.dm_os_wait_stats’ to measure SSIS Package Performance Chris Skorlinski Microsoft SQL Server Escalation Services We worked with a customer the other day who had 2 SSIS packages running queries against SQL Server database. One SSIS package executed twice as fast on one SQL Server as it did on another SQL Server. While troubleshooting, we wanted to see if the longer run time was a SQL engine/query issue or a SSIS package execution issue.
Read the rest here:
Using ‘sys.dm_os_wait_stats’ to measure SSIS Package Performance
