December 8, 2009 at 5:31 am
Hello everybody,
For a client I need a to write a rapport to persuade them to get a special integration server. Right now it runs on the same server as the database. Has anybody encountered problems with this that I could use in the rapport or any other fundamental drawbacks of running on the same server?
TIA,
Peter
December 8, 2009 at 6:33 am
satanofhope (12/8/2009)
Hello everybody,For a client I need a to write a rapport to persuade them to get a special integration server. Right now it runs on the same server as the database. Has anybody encountered problems with this that I could use in the rapport or any other fundamental drawbacks of running on the same server?
TIA,
Peter
What is rapport?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 8, 2009 at 6:52 am
We run a seperate SSIS box mainly for security purposes as it needs to talk to a lot different servers to obtain the data it is more secure to allow a SSIS box acceess to the various servers via the firewall rather than give the database server direct acccess.
You also may have a problem with resources SSIS can use a lot of memory and you may find that it is competing with SQL server for memory.
December 8, 2009 at 7:23 am
Even we do implement a single dedicated SSIS Server that takes care of all data movement from multiple server inside our organization. In that way we would take off the load from the database servers.
When we were implementing, I Googled and found a link / article where Microsoft suggested having a dedicated SSIS Server for better performance. I suggest you too find it and show as a valuable reason in your report.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 8, 2009 at 7:25 am
Bru Medishetty (12/8/2009)
Even we do implement a single dedicated SSIS Server that takes care of all data movement from multiple server inside our organization. In that way we would take off the load from the database servers.When we were implementing, I Googled and found a link / article where Microsoft suggested having a dedicated SSIS Server for better performance. I suggest you too find it and show as a valuable reason in your report.
While I do agree with this, you will probably find that the advice from Microsoft can be a little biased esp. when it comes to purchasing extra SQL servers..
December 8, 2009 at 7:27 am
steveb. (12/8/2009)
Bru Medishetty (12/8/2009)
Even we do implement a single dedicated SSIS Server that takes care of all data movement from multiple server inside our organization. In that way we would take off the load from the database servers.When we were implementing, I Googled and found a link / article where Microsoft suggested having a dedicated SSIS Server for better performance. I suggest you too find it and show as a valuable reason in your report.
While I do agree with this, you will probably find that the advice from Microsoft can be a little biased esp. when it comes to purchasing extra SQL servers..
LOL 🙂
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 8, 2009 at 8:55 am
Most people I know have SSIS running on the same server as the database unless they have a large load of packages running. It seems to be OK. Separate service accounts can be running, you can separate folders for import/export files, etc.
December 9, 2009 at 6:59 am
Thanx guys, that was helpful. Turns out it has to be mainly about resources en the contention between SSIS and SQL Server. So I am going to focus on that.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply