| Author |
use only 1 processor
|
|
| ChrisR 2005-04-29, 1:23 pm |
| sql2k
A while back a Developer wrote an SP that cause a specific type of Deadlock.
If memory servers correctly and from reading BOL it was a "parallelism"
deadlock. Anyways, the resolution was to tell SQL to use only 1 processor
when running the SP. Im now in a debate about the whole thing with coworkers
and cant find any documentation to support my arguement or the resolution.
Any ideas?
TIA, ChrisR
| |
| David Gugick 2005-04-29, 1:23 pm |
| ChrisR wrote:
> sql2k
>
> A while back a Developer wrote an SP that cause a specific type of
> Deadlock. If memory servers correctly and from reading BOL it was a
> "parallelism" deadlock. Anyways, the resolution was to tell SQL to
> use only 1 processor when running the SP. Im now in a debate about
> the whole thing with coworkers and cant find any documentation to
> support my arguement or the resolution. Any ideas?
>
> TIA, ChrisR
http://support.microsoft.com/?kbid=837983
--
David Gugick
Imceda Software
www.imceda.com
| |
|
|
|
|