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
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:
- Any great restaurant recommendations in Bordeaux France?Best solution by tripadvisor.com
- DVD recommendations for Pilates and Spanish?Best solution by Yahoo! Answers
- Skydiving Recommendations?Best solution by Yahoo! Answers
- There is any recommendations for hotels in Playa del Carmen?Best solution by Yahoo! Answers
- Recommendations for hotels/hostels in London?Best solution by lonelyplanet.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
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.