Hyperthreading

  • Hi

    Has anybody has experience (good or bad) running SQL 2K with Pentium 4 with Hyperthreading ? My SQL server was auto cold boot, few times now, under heavy transaction load.

    Thanks

  • I have 4 SQL Servers running on Quad Xeon processors with hyperthreading enabled. In the past I have had one system shutdown (found out it was bad install of SQL Server, formatted and started from scratch and has worked great ever since.)

    Another system would shutdown and restart. Bug with UDF's and SP3 fixed the problem.

    Otherwise I have had good experience. I don't know if Hyperthreading has helped or hindered my processes though.

    Do make sure you have Service Pack 3 however.



    Michelle

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply