We utilize SSIS extensively to process data feeds and when those files become large, we find the resources on the SQL are pretty well depleted. That in turns causes the application, whcih is connected to that same SQL Server, to suffer from
a performance stand point. We have to act on this as the problem will only get worse over time and are considering creating a separate SQL instance for SSIS packages but are also interested if there is anything that can be done now to govern the amount of
resources that any given SSIS package can use, with the understanding that doing so will cause them (the SSIS pkgs) to have a longer execution time.
We are using SQL 2008 Enterprise Edition and have been reviewing the Resource Governor within SQL, but it appears that that tool can not govern SSIS package resources, so the question is can anything perform that task?
Thanks in advance for the feedback.
View Complete Post