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 - 2003-04-01 : 07:30:29
|
| Lava writes "I would like to know how SQL server 2000 does workload balancing? I mean How do you keep one instance from consuming resources? Does SQL has its own native Workload management tool? Thanks;Lava" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-01 : 12:51:57
|
| Well by default, SQL Server is configured to consume all of the resources (doesn't matter what instance we are talking about). So if you don't want this to happen, then change the configuration by executing sp_configure and passing it the appropriate information (please see BOL for this).Tara |
 |
|
|
|
|
|
SQL workload balancing