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 |
|
ismgr
Starting Member
2 Posts |
 Posted - 2010-04-12 : 11:35:02
|
| I am looking to determine whether it would be a benefit to combine to physically separate sql 2005 servers.which methods (perfmon) would you recommend I run, or what things would you look at to see if this is a good choice, or if they need to remain separated?thanks. |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-12 : 12:24:06
|
| Do you can any authorization constraints you need to consider? eg, Server1 has Database1a and Database1b, and User1. Server2 has Database2a and Database2b, and User12. Currently User1 is a member of various server level roles on Server1, granting them permissions to perform actions on Database1a and Database1b, but you don't want them having the same level of priv to Server2?------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
 |
|
|
ismgr
Starting Member
2 Posts |
Posted - 2010-04-12 : 12:48:54
|
| It is not 100% necessary to restrict access, but it would be nice. |
|
|
|
|
|
|
combining sql instances or servers