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 |
|
lily
Starting Member
6 Posts |
 Posted - 2002-03-18 : 02:13:10
|
| we have been running some jobs that take a lot of the CPU usage. I would like to know if there is any possible way to :1. Distribute between processors, the scheduled jobs.2. Minimize the maximum amount of CPU usage that a job can take. |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-18 : 02:20:56
|
| AFAIK if you have multipe processors installed . Sql Server will automatically takes care of distributing your jobs between the processors.why dont you post about your job's with the code. might be we could help you improve its performance.-------------------------------------------------------------- |
 |
|
|
|
|
|
How to tuning CPU usage on SQL serve