July 1, 2003 at 8:21 pm
Good day to everybody!
I'm running SQL 2000 with SP2, windows advanced 2000 SP3. 4Gs of memmory and
6 CPUs
Here is a question: this system running trans replication with a local distrib.
When Its generating a snapshot, out of all 6 cpus only one is maxing out up to 98%, the rest of the cpus not running even 5%.
In server properties all CPUs are checked for usage by SQL, also I have allocated 2Gs of memmory for SQL. How do I spread equaly
CPU usage.
July 4, 2003 at 8:00 am
This was removed by the editor as SPAM
July 7, 2003 at 6:52 am
Have you checked the "SQL Server Properties (Processor Tab)" options to confirm that you have correctly set the number of processors to use for parallel query as well as the "Minimum query plan threshold for considering queries for parallel execution" option.
Joseph
July 7, 2003 at 9:42 am
There is an -inproc (spelling?) switch that lets you run multiple threads, that might distribute the workload.
Andy
July 7, 2003 at 9:55 am
Thank you, very much! I'll try that.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply