Multiprocessors in SQL 2000

[Tom123]

Hi,

Is anyone aware of a problem with blocking when using SQL 2000 on a system with more than 1 processor?

 

[tlbroadbent]

I'm not aware of blocking problems caused by multi-processors. I've read nothing in any of the literature thus far.

What prompted the question? We just installed SQL 2000 on our test server and it is the only single-processor server we have. We certainly want to be made aware of any potential difficulty before installing to production servers. Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost

 

[foxdev]

I have experienced a problem on SQL Server 7 with multiple processors, though I'd think it would have been fixed by v2000. The cause dealt with a query execution plan that sometimes (it happened to me about 4x over the course of 6 months) went haywire.

There was a tech note on this on MSDN, but a quick search wouldn't find it. The work around for v7 was reboot the server (yep). Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[tlbroadbent]

In several years of running SQL server on our multi-processor servers, we've not had any problems except parallel query processing that caused an error when attempting to unlock a resource that wasn't locked (or something like that!). That was corrected by setting a higher "degree of parallelism." Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost