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 |
|
DBASlut
Yak Posting Veteran
71 Posts |
 Posted - 2006-03-02 : 15:02:11
|
| If i have multiple SQL Server instances running and one instance locks up, would it affect the other instances? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-02 : 15:23:58
|
| It shouldn't, but it depends on what "locks up" means and how you have them configured.Tara Kizeraka tduggan |
 |
|
|
DBASlut
Yak Posting Veteran
71 Posts |
Posted - 2006-03-02 : 16:19:01
|
| What I'm planning to do is create instances for each client's database. So instead of all clients db on 1 database, they'll be on their own db instance. The databases will be the same in schema, but each db is dedicated to one client.Thanks Tara. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-02 : 16:21:35
|
| You can configured number of CPUs and RAM to be used for each instance. That would help isolate issues to an instance.Tara Kizeraka tduggan |
|
|
|
|
|
|
SQL Server instances