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 |
|
T2000
Starting Member
3 Posts |
 Posted - 2006-03-23 : 16:34:15
|
| I was wondering: suppose you have 1 high performance server, loads of mem and storage at will. Would it be advisable to 'merge' several sql servers into 1 performant server, thus get many db's on 1 server? Wouldn't this become an administration nightmare? This way all performance & optimizing jobs will collide at night time when production is down. There will be a shortage of nighttime to do scheduled jobs on all those db's on 1 server, not? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-23 : 20:33:54
|
i advise not to just dump databases into a servermake out a category for "merging", also take note of the resources those DBs will be needing, I believe they call that capacity planning --------------------keeping it simple... |
 |
|
|
|
|
|
Administration limit