开发者

Separate machines for DBMS and SSIS, SSRS, SQL Agent?

开发者 https://www.devze.com 2023-02-26 04:18 出处:网络
We have two DB boxes. We would like to keep our application DB on one server and on the other server we would like to have SSI开发者_开发百科S, SSRS and SQL Agent. Are there any performance issues whe

We have two DB boxes. We would like to keep our application DB on one server and on the other server we would like to have SSI开发者_开发百科S, SSRS and SQL Agent. Are there any performance issues when doing this? Or are there any recommendations associated with this? Given we need to install Oracle driver, Office driver etc...


There are 2 potential issues with this approach:

  • You will need a MS SQL Licence for both machines, so higher cost
  • If the SSIS packages are accessing the database they will be pulling data across the network instead of handling it locally on the machine

What you have not said is why you want to do this?

0

精彩评论

暂无评论...
验证码 换一张
取 消