Last post Nov 17, 2014 06:35 PM by markpringle
Nov 17, 2014 12:38 PM|markpringle|LINK
I have website with both the MS SQL SERVER database and the websites (asp.net, C#) 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?
Nov 17, 2014 01:56 PM|jsiahaan|LINK
Both using memory and CPU. Each of them can use more memory and CPU then the other, this is depend on how big your data, and how complicated your web application.
Let say you need to update a bulky data, and you can send an SQL update line command. You may use only one line command and send this command from Web App to SQL Server. In this case need a faster one on SQL Server. This is may the most reason to make SQL
server the faster processor.
Or if your SQL has a store procedure that can summarize a big data into a small part, you can use the faster processor for SQL Server. Other wise if a lot of data from database is processed on application, you need the faster processor for web app server.
Hope can help.
Nov 17, 2014 06:35 PM|markpringle|LINK
Thanks. All of the data processing is done in the database. However, I do cache a lot of data on the web end if that means anything.