-
Poor Performance right after installing
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" 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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|