5 star 4.9 Overall Satisfaction Rating

Blog Proper Architecture: Separate Your Microsoft SQL Database Backend From The Frontend


In a previous article, we explained the advantages of separating your frontend, such as WordPress, from its backend, such as MySQL, by running them in separate virtual servers.

When operating a similar application in a Microsoft Windows environment, it is a good idea to separate Microsoft SQL to its own server, not only for security and performance, but for an additional reason: cost control.

Microsoft charges for their licenses based on the number of CPU cores. Perhaps your frontend needs four CPU cores, but the SQL aspect of it needs just one CPU core. Why would you pay Microsoft for a four CPU core license of SQL when you actually just need 1?

So, put Microsoft SQL in its own virtual server, and your front end on another.

Save money by putting Microsoft SQL in its own server.

Remember also to protect your Microsoft SQL data! Activate one of our backup plans, and also, install SQL Backup Master and have it save copies of your SQL to the local virtual server, but also, to upload a copy to a third party storage service, such as Dropbox!

  • The current CTO of Serverpoint.com and an accomplished web developer. Peter is one of the leading voices at Serverpoint and one of the founding members.

Home / Terms of Service / Privacy Policy

Copyrights © All Rights Reserved by A+ Hosting, Inc., DBA ServerPoint.com,
proudly located in the great state of Nevada, with data centers located around the globe.
Deploy Linux and Windows virtual private servers, cloud servers and cloud hosting in Amsterdam, Netherlands, Las Vegas, Nevada, Dallas, Texas and Ashburn, Virginia. Santa Clara, California and Singapore!