Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-21 : 07:22:05
|
| Bob writes "I have several core applications running on either MSDE or other 3rd party engines. We will be moving them to SQL in the near future and need some input on server sizing and best practices. 1)I'll have 3 core apps, should they run on different servers or is it safe to run everything from the SQL server (RAID 1+5 configuration)?2)How do I size a server if running everthing on one box?Any input would be appreciated.Bob Beck" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-09-21 : 09:51:22
|
| 1a...apps...web or vb/c?... web...put iis on different box. other...don't care1b....safe on 1. could go down VM route if required to segment logical servers from physical servers...allows stop/starting of services independant of each other.2...what size db's, trans per min, connections, db + traffic growth?i can't answer the q, but other might from the information supplied. |
 |
|
|
|
|
|
I'm new to SQL and have basic questions on implementing