Hi everybody,

We´ve just installed 2 SQL Servers on 2 different machines:

1.
- SQL 6.5 with SP5a installed on D:
- HP NetServer E45
- 192 MB RAM
- Pentium II 233
- U2W Disks
- Win NT 4 with SP4

2.
- SQL 7.0 installed on D:
- HP Netserver LD Pro
- Pentium Pro 166
- 256 MB RAM
- 4,2 GB HP SCSI Platte HOT SWAP
- Adaptec 2940
- C: 1,5 GB FAT
- D: 2,7 GB NTFS
- WIN NT 4.0 Server SP4


Both Servers react EXTREMELY slow ("feels like glue&#34 even without any user-dbs installed on.

A simple JOIN on the pubs-db

SELECT * from title, titleauthor, employee

takes MINUTES.


The same JOIN on a third SQL 6.5-Server, installed on a
no-name-we´ll-use-this-as-a-test-server Pentium 133 (with less RAM)
is done in less than 40 seconds.

All three host NOTHING more than the pubs-db.
Configuration is left default except (of course) memory.
Tempdbs had no effect.

Anyone got any idea?
I`ve already checked the articles on the MS support sites,
but we have definitely checked memory configurations.

Thanx very much in advance for help,

Juergen