How to increase application performance with Centralised SQL Server?

Recommendations on this ?

  • Hi guyz,,,,,i have a windows 2k3 server installed on a highly configured machine with SQL server 2000. Ok so recently we had developed our intra net application on .net and testing on this server. my question is , should i keep SQL server on the same machine with the application or shall i install SQL on the other machine . Will this increase the performance of my application? answers with technical specification will be highly appreciatable....

  • Answer:

    see this is a case of 2 tier architecture if u r server (database) is expected to have a lot of load from clients, then it is not a bad idea to have database server on separate machine, other wise it is fine and doent matter for small work or load still it is a case of client server archietecture kindly rate my answer

Ah C at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

Hard to say offhand without a LOT of other info. You could possibly see a performace hit due to the added cross-server traffic, but chances are there will be some improvement due to having the additional processor taking up some of the workload. The main determining factor will be how much data is being shuffled back and forth and how often.

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.