RE: SSIS Perf question
- From: petery@xxxxxxxxxxxxxxxxxxxx (Peter Yang [MSFT])
- Date: Fri, 16 Mar 2007 03:24:56 GMT
Hello,
Per your question, when exectuing packages, sql queries/SPs are still
running on SQL engine. SSIS engine is to process the workflow of the
packages. The real data processing for SQL database are by SQL engines. You
may want to see the architecture of SSIS for details
Integration Services Architecture
http://msdn2.microsoft.com/en-us/library/ms141709.aspx
The SSIS service does not support delegation. You could only store SSIS
packages in local instance of SQL Server and not a remote server. As for
the instance on perf, are you referring to Sqlserver:SSIS Service\SSIS
package instances? It is referring to SSIS package instances that are
running SSIS packages. It's not SQL Server engine instance. SSIS package
instance use their own resources, and it is seperated from SQL engine
resources.
If you have any further questions or concerns, please feel free to let me
know. Thank you.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
.
- Follow-Ups:
- RE: SSIS Perf question
- From: Peter Yang [MSFT]
- RE: SSIS Perf question
- Prev by Date: Re: How to get job result from sp_start_job
- Next by Date: Re: How to get job result from sp_start_job
- Previous by thread: RE: Re-run the package after catching an error
- Next by thread: RE: SSIS Perf question
- Index(es):
Relevant Pages
|
