Thank You All.

It worked fine.

How many CPU's can we set to get good performance faster from SQL Server 2000 Standard Edition if i have 15 CPU's?

Is there any bench marking for such scenarios saying...

I Right Click on the Instance --> Properties -->

goto Connections tab and under Remote server connections

i checked the Allow other SQL Servers to connect remotely to this SQL...

Thank You!

I right click the properties of the sql 2000 instance and tried to make changes in the DATABASE SETTINGS properties tab,

and Processor tab but the changes are not being into...

oh Thanks for the correction.

What all are the pre-cautionary things we need to take before we edit the boot.ini for adding the switches.

[boot loader]

timeout=30

default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS

[operating systems]

multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /PAE

Is there any...

Jim , how can we know or determine about parallelism is being used ?

This,...

Hi,

Thanks for the suggestions.

You did say that you have the /PAE switch in the boot.ini file on but I do not see it in your printout. You need to...

Thanks a lot!

Thanks Dude!

Thanks So much. That is what am try to do. Thanks for the suggestions.

Thank You!

Thanks Gila!

SELECT distinct object_name(object_id) as ObjName,

--name AS stats_name,

STATS_DATE(object_id, stats_id) AS statistics_update_date

FROM sys.stats

where OBJECTPROPERTY(object_id,'IsUserTable')=1

Thanks Friend!