SQL 7 & Multi Processor

[GenTrac]

We have SQL 7 installed on a multi processor NT4 ML370 Compaq server, 2,5Gb of RAM and SQL patched with SP4. The problem that I have is that when SQL is configured to use both processors it slows do all queries. Once 1 processor is selected it executes a lot faster. Anyone knows of dual processor issues? Do I need to install NT4 SP6a again after I installed SP4 for SQL?

 

[mrdenny]

Some queries can run faster without the parralism. Try leaving the SQL Server configured to use both processors, but have one of the offending queries restricted to a single processor. You do this by adding OPTION (MAXDOP 1) to the end of the select.

select Col1, Col4
from Table
where something = 'somethingelse'
OPTION (MAXDOP 1)

SP6a might help on this. But I don't really think so.

Denny

--Anything is possible. All it takes is a little research. (Me)