Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    7

    Unanswered: Hyper Threadng with SQL 2000 ?

    Is it better to enable Hyper Threading on a DB machine. I am running only SQL 2000 on my machine no other service is running. I have noticed in Task Manager that in peak time when there is some load on DB one Proccesor proccesing goes to 100 % while other reamin idle or maximum go to 20 to 30 %. I want whole peoccesing for database only.

    If some one has any tips for improving database performance then please share it.

  2. #2
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    mmmmmmmmm

    Heres a good link to HyperThreading if anyones interested

    http://www.2cpu.com/articles/42_2.html

    But Beware as YOUR SERVER HARDWARE MUST SUPPORT THIS NEW Technology

    and as Intel say

    Performance will vary depending on the specific hardware and software you use. but could provide a performance increase in the neighborhood of 10-30%, depending on the application and the situation

    If your really interested you could set up 2 test machines and try it but IMHO.... I think your barking up the wrong tree as far as Twin/Quad CPU Usage balancing is concerned.

    As far as tips for improving database performance try

    Higher Spec Hardware & more RAM,
    Transaction file physically stored on a seperate Hard Disk away from the RAID Array of the Data File,
    Tune Indexes & tweak sloppy Querys etc....etc...etc....etc...etc....etc...etc....etc. ..

    GW
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

  3. #3
    Join Date
    Sep 2003
    Posts
    364
    The most important thing I've read is to limit the max degreee of parallelism to the number of physical processors when using HT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •