any tuning info available folks.

Eg:

as part of SQL2000 installation for BaanIVc4

we execute at the end something like:
execute sp_configure"show advanced options", 1
reconfigure with override
execute sp_configure "max degree of parallelism", 1
execute sp_configure "priority boost", 0
execute sp_configure "open objects", 0

is it all required for tuning;

ours is a dedicated baan sql server on the same machine. we feel the system is slow even after we rolled back the MDAC as per one of the BGS solution.

any other practical SQL2000 tips available my dear fnds pls help

tks


vish

:cool:

re: "we feel the system is slow even after we rolled back the MDAC as per one of the BGS solution."

there is now a SP3a available.

check solution 132157

hope this helps..