|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Slow performanceI 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 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 -- Show quoteHide quoteAndrew J. Kelly SQL MVP "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  
Other interesting topics
Cannot connect to remote SQL 2k5 server in local network
Sql Server 2005 Management Console Connect to Sql Server 2000? Connecting to another SQL SErver Linked server in sql 2005, Oracle and DB2 Error 2571 - not permission to run DBCC TRACEON Database Mirroring and Backup SQL Express - Cut features Can not connect to SQL Server Expected LSN of a standby DB Encrypting Credit Card details |
|||||||||||||||||||||||
