Kirk Haselden : Making SSIS a Clustered Service
Kirk Haselden : Making SSIS a Clustered Service: "Pros:
Allows SSIS Server to run an a different node so SSIS and SQL Server won�t compete for CPU time
Since most of SSIS Server functionality (except MSDB store) doesn�t depend on a SQL Server it is reasonable to run it in a separate group
Once SSIS Server runs in a separate group it can be moved to another node faster.
Cons:
When UI, SSIS Server and SQL Server runs on 3 different machines MSDB Node is unavailable. This is IDW15 design that may or may not be changed.
When SSIS and SQL Server run on the same node operations against MSDB may be faster and generate less network traffic."
posted by Duncan @ 10:27 AM
2 comments
links to this post
2 Comments:
Hi, heute hast du mir mit deinem blog die langweile vertrieben. Nach stunden des gelangweielten surfens bin ich hier gelandet. Absolut interessantes Thema.
Ich denk hier werde ich öfter vorbei schauen !
Ich habe eine Seite über workstation. Hier findest du alles über workstation und noch viel mehr !
Wenn du Zeit hast, schau doch mal vorbei ! :-)
Hi,
I liked your blog. I found many interesting information here.
I also give free info about advertising promotion. You can seen it on my advertising promotion site.
If you have time please visit my web site to get some free advertising promotion information.
Kind regards,
Nick
Post a Comment
Links to this post:
Create a Link
<< Home