Dual Processors/Dedicated Server

[JohnieR]

Using SQL 2000 on a W2000 Web server with 1512MB RAM and a Pentium III 933MHz single processor, searching a specific field of the 1.4 million-record database presents results in from 8 seconds (where each field cell contains just a short alphanumeric string) to timeout after 70 seconds (where each field cell comprises a dozen or more words).

I'm considering replacing the existing CPU with twin 1.8MHz Pentium IVs. Does anyone have any experience of the improvement achieved by CPU upgrading? Thanks in advance.

 

[RickCole]

Have you tried using indexs on the table and fields you are querying first.

Rick.

 

[foxdev]

I think first you'd want to look at Performance Monitor to see if the query is CPU-bound or disk I/O-bound.

What is your disk setup? How many physical disks, and in what configuration? -----------------
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:

http://www.lowcostprints.com

http://www.foxdev.com

 

[fluteplr]

Also can you show us the query strings. If (as I suspect) the query you are doing 'each field cell comprises a dozen or more words' looks something like

select * from mytable where myfile like '%someword%'

you can add processor speed and indexes till you are blue in the face and it is not going to help. You will either need to redesign your database with a childtable of keywords or look at the fulltext indexing system.

 

[sguslan]

Also, are you using an IDE/EIDE hard disk instead of SCSI disks with a RAID 0 or RAID 5 ?
Use SCSI drives, and of course the best is a fiber channel attached storage subsystem[terribly expensive]. Even more, the speed of the hard drives will make a difference. If you can get 10000 or 15000 RPM SCSI drives then use them.

Good luck
Salim