Solved

What's the best way to deploy multiple SQL Server solutions

Posted on 2013-11-13
5
342 Views
Last Modified: 2013-11-18
Hi guys, I'm getting ready to engage 3 to 4 projects that require MS SQL. Across all of the applications and projects the recommendation is to house the SQL server on its own machine and the actual application on another. I have a few questions about this.

Is the best way to have the app on one server and the SQL server on another machine?
Can I have one SQL server for all my applications (i.e all my applications connect to the same server)?
Is it better to have a separate SQL machine for each of my applications i'm launching?
Is it ok to run my SQL server off of virtual server? If so, what are the recommendations?

You're probably wondering what the applications are. But you probably wouldn't know if I told you. These are just 3rd party software vendors that use SQL. Ones a payroll solution out of Saudi Arabia. Another is some warehouse software. Barring their own idiosyncrasies, they all use a standard approach to using SQL server.
0
Comment
Question by:js_sts
5 Comments
 
LVL 33

Accepted Solution

by:
Big Monty earned 125 total points
ID: 39645097
here's a good whitepaper on using swl server and virtual machines:

http://www.vmware.com/files/pdf/solutions/sql_server_virtual_bp.pdf

a lot of what you ask depends on the specs of the machine and what you expect your site traffic to be like, as well as what resources you have. If you're only expecting a few hundred visitors each day, then you can get away with having everything on one machine. If you're expecting millions of users though, you'd probably want to have separate servers. You also need to take into account what kind of backup plan you want. do you want to just take backups every night or do you want a secondary server to come online if the primary goes down?
0
 
LVL 34

Assisted Solution

by:Brian Crowe
Brian Crowe earned 125 total points
ID: 39645151
As The_Big_Daddy mentions, how much you can group your applications/Databases is largely dependent on how busy they will be, but yes it is preferable to put your applications(s) on a separate server from your SQL Server instance(s).  SQL Server doesn't play well with others as a general rule.

SQL Server works just fine in a virtualized environment so I wouldn't have any reservations on that front and the ability to add resources as the need arises is a nice bonus.
0
 
LVL 26

Assisted Solution

by:Zberteoc
Zberteoc earned 125 total points
ID: 39645258
And yes, generally you should use on server for 3 or even more applications. SQL server is powerful enough to deal with multiple databases and applications unless one or some of them have unusually high number of transactions, which I doubt. Another aspect is that SQL server is pretty expensive to afford the luxury to have one for each of your apps.
0
 
LVL 69

Assisted Solution

by:Scott Pletcher
Scott Pletcher earned 125 total points
ID: 39646152
? app on one server and the SQL server on another?
    Yes

? one SQL server [shared] for all my apps ?
    Yes; SQL costs alone generally make this much more preferable.  If you need to, "beef up" the RAM and other hardware on the server to accommodate the load.

? better to have a separate SQL machine for each of my apps ?
    No, just too expensive.

? ok to run SQL off of virtual server ?
    I've never found that to work all that well, due to performance loss, but BriCrowe has obviously had different results.
0
 

Author Comment

by:js_sts
ID: 39658342
thanks for input guys. I think all of you have shed light on this. I think I will just go with two severs, one for SQL and one for my app. I will probably virtualize my apps. I think I can get away with virtualizing SQL but my gut says to not vituralize sQL. I will probably get a backup server for my SQL server and have two 1U SQL servers.

I feel much better now. Thanks guys!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating and Managing Databases with phpMyAdmin in cPanel.
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question