November 17, 2014 at 10:36 am
I have website with both the MS SQL SERVER database and the websites on the same server. I am looking to separate the two. I have received a quote with two different servers, one whose processor is slower than the other (the rest of the configuration is similar). Which server should get the faster processor, the database server or the web server?
November 17, 2014 at 10:49 am
I'd give it to the database server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 17, 2014 at 10:54 am
Typically you want to give the better hardware to the database server. Web servers can be scaled out while database servers have to scale up.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 18, 2014 at 2:20 am
This was removed by the editor as SPAM
November 18, 2014 at 2:22 am
Database server. Web servers typically aren't very CPU intensive, and if they become a bottleneck you can add more web servers and a load balancer. SQL however doesn't scale out easily.
Don't skimp on memory on the database server either. SQL loves memory.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply