Slow performance

19 Jan 2006 3:42 PM

SQLScott

I heard somewhere that hyper-threading should be turned off for SQL Server
2005 for performance reasons. I cannot find any documentation anywhere to
support this but I'm seeing some really poor performance when I am hitting
SQL 2005 pretty hard.

Can anyone point me to some information on this?

--
Thanks,

Scott

19 Jan 2006 5:40 PM

Andrew J. Kelly

This should answer your questions on HT.

http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx

These may be helpful as well:

http://www.sql-server-performance.com/sql_server_performance_audit10.asp
Performance Audit
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/operations.mspx
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp   Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=224587       Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
http://sqldev.net/misc/WaitTypes.htm            Wait Types

--
Andrew J. Kelly SQL MVP

Show quoteHide quote

"SQLScott" <SQLSc***@discussions.microsoft.com> wrote in message
news:06F7AB3F-2224-4F8C-99A6-5751674B9D4E@microsoft.com...
>I heard somewhere that hyper-threading should be turned off for SQL Server
> 2005 for performance reasons. I cannot find any documentation anywhere to
> support this but I'm seeing some really poor performance when I am hitting
> SQL 2005 pretty hard.
>
> Can anyone point me to some information on this?
> --
> Thanks,
>
> Scott