Re: Hyperthreading
From: Gert E.R. Drapers (GertD_at_SQLDev.Net)
Date: 09/15/04
- Next message: krs: "Keeping an audit trail"
- Previous message: Jacco Schalkwijk: "Re: Using OPENROWSET and fileds order..."
- In reply to: derrickleggett_at_hotmail.com: "Hyperthreading"
- Next in thread: MeanOldDBA: "Re: Hyperthreading"
- Reply: MeanOldDBA: "Re: Hyperthreading"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 15 Sep 2004 11:55:18 +0200
Can you please post a link to the article / discussion so I can read the
original posting, this seems either not to contain enough information to
make any recommendation or it is taken out of context. It sounds really
weird to me, we are using hyperthreaded machines at lots of places without a
problem, as long as you are using Windows Server 2003 and not Windows 2000
or even worse NT 4.0
GertD@SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"MeanOldDBA (derrickleggett@hotmail.com)" <MeanOldDBA
(derrickleggett@hotmail.com)@discussions.microsoft.com> wrote in message
news:5F72525E-C851-4B8E-9404-F745FC07A690@microsoft.com...
> We just had this posted on www.sql-server-performance.com . I was
> wondering
> if a Microsoft engineer or SQL Server expert would mind commenting on it.
>
> The Question: Parallelism Must Be Set To Automatic to get full advantage
> of
> SQL Server 2000.
>
> SQL Server 2000 cannot use Parallel Query Processing, this is an
> unofficial
> bug, not confirmed and by doing this the queries (transactions) proceeds
> without any delay or errors will not occur.
>
> So the recommendation is to run the Transact SQL script below or use the
> Enterprise Manager.
>
> sp_configure 'show advanced options', 1
> GO
> RECONFIGURE
> GO
> sp_configure 'max degree of parallelism', 1
> GO
> RECONFIGURE
> GO
>
>
> Please post if this solved your problem?
>
>
> BooksOnline:
> Parallel Query Processing
> max degree of parallelism Option
> Setting Configuration Options
> How to configure the cost threshold for parallelism
>
> Best Regards
> - Member of The Professional Association for SQL Server, SQLPASS Denmark -
> - Stability instead of incremental improvements -
- Next message: krs: "Keeping an audit trail"
- Previous message: Jacco Schalkwijk: "Re: Using OPENROWSET and fileds order..."
- In reply to: derrickleggett_at_hotmail.com: "Hyperthreading"
- Next in thread: MeanOldDBA: "Re: Hyperthreading"
- Reply: MeanOldDBA: "Re: Hyperthreading"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
