3

This is my first post and am very new to MS SQL Server. We have MS SQL Server running on an existing server. We have a software application that is utilizing the SQL Server as its back-end.

We are purchasing another software application that requires MS SQL Server. Can we utilize the same SQL Server for this new application or do we need to purchase new SQL server software and install on new server?

Both applications will use the same version of SQL Server.

closed as too broad by LowlyDBA, mustaccio, McNets, MDCCL, Philᵀᴹ Feb 2 at 18:47

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • What does the "another software application" vendor say? – mustaccio Feb 1 at 13:46
7

It depends on a few things.

  1. SQL version. Will the new application run on the same version of SQL as the existing application?
  2. Security. Are you comfortable having the same people possess server-wide permissions to both applications?
  3. Performance. Are you comfortable with a runaway query in one application possibly affecting the performance of the other application?
  4. Maintenance. Are you comfortable with the idea of any maintenance that requires a server reboot or a SQL service restart taking both applications out of commission at the same time?
  5. Vendor support. Do the vendors of each application support having them co-located on a server with other applications? (Just because the vendor doesn't like it, doesn't mean you can't make it work. But if you don't follow the vendor's requirements, you run the risk of them refusing to help you when something goes wrong.)

Not the answer you're looking for? Browse other questions tagged or ask your own question.