I'm trying to setup replication from an external web server to internal sql
box. The internal box with do a pull subscription to external webbox. I ran
snapshot and all works successfully. As soon as I try to run Pull
subscription, I get an error a Collation Conflict on a table. I tweaked the
settings and copy the collation to destination in the publication properties
tab. This runs but gives me the following:
Error Message: Cannot resolve collation conflict for equal to operation.
Error Detail: Cannot resolve collation conflict for equal to operation.
(Source: WIN2K3 (Data source); Error number: 446)
ANy ideas on how to correct this?
Thanks in Advance
Rob
Is there anything odd about the particular table you are having a problem
with? Could you post its schema here? What sort of content is inside this
table?
Also it sounds like you are doing filtering. Are you?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:18B8B552-CC29-4F84-B073-34FF3FF6BBED@.microsoft.com...
> I'm trying to setup replication from an external web server to internal
> sql
> box. The internal box with do a pull subscription to external webbox. I
> ran
> snapshot and all works successfully. As soon as I try to run Pull
> subscription, I get an error a Collation Conflict on a table. I tweaked
> the
> settings and copy the collation to destination in the publication
> properties
> tab. This runs but gives me the following:
> Error Message: Cannot resolve collation conflict for equal to operation.
> Error Detail: Cannot resolve collation conflict for equal to operation.
> (Source: WIN2K3 (Data source); Error number: 446)
> ANy ideas on how to correct this?
> Thanks in Advance
> Rob
>
|||No filtering, straight snapshot. Nothing odd about the table or its data.
Its a third
party program so I cannot change the table structure.
Heres the table setup.
CREATE TABLE [TABLE1] (
[nm_entity] [varchar] (30) COLLATE Latin1_General_BIN NOT NULL ,
[no_next_internal_id] [int] NOT NULL ,
[no_next_parameter_id] [int] NULL ,
[no_next_code_suffix] [int] NULL ,
CONSTRAINT [Table1_PK] PRIMARY KEY CLUSTERED
(
[nm_entity]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
When SQL creates snapshot this is the table structure on the
pull subscriber:
CREATE TABLE [THINQ_ID_MANAGER] (
[nm_entity] [varchar] (30) COLLATE Latin1_General_BIN NOT NULL ,
[no_next_internal_id] [int] NOT NULL ,
[no_next_parameter_id] [int] NULL ,
[no_next_code_suffix] [int] NULL
) ON [PRIMARY]
GO
thanks
rob
"Hilary Cotter" wrote:
> Is there anything odd about the particular table you are having a problem
> with? Could you post its schema here? What sort of content is inside this
> table?
> Also it sounds like you are doing filtering. Are you?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:18B8B552-CC29-4F84-B073-34FF3FF6BBED@.microsoft.com...
>
>
|||What is the default collation sequence on your publisher and the default
collation sequence on your subscriber?
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:4B47392D-0477-4842-9173-762D00AE5267@.microsoft.com...[vbcol=seagreen]
> No filtering, straight snapshot. Nothing odd about the table or its
> data.
> Its a third
> party program so I cannot change the table structure.
> Heres the table setup.
> CREATE TABLE [TABLE1] (
> [nm_entity] [varchar] (30) COLLATE Latin1_General_BIN NOT NULL ,
> [no_next_internal_id] [int] NOT NULL ,
> [no_next_parameter_id] [int] NULL ,
> [no_next_code_suffix] [int] NULL ,
> CONSTRAINT [Table1_PK] PRIMARY KEY CLUSTERED
> (
> [nm_entity]
> ) WITH FILLFACTOR = 90 ON [PRIMARY]
> ) ON [PRIMARY]
> When SQL creates snapshot this is the table structure on the
> pull subscriber:
> CREATE TABLE [THINQ_ID_MANAGER] (
> [nm_entity] [varchar] (30) COLLATE Latin1_General_BIN NOT NULL ,
> [no_next_internal_id] [int] NOT NULL ,
> [no_next_parameter_id] [int] NULL ,
> [no_next_code_suffix] [int] NULL
> ) ON [PRIMARY]
> GO
> thanks
> rob
>
>
> "Hilary Cotter" wrote:
Showing posts with label box. Show all posts
Showing posts with label box. Show all posts
Thursday, March 22, 2012
Monday, March 19, 2012
Collapsing groups while toggling intteractive sort
Hi all
i have a table with grouping by the first column.
the details section is hidden and can be expanded by the group box (with +).
i have interactive sort based on the second column.
While toggling the interactive sort button the expanded field being colappsed.
Is there any option for keeping the expanded rows in their state?
THank You
No, currently toggling interactive sort would reset the show/hide state. Changing this behavior is on our wish list for a future release.Wednesday, March 7, 2012
Code Box
I want to set a variable so i'll know if I printed census information
already so that I can suppress it later. something on the order of the
function below. I"m getting an error "Reference to a non-shared member
requires an object reference". I'm not sure if I need to passs theobject in
or how to reference it. any help is appreciated.
Public Function PrintCensus( ) As Integer
if Parameters!PrintCensus.Value = 0 Then
Parameters!PrintCensus.Value = 0
Return 0
end if
return 1
End Functioni aplogize for the double post - waited so long for this to show up i assumed
that I had clicked close instead
"Peter Feakins" wrote:
> I want to set a variable so i'll know if I printed census information
> already so that I can suppress it later. something on the order of the
> function below. I"m getting an error "Reference to a non-shared member
> requires an object reference". I'm not sure if I need to passs theobject in
> or how to reference it. any help is appreciated.
> Public Function PrintCensus( ) As Integer
> if Parameters!PrintCensus.Value = 0 Then
> Parameters!PrintCensus.Value = 0
> Return 0
> end if
> return 1
> End Function|||On Jan 22, 8:32 pm, Peter Feakins
<PeterFeak...@.discussions.microsoft.com> wrote:
> i aplogize for the double post - waited so long for this to show up i assumed
> that I had clicked close instead
> "Peter Feakins" wrote:
> > I want to set a variable so i'll know if I printed census information
> > already so that I can suppress it later. something on the order of the
> > function below. I"m getting an error "Reference to a non-shared member
> > requires an object reference". I'm not sure if I need to passs theobject in
> > or how to reference it. any help is appreciated.
> > Public Function PrintCensus( ) As Integer
> > if Parameters!PrintCensus.Value = 0 Then
> > Parameters!PrintCensus.Value = 0
> > Return 0
> > end if
> > return 1
> > End Function
If this function is a part of the Code section of a report, you will
most likely need to pass the parameter PrintCensus ByVal to the
function. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
already so that I can suppress it later. something on the order of the
function below. I"m getting an error "Reference to a non-shared member
requires an object reference". I'm not sure if I need to passs theobject in
or how to reference it. any help is appreciated.
Public Function PrintCensus( ) As Integer
if Parameters!PrintCensus.Value = 0 Then
Parameters!PrintCensus.Value = 0
Return 0
end if
return 1
End Functioni aplogize for the double post - waited so long for this to show up i assumed
that I had clicked close instead
"Peter Feakins" wrote:
> I want to set a variable so i'll know if I printed census information
> already so that I can suppress it later. something on the order of the
> function below. I"m getting an error "Reference to a non-shared member
> requires an object reference". I'm not sure if I need to passs theobject in
> or how to reference it. any help is appreciated.
> Public Function PrintCensus( ) As Integer
> if Parameters!PrintCensus.Value = 0 Then
> Parameters!PrintCensus.Value = 0
> Return 0
> end if
> return 1
> End Function|||On Jan 22, 8:32 pm, Peter Feakins
<PeterFeak...@.discussions.microsoft.com> wrote:
> i aplogize for the double post - waited so long for this to show up i assumed
> that I had clicked close instead
> "Peter Feakins" wrote:
> > I want to set a variable so i'll know if I printed census information
> > already so that I can suppress it later. something on the order of the
> > function below. I"m getting an error "Reference to a non-shared member
> > requires an object reference". I'm not sure if I need to passs theobject in
> > or how to reference it. any help is appreciated.
> > Public Function PrintCensus( ) As Integer
> > if Parameters!PrintCensus.Value = 0 Then
> > Parameters!PrintCensus.Value = 0
> > Return 0
> > end if
> > return 1
> > End Function
If this function is a part of the Code section of a report, you will
most likely need to pass the parameter PrintCensus ByVal to the
function. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
Saturday, February 25, 2012
CmdExec job failed
Hi,
I created a job on sql server 2000, using the Operating System Command
option, under the command box, I inserted the command cmd /C
e:\docs\extracts\scripts\make_asal.bat, but when I try to run it, I get this
error message Executed as user:SEFDBA\sqlseragent.
'e:\docs\extracts\scripts\make_asal.bat' is not recognized as an internal or
external command, operable program or batch file. Process Exit Code 1.
The step failed. Please help, what am I doing wrong? Thanks.
New SQL Server DBA
Check the path and .bat file spelling? Type the exact same thing in from a
CMD prompt and see if it works.
HTH
Jerry
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:50ECA2ED-CAD2-4077-9C6F-BB606D4951F4@.microsoft.com...
> Hi,
> I created a job on sql server 2000, using the Operating System Command
> option, under the command box, I inserted the command cmd /C
> e:\docs\extracts\scripts\make_asal.bat, but when I try to run it, I get
> this
> error message Executed as user:SEFDBA\sqlseragent.
> 'e:\docs\extracts\scripts\make_asal.bat' is not recognized as an internal
> or
> external command, operable program or batch file. Process Exit Code 1.
> The step failed. Please help, what am I doing wrong? Thanks.
> --
> New SQL Server DBA
I created a job on sql server 2000, using the Operating System Command
option, under the command box, I inserted the command cmd /C
e:\docs\extracts\scripts\make_asal.bat, but when I try to run it, I get this
error message Executed as user:SEFDBA\sqlseragent.
'e:\docs\extracts\scripts\make_asal.bat' is not recognized as an internal or
external command, operable program or batch file. Process Exit Code 1.
The step failed. Please help, what am I doing wrong? Thanks.
New SQL Server DBA
Check the path and .bat file spelling? Type the exact same thing in from a
CMD prompt and see if it works.
HTH
Jerry
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:50ECA2ED-CAD2-4077-9C6F-BB606D4951F4@.microsoft.com...
> Hi,
> I created a job on sql server 2000, using the Operating System Command
> option, under the command box, I inserted the command cmd /C
> e:\docs\extracts\scripts\make_asal.bat, but when I try to run it, I get
> this
> error message Executed as user:SEFDBA\sqlseragent.
> 'e:\docs\extracts\scripts\make_asal.bat' is not recognized as an internal
> or
> external command, operable program or batch file. Process Exit Code 1.
> The step failed. Please help, what am I doing wrong? Thanks.
> --
> New SQL Server DBA
CmdExec job failed
Hi,
I created a job on sql server 2000, using the Operating System Command
option, under the command box, I inserted the command cmd /C
e:\docs\extracts\scripts\make_asal.bat, but when I try to run it, I get this
error message Executed as user:SEFDBA\sqlseragent.
'e:\docs\extracts\scripts\make_asal.bat' is not recognized as an internal or
external command, operable program or batch file. Process Exit Code 1.
The step failed. Please help, what am I doing wrong? Thanks.
--
New SQL Server DBACheck the path and .bat file spelling? Type the exact same thing in from a
CMD prompt and see if it works.
HTH
Jerry
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:50ECA2ED-CAD2-4077-9C6F-BB606D4951F4@.microsoft.com...
> Hi,
> I created a job on sql server 2000, using the Operating System Command
> option, under the command box, I inserted the command cmd /C
> e:\docs\extracts\scripts\make_asal.bat, but when I try to run it, I get
> this
> error message Executed as user:SEFDBA\sqlseragent.
> 'e:\docs\extracts\scripts\make_asal.bat' is not recognized as an internal
> or
> external command, operable program or batch file. Process Exit Code 1.
> The step failed. Please help, what am I doing wrong? Thanks.
> --
> New SQL Server DBA
I created a job on sql server 2000, using the Operating System Command
option, under the command box, I inserted the command cmd /C
e:\docs\extracts\scripts\make_asal.bat, but when I try to run it, I get this
error message Executed as user:SEFDBA\sqlseragent.
'e:\docs\extracts\scripts\make_asal.bat' is not recognized as an internal or
external command, operable program or batch file. Process Exit Code 1.
The step failed. Please help, what am I doing wrong? Thanks.
--
New SQL Server DBACheck the path and .bat file spelling? Type the exact same thing in from a
CMD prompt and see if it works.
HTH
Jerry
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:50ECA2ED-CAD2-4077-9C6F-BB606D4951F4@.microsoft.com...
> Hi,
> I created a job on sql server 2000, using the Operating System Command
> option, under the command box, I inserted the command cmd /C
> e:\docs\extracts\scripts\make_asal.bat, but when I try to run it, I get
> this
> error message Executed as user:SEFDBA\sqlseragent.
> 'e:\docs\extracts\scripts\make_asal.bat' is not recognized as an internal
> or
> external command, operable program or batch file. Process Exit Code 1.
> The step failed. Please help, what am I doing wrong? Thanks.
> --
> New SQL Server DBA
CmdExec job failed
Hi,
I created a job on sql server 2000, using the Operating System Command
option, under the command box, I inserted the command cmd /C
e:\docs\extracts\scripts\make_asal.bat, but when I try to run it, I get this
error message Executed as user:SEFDBA\sqlseragent.
'e:\docs\extracts\scripts\make_asal.bat' is not recognized as an internal or
external command, operable program or batch file. Process Exit Code 1.
The step failed. Please help, what am I doing wrong? Thanks.
--
New SQL Server DBACheck the path and .bat file spelling? Type the exact same thing in from a
CMD prompt and see if it works.
HTH
Jerry
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:50ECA2ED-CAD2-4077-9C6F-BB606D4951F4@.microsoft.com...
> Hi,
> I created a job on sql server 2000, using the Operating System Command
> option, under the command box, I inserted the command cmd /C
> e:\docs\extracts\scripts\make_asal.bat, but when I try to run it, I get
> this
> error message Executed as user:SEFDBA\sqlseragent.
> 'e:\docs\extracts\scripts\make_asal.bat' is not recognized as an internal
> or
> external command, operable program or batch file. Process Exit Code 1.
> The step failed. Please help, what am I doing wrong? Thanks.
> --
> New SQL Server DBA
I created a job on sql server 2000, using the Operating System Command
option, under the command box, I inserted the command cmd /C
e:\docs\extracts\scripts\make_asal.bat, but when I try to run it, I get this
error message Executed as user:SEFDBA\sqlseragent.
'e:\docs\extracts\scripts\make_asal.bat' is not recognized as an internal or
external command, operable program or batch file. Process Exit Code 1.
The step failed. Please help, what am I doing wrong? Thanks.
--
New SQL Server DBACheck the path and .bat file spelling? Type the exact same thing in from a
CMD prompt and see if it works.
HTH
Jerry
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:50ECA2ED-CAD2-4077-9C6F-BB606D4951F4@.microsoft.com...
> Hi,
> I created a job on sql server 2000, using the Operating System Command
> option, under the command box, I inserted the command cmd /C
> e:\docs\extracts\scripts\make_asal.bat, but when I try to run it, I get
> this
> error message Executed as user:SEFDBA\sqlseragent.
> 'e:\docs\extracts\scripts\make_asal.bat' is not recognized as an internal
> or
> external command, operable program or batch file. Process Exit Code 1.
> The step failed. Please help, what am I doing wrong? Thanks.
> --
> New SQL Server DBA
Friday, February 24, 2012
Clustering, sending mail from SQL Server in a cluster
We consolidated sending SQL Server mail from one box in our enterprise,
which has worked out well for us. Now we'd like to consolidate
servers/databases and put it under a clustered environment. But how do we
handle the mail ?
Thanx.
-Cqlboy
Try xpsmtp from www.sqldev.net. It isn't a seamless drop-in, but it is a
lot easier to handle than Outlook on a cluster node. It IS a very stable
component.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cqlboy" <Cqlboy@.discussions.microsoft.com> wrote in message
news:CC3E45B3-D309-49A9-95D0-0B05C9541665@.microsoft.com...
> We consolidated sending SQL Server mail from one box in our enterprise,
> which has worked out well for us. Now we'd like to consolidate
> servers/databases and put it under a clustered environment. But how do we
> handle the mail ?
> Thanx.
> -Cqlboy
|||Or you could try this if you have iis smtp server installed on the box.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23hk$d6k%23EHA.3756@.TK2MSFTNGP14.phx.gbl...
> Try xpsmtp from www.sqldev.net. It isn't a seamless drop-in, but it is a
> lot easier to handle than Outlook on a cluster node. It IS a very stable
> component.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Cqlboy" <Cqlboy@.discussions.microsoft.com> wrote in message
> news:CC3E45B3-D309-49A9-95D0-0B05C9541665@.microsoft.com...
>
begin 666 sp_SendCDONTSEmail.sql
M04Q415(@.4%)/0T5$55)%('-P7U-E;F1#1$].5%-%;6%I; T*0$9R;VT@.=F%R
M8VAA<B@.Q,# I+ T*0%1O('9A<F-H87(H,3 P,"DL#0I 0T,@.=F%R8VAA<B@.Q
M,# P*2 ]("<G+ T*0$)#0R!V87)C:&%R*#$P,# I/2 G)RP-"D!3=6)J96-T
M('9A<F-H87(H,3 P,"D]("<G+ T*0$)O9'D@.=F%R8VAA<B@.T,# P*3TG)RP-
M"D!!='1A8VA0871H('9A<F-H87(H,3 P*3TG)RP-"D!!='1A8VA.86UE('9A
M<F-H87(H,3 P*3TG)PT*#0I!4PT*#0I$14-,05)%($!#1$].5%,@.:6YT#0I$
M14-,05)%($!H<B!I;G0-"D1%0TQ!4D4@.0%)E='9A;"!I;G0-"D1%0TQ!4D4@.
M0'-O=7)C92!V87)C:&%R*#,P*2 -"D1%0TQ!4D4@.0&1E<V,@.=F%R8VAA<B@.R
M,# I#0H-"D5814,@.0&AR/7-P7T]!0W)E871E(")#1$].5%,N3F5W36%I;"(L
M($!#1$].5%,@.3U54#0H@.(" @.248@.0&AR(#P^(# @.1T]43R!%<G(-"@.T*15A%
M0R! :'(@./2!S<%]/05-E=%!R;W!E<G1Y($!#1$].5%,L("=-86EL1F]R;6%T
M)RP@., T*(" @.($E&($!H<B \/B P($=/5$\@.17)R#0H-"D5814,@.0&AR(#T@.
M<W!?3T%39710<F]P97)T>2! 0T1/3E13+" G1G)O;2<L($!&<F]M#0H@.(" @.
M248@.0&AR(#P^(# @.1T]43R!%<G(-"@.T*15A%0R! :'(@./2!S<%]/05-E=%!R
M;W!E<G1Y($!#1$].5%,L("=4;R<L($!4;PT*(" @.($E&($!H<B \/B P($=/
M5$\@.17)R#0H-"D5814,@.0&AR(#T@.<W!?3T%39710<F]P97)T>2! 0T1/3E13
M+" G0V,G+"! 0T,-"B @.("!)1B! :'(@./#X@.,"!'3U1/($5R<@.T*#0I%6$5#
M($!H<B ]('-P7T]!4V5T4')O<&5R='D@.0$-$3TY44RP@.)T)C8R<L($!"0T,-
M"B @.("!)1B! :'(@./#X@.,"!'3U1/($5R<@.T*#0I%6$5#($!H<B ]('-P7T]!
M4V5T4')O<&5R='D@.0$-$3TY44RP@.)U-U8FIE8W0G+"! 4W5B:F5C= T*(" @.
M($E&($!H<B \/B P($=/5$\@.17)R#0H-"D5814,@.0&AR(#T@.<W!?3T%39710
M<F]P97)T>2! 0T1/3E13+" G0F]D>2<L($!";V1Y#0H@.(" @.248@.0&AR(#P^
M(# @.1T]43R!%<G(-"@.T*248@.0$%T=&%C:%!A=&@.@./#X@.)R<@.#0H)0D5'24X-
M"@.E04DE.5"! 071T86-H4&%T: T*+2T)15A%0R! :'(]<W!?3T%-971H;V0@.
M0$-$3TY44RP@.(D%T=&%C:$9I;&4B("P@.0$%T=&%C:%!A=&@.@.3U54( "P@.0$%T
M=&%C:$YA;64@.3U54#0H)15A%0R! :'(]<W!?3T%-971H;V0@.0$-$3TY44RP@.
M(D%T=&%C:$9I;&4B("P@.3E5,3"P@.($!3;W5R8V4]0$%T=&%C:%!A=&@.@.3U54
M("P@.0$9I;&5.86UE/4!!='1A8VA.86UE($]55 T*"4E&($!H<B \/B P($=/
M5$\@.17)R#0H)14Y$#0I%6$5#($!H<CUS<%]/04UE=&AO9"! 0T1/3E13+" B
M4V5N9"(-"B @.("!)1B! :'(@./#X@.,"!'3U1/($5R<@.T*#0I'3U1/($1O;F4-
M"B @.(" -"D5R<CH-"B @.("!204E315)23U(@.*"=%<G)O<B!S96YD:6YG(&5M
M86EL('5S:6YG(&-D;VYT<RX@.)RP@.,38L(#$I#0H@.(" @.15A%0R!S<%]/04=E
M=$5R<F]R26YF;R!.54Q,+"! <V]U<F-E($]55"P@.0&1E<V,@.3U54#0H@.(" @.
M4T5,14-4(&AR/4-/3E9%4E0H0DE.05)9*#0I("Q :'(I+"!S;W5R8V4]0'-O
M=7)C92P-"B @.(" @.(" @.9&5S8W)I<'1I;VX]0&1E<V,-"@.T*1&]N93H@.(" @.
E#0H@.(" @.15A%0R!S<%]/041E<W1R;WD@.0$-$3TY44PT*1T\-"@.``
`
end
|||IIS on a SQL cluster host? Not my ideal setup.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steve Woodhams" <stevew@.globalnet.co.uk> wrote in message
news:7tidnZ2tgt39cXrcRVnyig@.brightview.com...[vbcol=seagreen]
> Or you could try this if you have iis smtp server installed on the box.
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:%23hk$d6k%23EHA.3756@.TK2MSFTNGP14.phx.gbl...
a[vbcol=seagreen]
stable
>
>
|||Rather have iis than use outlook. Anyway our final solution was to just have
a send email stored procedure that writes to a table. We then have a .net
service that just reads the table and sends the emails from another box
using cdonts.
Shout if you want the source.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23kMCyJl%23EHA.2156@.TK2MSFTNGP10.phx.gbl...
> IIS on a SQL cluster host? Not my ideal setup.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Steve Woodhams" <stevew@.globalnet.co.uk> wrote in message
> news:7tidnZ2tgt39cXrcRVnyig@.brightview.com...
> a
> stable
>
|||Greg Linwood wrote a series of articles on how to build an asynchronous
email system around xpsmtp. I would probably go with that if I needed
anything more sophisticated than what I built.
Thanks,
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steve Woodhams" <stevew@.globalnet.co.uk> wrote in message
news:09OdnfD8y5d7cnrcRVnyiQ@.brightview.com...
> Rather have iis than use outlook. Anyway our final solution was to just
have[vbcol=seagreen]
> a send email stored procedure that writes to a table. We then have a .net
> service that just reads the table and sends the emails from another box
> using cdonts.
> Shout if you want the source.
>
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:%23kMCyJl%23EHA.2156@.TK2MSFTNGP10.phx.gbl...
is
>
|||"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23kMCyJl%23EHA.2156@.TK2MSFTNGP10.phx.gbl...
> IIS on a SQL cluster host? Not my ideal setup.
>
Actually this is exactly what we do. But not the way you're thinking.
We use xp_sendmail quite a bit (mostly because it's so convenient for
scheduled tasks to use it.)
Then we use the SMTP component only (no web, ftp services) of IIS on the
same box and point the Outlook client to that. That prevents it from
locking up due to Outlook timing out due to the SMTP server not being
available.
Then of course the SQL server is completely firewalled off from the outside
world, so no one can connect to any ports on it.
Since I've done this and installed SP3a I don't think I've had a single
issue with SQL Mail. Oh, and this is on a cluster that's failed over at
least once.
[vbcol=seagreen]
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Steve Woodhams" <stevew@.globalnet.co.uk> wrote in message
> news:7tidnZ2tgt39cXrcRVnyig@.brightview.com...
is[vbcol=seagreen]
> a
> stable
enterprise,[vbcol=seagreen]
do
>
which has worked out well for us. Now we'd like to consolidate
servers/databases and put it under a clustered environment. But how do we
handle the mail ?
Thanx.
-Cqlboy
Try xpsmtp from www.sqldev.net. It isn't a seamless drop-in, but it is a
lot easier to handle than Outlook on a cluster node. It IS a very stable
component.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cqlboy" <Cqlboy@.discussions.microsoft.com> wrote in message
news:CC3E45B3-D309-49A9-95D0-0B05C9541665@.microsoft.com...
> We consolidated sending SQL Server mail from one box in our enterprise,
> which has worked out well for us. Now we'd like to consolidate
> servers/databases and put it under a clustered environment. But how do we
> handle the mail ?
> Thanx.
> -Cqlboy
|||Or you could try this if you have iis smtp server installed on the box.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23hk$d6k%23EHA.3756@.TK2MSFTNGP14.phx.gbl...
> Try xpsmtp from www.sqldev.net. It isn't a seamless drop-in, but it is a
> lot easier to handle than Outlook on a cluster node. It IS a very stable
> component.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Cqlboy" <Cqlboy@.discussions.microsoft.com> wrote in message
> news:CC3E45B3-D309-49A9-95D0-0B05C9541665@.microsoft.com...
>
begin 666 sp_SendCDONTSEmail.sql
M04Q415(@.4%)/0T5$55)%('-P7U-E;F1#1$].5%-%;6%I; T*0$9R;VT@.=F%R
M8VAA<B@.Q,# I+ T*0%1O('9A<F-H87(H,3 P,"DL#0I 0T,@.=F%R8VAA<B@.Q
M,# P*2 ]("<G+ T*0$)#0R!V87)C:&%R*#$P,# I/2 G)RP-"D!3=6)J96-T
M('9A<F-H87(H,3 P,"D]("<G+ T*0$)O9'D@.=F%R8VAA<B@.T,# P*3TG)RP-
M"D!!='1A8VA0871H('9A<F-H87(H,3 P*3TG)RP-"D!!='1A8VA.86UE('9A
M<F-H87(H,3 P*3TG)PT*#0I!4PT*#0I$14-,05)%($!#1$].5%,@.:6YT#0I$
M14-,05)%($!H<B!I;G0-"D1%0TQ!4D4@.0%)E='9A;"!I;G0-"D1%0TQ!4D4@.
M0'-O=7)C92!V87)C:&%R*#,P*2 -"D1%0TQ!4D4@.0&1E<V,@.=F%R8VAA<B@.R
M,# I#0H-"D5814,@.0&AR/7-P7T]!0W)E871E(")#1$].5%,N3F5W36%I;"(L
M($!#1$].5%,@.3U54#0H@.(" @.248@.0&AR(#P^(# @.1T]43R!%<G(-"@.T*15A%
M0R! :'(@./2!S<%]/05-E=%!R;W!E<G1Y($!#1$].5%,L("=-86EL1F]R;6%T
M)RP@., T*(" @.($E&($!H<B \/B P($=/5$\@.17)R#0H-"D5814,@.0&AR(#T@.
M<W!?3T%39710<F]P97)T>2! 0T1/3E13+" G1G)O;2<L($!&<F]M#0H@.(" @.
M248@.0&AR(#P^(# @.1T]43R!%<G(-"@.T*15A%0R! :'(@./2!S<%]/05-E=%!R
M;W!E<G1Y($!#1$].5%,L("=4;R<L($!4;PT*(" @.($E&($!H<B \/B P($=/
M5$\@.17)R#0H-"D5814,@.0&AR(#T@.<W!?3T%39710<F]P97)T>2! 0T1/3E13
M+" G0V,G+"! 0T,-"B @.("!)1B! :'(@./#X@.,"!'3U1/($5R<@.T*#0I%6$5#
M($!H<B ]('-P7T]!4V5T4')O<&5R='D@.0$-$3TY44RP@.)T)C8R<L($!"0T,-
M"B @.("!)1B! :'(@./#X@.,"!'3U1/($5R<@.T*#0I%6$5#($!H<B ]('-P7T]!
M4V5T4')O<&5R='D@.0$-$3TY44RP@.)U-U8FIE8W0G+"! 4W5B:F5C= T*(" @.
M($E&($!H<B \/B P($=/5$\@.17)R#0H-"D5814,@.0&AR(#T@.<W!?3T%39710
M<F]P97)T>2! 0T1/3E13+" G0F]D>2<L($!";V1Y#0H@.(" @.248@.0&AR(#P^
M(# @.1T]43R!%<G(-"@.T*248@.0$%T=&%C:%!A=&@.@./#X@.)R<@.#0H)0D5'24X-
M"@.E04DE.5"! 071T86-H4&%T: T*+2T)15A%0R! :'(]<W!?3T%-971H;V0@.
M0$-$3TY44RP@.(D%T=&%C:$9I;&4B("P@.0$%T=&%C:%!A=&@.@.3U54( "P@.0$%T
M=&%C:$YA;64@.3U54#0H)15A%0R! :'(]<W!?3T%-971H;V0@.0$-$3TY44RP@.
M(D%T=&%C:$9I;&4B("P@.3E5,3"P@.($!3;W5R8V4]0$%T=&%C:%!A=&@.@.3U54
M("P@.0$9I;&5.86UE/4!!='1A8VA.86UE($]55 T*"4E&($!H<B \/B P($=/
M5$\@.17)R#0H)14Y$#0I%6$5#($!H<CUS<%]/04UE=&AO9"! 0T1/3E13+" B
M4V5N9"(-"B @.("!)1B! :'(@./#X@.,"!'3U1/($5R<@.T*#0I'3U1/($1O;F4-
M"B @.(" -"D5R<CH-"B @.("!204E315)23U(@.*"=%<G)O<B!S96YD:6YG(&5M
M86EL('5S:6YG(&-D;VYT<RX@.)RP@.,38L(#$I#0H@.(" @.15A%0R!S<%]/04=E
M=$5R<F]R26YF;R!.54Q,+"! <V]U<F-E($]55"P@.0&1E<V,@.3U54#0H@.(" @.
M4T5,14-4(&AR/4-/3E9%4E0H0DE.05)9*#0I("Q :'(I+"!S;W5R8V4]0'-O
M=7)C92P-"B @.(" @.(" @.9&5S8W)I<'1I;VX]0&1E<V,-"@.T*1&]N93H@.(" @.
E#0H@.(" @.15A%0R!S<%]/041E<W1R;WD@.0$-$3TY44PT*1T\-"@.``
`
end
|||IIS on a SQL cluster host? Not my ideal setup.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steve Woodhams" <stevew@.globalnet.co.uk> wrote in message
news:7tidnZ2tgt39cXrcRVnyig@.brightview.com...[vbcol=seagreen]
> Or you could try this if you have iis smtp server installed on the box.
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:%23hk$d6k%23EHA.3756@.TK2MSFTNGP14.phx.gbl...
a[vbcol=seagreen]
stable
>
>
|||Rather have iis than use outlook. Anyway our final solution was to just have
a send email stored procedure that writes to a table. We then have a .net
service that just reads the table and sends the emails from another box
using cdonts.
Shout if you want the source.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23kMCyJl%23EHA.2156@.TK2MSFTNGP10.phx.gbl...
> IIS on a SQL cluster host? Not my ideal setup.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Steve Woodhams" <stevew@.globalnet.co.uk> wrote in message
> news:7tidnZ2tgt39cXrcRVnyig@.brightview.com...
> a
> stable
>
|||Greg Linwood wrote a series of articles on how to build an asynchronous
email system around xpsmtp. I would probably go with that if I needed
anything more sophisticated than what I built.
Thanks,
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steve Woodhams" <stevew@.globalnet.co.uk> wrote in message
news:09OdnfD8y5d7cnrcRVnyiQ@.brightview.com...
> Rather have iis than use outlook. Anyway our final solution was to just
have[vbcol=seagreen]
> a send email stored procedure that writes to a table. We then have a .net
> service that just reads the table and sends the emails from another box
> using cdonts.
> Shout if you want the source.
>
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:%23kMCyJl%23EHA.2156@.TK2MSFTNGP10.phx.gbl...
is
>
|||"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23kMCyJl%23EHA.2156@.TK2MSFTNGP10.phx.gbl...
> IIS on a SQL cluster host? Not my ideal setup.
>
Actually this is exactly what we do. But not the way you're thinking.
We use xp_sendmail quite a bit (mostly because it's so convenient for
scheduled tasks to use it.)
Then we use the SMTP component only (no web, ftp services) of IIS on the
same box and point the Outlook client to that. That prevents it from
locking up due to Outlook timing out due to the SMTP server not being
available.
Then of course the SQL server is completely firewalled off from the outside
world, so no one can connect to any ports on it.
Since I've done this and installed SP3a I don't think I've had a single
issue with SQL Mail. Oh, and this is on a cluster that's failed over at
least once.
[vbcol=seagreen]
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Steve Woodhams" <stevew@.globalnet.co.uk> wrote in message
> news:7tidnZ2tgt39cXrcRVnyig@.brightview.com...
is[vbcol=seagreen]
> a
> stable
enterprise,[vbcol=seagreen]
do
>
clustering SQL 2000
Hi,
I am using vmware product and i will be creating clusterd on vmware box and
cluster sql 2000. does anyone have done that and had any issue?
It is close enough to MSCS clustering to make you think it will work. It is
different enough to drive you to drink.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
> Hi,
> I am using vmware product and i will be creating clusterd on vmware box
> and
> cluster sql 2000. does anyone have done that and had any issue?
>
|||I've used it (VMWare) to play with clustering to get a feel for the steps involved etc. I was handed
an image (two images) with the OS clustered already, but I heard that VMWare has good info on how to
set up such. For "trying it out" purposes it worked fine for me (be prepared to increase timeouts
etc).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:ON0y6R9sFHA.3188@.TK2MSFTNGP14.phx.gbl...
> It is close enough to MSCS clustering to make you think it will work. It is different enough to
> drive you to drink.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
>
|||As Geoff says it's close enough but it never works out the same.
In my case, install scenarios for applying SP4 on a SP4 and RTM (after
failure) cluster which work on VMWare don't on real hardware but it's good
enough to learn the steps.
Nik Marshall-Blank MCSD/MCDBA
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:ON0y6R9sFHA.3188@.TK2MSFTNGP14.phx.gbl...
> It is close enough to MSCS clustering to make you think it will work. It
> is different enough to drive you to drink.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
>
I am using vmware product and i will be creating clusterd on vmware box and
cluster sql 2000. does anyone have done that and had any issue?
It is close enough to MSCS clustering to make you think it will work. It is
different enough to drive you to drink.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
> Hi,
> I am using vmware product and i will be creating clusterd on vmware box
> and
> cluster sql 2000. does anyone have done that and had any issue?
>
|||I've used it (VMWare) to play with clustering to get a feel for the steps involved etc. I was handed
an image (two images) with the OS clustered already, but I heard that VMWare has good info on how to
set up such. For "trying it out" purposes it worked fine for me (be prepared to increase timeouts
etc).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:ON0y6R9sFHA.3188@.TK2MSFTNGP14.phx.gbl...
> It is close enough to MSCS clustering to make you think it will work. It is different enough to
> drive you to drink.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
>
|||As Geoff says it's close enough but it never works out the same.
In my case, install scenarios for applying SP4 on a SP4 and RTM (after
failure) cluster which work on VMWare don't on real hardware but it's good
enough to learn the steps.
Nik Marshall-Blank MCSD/MCDBA
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:ON0y6R9sFHA.3188@.TK2MSFTNGP14.phx.gbl...
> It is close enough to MSCS clustering to make you think it will work. It
> is different enough to drive you to drink.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
>
clustering SQL 2000
Hi,
I am using vmware product and i will be creating clusterd on vmware box and
cluster sql 2000. does anyone have done that and had any issue?It is close enough to MSCS clustering to make you think it will work. It is
different enough to drive you to drink.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
> Hi,
> I am using vmware product and i will be creating clusterd on vmware box
> and
> cluster sql 2000. does anyone have done that and had any issue?
>|||I've used it (VMWare) to play with clustering to get a feel for the steps involved etc. I was handed
an image (two images) with the OS clustered already, but I heard that VMWare has good info on how to
set up such. For "trying it out" purposes it worked fine for me (be prepared to increase timeouts
etc).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:ON0y6R9sFHA.3188@.TK2MSFTNGP14.phx.gbl...
> It is close enough to MSCS clustering to make you think it will work. It is different enough to
> drive you to drink.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
>> Hi,
>> I am using vmware product and i will be creating clusterd on vmware box and
>> cluster sql 2000. does anyone have done that and had any issue?
>>
>|||As Geoff says it's close enough but it never works out the same.
In my case, install scenarios for applying SP4 on a SP4 and RTM (after
failure) cluster which work on VMWare don't on real hardware but it's good
enough to learn the steps.
--
Nik Marshall-Blank MCSD/MCDBA
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:ON0y6R9sFHA.3188@.TK2MSFTNGP14.phx.gbl...
> It is close enough to MSCS clustering to make you think it will work. It
> is different enough to drive you to drink.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
>> Hi,
>> I am using vmware product and i will be creating clusterd on vmware box
>> and
>> cluster sql 2000. does anyone have done that and had any issue?
>>
>
I am using vmware product and i will be creating clusterd on vmware box and
cluster sql 2000. does anyone have done that and had any issue?It is close enough to MSCS clustering to make you think it will work. It is
different enough to drive you to drink.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
> Hi,
> I am using vmware product and i will be creating clusterd on vmware box
> and
> cluster sql 2000. does anyone have done that and had any issue?
>|||I've used it (VMWare) to play with clustering to get a feel for the steps involved etc. I was handed
an image (two images) with the OS clustered already, but I heard that VMWare has good info on how to
set up such. For "trying it out" purposes it worked fine for me (be prepared to increase timeouts
etc).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:ON0y6R9sFHA.3188@.TK2MSFTNGP14.phx.gbl...
> It is close enough to MSCS clustering to make you think it will work. It is different enough to
> drive you to drink.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
>> Hi,
>> I am using vmware product and i will be creating clusterd on vmware box and
>> cluster sql 2000. does anyone have done that and had any issue?
>>
>|||As Geoff says it's close enough but it never works out the same.
In my case, install scenarios for applying SP4 on a SP4 and RTM (after
failure) cluster which work on VMWare don't on real hardware but it's good
enough to learn the steps.
--
Nik Marshall-Blank MCSD/MCDBA
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:ON0y6R9sFHA.3188@.TK2MSFTNGP14.phx.gbl...
> It is close enough to MSCS clustering to make you think it will work. It
> is different enough to drive you to drink.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
>> Hi,
>> I am using vmware product and i will be creating clusterd on vmware box
>> and
>> cluster sql 2000. does anyone have done that and had any issue?
>>
>
clustering SQL 2000
Hi,
I am using vmware product and i will be creating clusterd on vmware box and
cluster sql 2000. does anyone have done that and had any issue?It is close enough to MSCS clustering to make you think it will work. It is
different enough to drive you to drink.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
> Hi,
> I am using vmware product and i will be creating clusterd on vmware box
> and
> cluster sql 2000. does anyone have done that and had any issue?
>|||I've used it (VMWare) to play with clustering to get a feel for the steps in
volved etc. I was handed
an image (two images) with the OS clustered already, but I heard that VMWare
has good info on how to
set up such. For "trying it out" purposes it worked fine for me (be prepared
to increase timeouts
etc).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:ON0y6R9sFHA.3188@.TK2MSFTNGP14.phx.gbl...
> It is close enough to MSCS clustering to make you think it will work. It
is different enough to
> drive you to drink.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
>|||As Geoff says it's close enough but it never works out the same.
In my case, install scenarios for applying SP4 on a SP4 and RTM (after
failure) cluster which work on VMWare don't on real hardware but it's good
enough to learn the steps.
Nik Marshall-Blank MCSD/MCDBA
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:ON0y6R9sFHA.3188@.TK2MSFTNGP14.phx.gbl...
> It is close enough to MSCS clustering to make you think it will work. It
> is different enough to drive you to drink.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
>
I am using vmware product and i will be creating clusterd on vmware box and
cluster sql 2000. does anyone have done that and had any issue?It is close enough to MSCS clustering to make you think it will work. It is
different enough to drive you to drink.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
> Hi,
> I am using vmware product and i will be creating clusterd on vmware box
> and
> cluster sql 2000. does anyone have done that and had any issue?
>|||I've used it (VMWare) to play with clustering to get a feel for the steps in
volved etc. I was handed
an image (two images) with the OS clustered already, but I heard that VMWare
has good info on how to
set up such. For "trying it out" purposes it worked fine for me (be prepared
to increase timeouts
etc).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:ON0y6R9sFHA.3188@.TK2MSFTNGP14.phx.gbl...
> It is close enough to MSCS clustering to make you think it will work. It
is different enough to
> drive you to drink.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
>|||As Geoff says it's close enough but it never works out the same.
In my case, install scenarios for applying SP4 on a SP4 and RTM (after
failure) cluster which work on VMWare don't on real hardware but it's good
enough to learn the steps.
Nik Marshall-Blank MCSD/MCDBA
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:ON0y6R9sFHA.3188@.TK2MSFTNGP14.phx.gbl...
> It is close enough to MSCS clustering to make you think it will work. It
> is different enough to drive you to drink.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:D5D1EF4F-577F-4D86-B3D3-3BAFD95A1A8D@.microsoft.com...
>
Sunday, February 19, 2012
Clustering and Hyperthreading
Hi,
We had a problem with a clustered sql box a month or so ago and contacted MS product support. Anyway, we got a patch which appears to have fixed our problem. However, one thing was curious. I didn't speak to Moft but the person who did said MS said NOT to
turn hyperthreading on SQL clusters on! Now that shocked me. Does anyone know why? We turned it off to see whether it was reponsible for some performance issues and results were inconclusive. So we were going to turn it back on. We were strongly advised
not to do so. So does anyone know why or could point me in the right direction? I've never heard this mentioned before.
Thanks
DaveK
http://www.sqlporn.co.uk
The only time you turn it off, as far as I know of, is when you have the max
number of processors installed already.
Example: Windows XP support only 2 processors, if you have two already, turn
off Hyperthreading.
Example: Windows Enterprise supports 8 processors, if you have 8 already,
turn off Hyperthreading.
So, how many processors are in your nodes?
Cheers,
Rod
"DaveK" <anonymous@.discussions.microsoft.com> wrote in message
news:1AF8D235-E366-4CF0-8F9F-23FBBE1D25F4@.microsoft.com...
> Hi,
> We had a problem with a clustered sql box a month or so ago and contacted
MS product support. Anyway, we got a patch which appears to have fixed our
problem. However, one thing was curious. I didn't speak to Moft but the
person who did said MS said NOT to turn hyperthreading on SQL clusters on!
Now that shocked me. Does anyone know why? We turned it off to see whether
it was reponsible for some performance issues and results were inconclusive.
So we were going to turn it back on. We were strongly advised not to do so.
So does anyone know why or could point me in the right direction? I've never
heard this mentioned before.
> Thanks
> DaveK
> http://www.sqlporn.co.uk
|||Not exactly.
I have a cluster with 8-way Hyperthreaded hosts. SQL handles the 16 virtual
processors just fine. I believe that Service Pack 2 contained the code to
fix the virtual/physical processor count issue. Build 816 and 910 (post SP3
hotfixes) contain some code to improve performance on Hyperthreaded systems.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23PHgs2%23REHA.3344@.TK2MSFTNGP12.phx.gbl...
> The only time you turn it off, as far as I know of, is when you have the
max
> number of processors installed already.
> Example: Windows XP support only 2 processors, if you have two already,
turn[vbcol=seagreen]
> off Hyperthreading.
> Example: Windows Enterprise supports 8 processors, if you have 8 already,
> turn off Hyperthreading.
> So, how many processors are in your nodes?
> Cheers,
> Rod
> "DaveK" <anonymous@.discussions.microsoft.com> wrote in message
> news:1AF8D235-E366-4CF0-8F9F-23FBBE1D25F4@.microsoft.com...
contacted
> MS product support. Anyway, we got a patch which appears to have fixed our
> problem. However, one thing was curious. I didn't speak to Moft but the
> person who did said MS said NOT to turn hyperthreading on SQL clusters on!
> Now that shocked me. Does anyone know why? We turned it off to see whether
> it was reponsible for some performance issues and results were
inconclusive.
> So we were going to turn it back on. We were strongly advised not to do
so.
> So does anyone know why or could point me in the right direction? I've
never
> heard this mentioned before.
>
|||HP recommends to turn it off on XP if you have two processors. I don't have
time to lookup the article right now. With it on or off on XP, I did not see
a difference.
Cheers,
Rod
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> Not exactly.
> I have a cluster with 8-way Hyperthreaded hosts. SQL handles the 16
virtual
> processors just fine. I believe that Service Pack 2 contained the code to
> fix the virtual/physical processor count issue. Build 816 and 910 (post
SP3
> hotfixes) contain some code to improve performance on Hyperthreaded
systems.[vbcol=seagreen]
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%23PHgs2%23REHA.3344@.TK2MSFTNGP12.phx.gbl...
> max
> turn
already,[vbcol=seagreen]
> contacted
our[vbcol=seagreen]
on![vbcol=seagreen]
whether
> inconclusive.
> so.
> never
>
|||I agree with the XP recommendation. For a dedicated SQL server, I see a
significant difference between off and on. (Unisys ES7000 8x2.8GHz) Average
CPU 26% on, 40% off.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> HP recommends to turn it off on XP if you have two processors. I don't
have
> time to lookup the article right now. With it on or off on XP, I did not
see[vbcol=seagreen]
> a difference.
> Cheers,
> Rod
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> virtual
to[vbcol=seagreen]
> SP3
> systems.
the[vbcol=seagreen]
already,[vbcol=seagreen]
> already,
> our
the[vbcol=seagreen]
> on!
> whether
do
>
|||Sweet, I know I turn it on with only 2 procs, have not run into an 8 way
with it on or off. Great info, thanks!
Cheers,
Rod
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eQtgTU$REHA.3300@.TK2MSFTNGP09.phx.gbl...
> I agree with the XP recommendation. For a dedicated SQL server, I see a
> significant difference between off and on. (Unisys ES7000 8x2.8GHz)
Average[vbcol=seagreen]
> CPU 26% on, 40% off.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> have
> see
code[vbcol=seagreen]
> to
(post[vbcol=seagreen]
> the
> already,
fixed[vbcol=seagreen]
> the
clusters[vbcol=seagreen]
> do
I've
>
|||Hopefully your not trying to run a cluster on WinXP anyway<g>.
Andrew J. Kelly
SQL Server MVP
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> HP recommends to turn it off on XP if you have two processors. I don't
have
> time to lookup the article right now. With it on or off on XP, I did not
see[vbcol=seagreen]
> a difference.
> Cheers,
> Rod
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> virtual
to[vbcol=seagreen]
> SP3
> systems.
the[vbcol=seagreen]
already,[vbcol=seagreen]
> already,
> our
the[vbcol=seagreen]
> on!
> whether
do
>
|||Dave,
We put 910 into place less than a week ago when we found out why we had to have it: previously - 818 - SQL 2000 allows all logins access to the system before tempdb comes online. Well, we are a web-based company. We are running an active/active SQL cluste
r on a Win2K3 server ent ed cluster with HT enabled. So, I'm concerned to hear your comment about this option. Now, yesterday we see odd behavior on the system. Specifically the following error:
Transaction (Process ID 350) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction..
Sure, we've had deadlocks before but, not this type "communication buffer".
Another thing we've noticed is that if a process wants to go parallel, we've seen it go to 49 degrees of parallelism. You can imagine all of our CPUs are then spiking (2 servers x 8 CPUs each x HT), which in turn doesn't make the rest of the processes hap
py.
We only have SQL Server running on these servers. All web servers (over 40) can hit this cluster at any given time.
Would love to have a discussion with you. Microsoft told us that we are only the second company that reported needing the 910 patch. So, I'm expecting you are the other company. Are you web-based? Or, have lots of web server activity against your database
servers?
We've seen some other odd behavior as well. But, this e-mail is getting lengthy.
I see you are in the UK. We are in the USA.
Your reply is appreciated,
Doug
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||910 was built specifically for us after we reported a bug via Unisys.
Technically the build was for Unisys under their Premier agreement, but we
were the end customer.
I have also seen extra-high parallelism. I have limited the degree of
parallelism intentionally since I prefer higher response to the many
transactional queries rather than the few analysis-type queries.
Yes, we are very web-based. About 85-90% of our pages are .Net based. We
are the number one job board in the US (we recently passed Monster).
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doug Thomas" <dougt@.ecollege.com> wrote in message
news:uRIk$jTVEHA.3332@.tk2msftngp13.phx.gbl...
> Dave,
> We put 910 into place less than a week ago when we found out why we had to
have it: previously - 818 - SQL 2000 allows all logins access to the system
before tempdb comes online. Well, we are a web-based company. We are running
an active/active SQL cluster on a Win2K3 server ent ed cluster with HT
enabled. So, I'm concerned to hear your comment about this option. Now,
yesterday we see odd behavior on the system. Specifically the following
error:
> Transaction (Process ID 350) was deadlocked on lock | communication
buffer resources with another process and has been chosen as the deadlock
victim. Rerun the transaction..
> Sure, we've had deadlocks before but, not this type "communication
buffer".
> Another thing we've noticed is that if a process wants to go parallel,
we've seen it go to 49 degrees of parallelism. You can imagine all of our
CPUs are then spiking (2 servers x 8 CPUs each x HT), which in turn doesn't
make the rest of the processes happy.
> We only have SQL Server running on these servers. All web servers (over
40) can hit this cluster at any given time.
> Would love to have a discussion with you. Microsoft told us that we are
only the second company that reported needing the 910 patch. So, I'm
expecting you are the other company. Are you web-based? Or, have lots of web
server activity against your database servers?
> We've seen some other odd behavior as well. But, this e-mail is getting
lengthy.
> I see you are in the UK. We are in the USA.
> Your reply is appreciated,
> Doug
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...
We had a problem with a clustered sql box a month or so ago and contacted MS product support. Anyway, we got a patch which appears to have fixed our problem. However, one thing was curious. I didn't speak to Moft but the person who did said MS said NOT to
turn hyperthreading on SQL clusters on! Now that shocked me. Does anyone know why? We turned it off to see whether it was reponsible for some performance issues and results were inconclusive. So we were going to turn it back on. We were strongly advised
not to do so. So does anyone know why or could point me in the right direction? I've never heard this mentioned before.
Thanks
DaveK
http://www.sqlporn.co.uk
The only time you turn it off, as far as I know of, is when you have the max
number of processors installed already.
Example: Windows XP support only 2 processors, if you have two already, turn
off Hyperthreading.
Example: Windows Enterprise supports 8 processors, if you have 8 already,
turn off Hyperthreading.
So, how many processors are in your nodes?
Cheers,
Rod
"DaveK" <anonymous@.discussions.microsoft.com> wrote in message
news:1AF8D235-E366-4CF0-8F9F-23FBBE1D25F4@.microsoft.com...
> Hi,
> We had a problem with a clustered sql box a month or so ago and contacted
MS product support. Anyway, we got a patch which appears to have fixed our
problem. However, one thing was curious. I didn't speak to Moft but the
person who did said MS said NOT to turn hyperthreading on SQL clusters on!
Now that shocked me. Does anyone know why? We turned it off to see whether
it was reponsible for some performance issues and results were inconclusive.
So we were going to turn it back on. We were strongly advised not to do so.
So does anyone know why or could point me in the right direction? I've never
heard this mentioned before.
> Thanks
> DaveK
> http://www.sqlporn.co.uk
|||Not exactly.
I have a cluster with 8-way Hyperthreaded hosts. SQL handles the 16 virtual
processors just fine. I believe that Service Pack 2 contained the code to
fix the virtual/physical processor count issue. Build 816 and 910 (post SP3
hotfixes) contain some code to improve performance on Hyperthreaded systems.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23PHgs2%23REHA.3344@.TK2MSFTNGP12.phx.gbl...
> The only time you turn it off, as far as I know of, is when you have the
max
> number of processors installed already.
> Example: Windows XP support only 2 processors, if you have two already,
turn[vbcol=seagreen]
> off Hyperthreading.
> Example: Windows Enterprise supports 8 processors, if you have 8 already,
> turn off Hyperthreading.
> So, how many processors are in your nodes?
> Cheers,
> Rod
> "DaveK" <anonymous@.discussions.microsoft.com> wrote in message
> news:1AF8D235-E366-4CF0-8F9F-23FBBE1D25F4@.microsoft.com...
contacted
> MS product support. Anyway, we got a patch which appears to have fixed our
> problem. However, one thing was curious. I didn't speak to Moft but the
> person who did said MS said NOT to turn hyperthreading on SQL clusters on!
> Now that shocked me. Does anyone know why? We turned it off to see whether
> it was reponsible for some performance issues and results were
inconclusive.
> So we were going to turn it back on. We were strongly advised not to do
so.
> So does anyone know why or could point me in the right direction? I've
never
> heard this mentioned before.
>
|||HP recommends to turn it off on XP if you have two processors. I don't have
time to lookup the article right now. With it on or off on XP, I did not see
a difference.
Cheers,
Rod
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> Not exactly.
> I have a cluster with 8-way Hyperthreaded hosts. SQL handles the 16
virtual
> processors just fine. I believe that Service Pack 2 contained the code to
> fix the virtual/physical processor count issue. Build 816 and 910 (post
SP3
> hotfixes) contain some code to improve performance on Hyperthreaded
systems.[vbcol=seagreen]
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%23PHgs2%23REHA.3344@.TK2MSFTNGP12.phx.gbl...
> max
> turn
already,[vbcol=seagreen]
> contacted
our[vbcol=seagreen]
on![vbcol=seagreen]
whether
> inconclusive.
> so.
> never
>
|||I agree with the XP recommendation. For a dedicated SQL server, I see a
significant difference between off and on. (Unisys ES7000 8x2.8GHz) Average
CPU 26% on, 40% off.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> HP recommends to turn it off on XP if you have two processors. I don't
have
> time to lookup the article right now. With it on or off on XP, I did not
see[vbcol=seagreen]
> a difference.
> Cheers,
> Rod
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> virtual
to[vbcol=seagreen]
> SP3
> systems.
the[vbcol=seagreen]
already,[vbcol=seagreen]
> already,
> our
the[vbcol=seagreen]
> on!
> whether
do
>
|||Sweet, I know I turn it on with only 2 procs, have not run into an 8 way
with it on or off. Great info, thanks!
Cheers,
Rod
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eQtgTU$REHA.3300@.TK2MSFTNGP09.phx.gbl...
> I agree with the XP recommendation. For a dedicated SQL server, I see a
> significant difference between off and on. (Unisys ES7000 8x2.8GHz)
Average[vbcol=seagreen]
> CPU 26% on, 40% off.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> have
> see
code[vbcol=seagreen]
> to
(post[vbcol=seagreen]
> the
> already,
fixed[vbcol=seagreen]
> the
clusters[vbcol=seagreen]
> do
I've
>
|||Hopefully your not trying to run a cluster on WinXP anyway<g>.
Andrew J. Kelly
SQL Server MVP
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> HP recommends to turn it off on XP if you have two processors. I don't
have
> time to lookup the article right now. With it on or off on XP, I did not
see[vbcol=seagreen]
> a difference.
> Cheers,
> Rod
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> virtual
to[vbcol=seagreen]
> SP3
> systems.
the[vbcol=seagreen]
already,[vbcol=seagreen]
> already,
> our
the[vbcol=seagreen]
> on!
> whether
do
>
|||Dave,
We put 910 into place less than a week ago when we found out why we had to have it: previously - 818 - SQL 2000 allows all logins access to the system before tempdb comes online. Well, we are a web-based company. We are running an active/active SQL cluste
r on a Win2K3 server ent ed cluster with HT enabled. So, I'm concerned to hear your comment about this option. Now, yesterday we see odd behavior on the system. Specifically the following error:
Transaction (Process ID 350) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction..
Sure, we've had deadlocks before but, not this type "communication buffer".
Another thing we've noticed is that if a process wants to go parallel, we've seen it go to 49 degrees of parallelism. You can imagine all of our CPUs are then spiking (2 servers x 8 CPUs each x HT), which in turn doesn't make the rest of the processes hap
py.
We only have SQL Server running on these servers. All web servers (over 40) can hit this cluster at any given time.
Would love to have a discussion with you. Microsoft told us that we are only the second company that reported needing the 910 patch. So, I'm expecting you are the other company. Are you web-based? Or, have lots of web server activity against your database
servers?
We've seen some other odd behavior as well. But, this e-mail is getting lengthy.
I see you are in the UK. We are in the USA.
Your reply is appreciated,
Doug
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||910 was built specifically for us after we reported a bug via Unisys.
Technically the build was for Unisys under their Premier agreement, but we
were the end customer.
I have also seen extra-high parallelism. I have limited the degree of
parallelism intentionally since I prefer higher response to the many
transactional queries rather than the few analysis-type queries.
Yes, we are very web-based. About 85-90% of our pages are .Net based. We
are the number one job board in the US (we recently passed Monster).
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doug Thomas" <dougt@.ecollege.com> wrote in message
news:uRIk$jTVEHA.3332@.tk2msftngp13.phx.gbl...
> Dave,
> We put 910 into place less than a week ago when we found out why we had to
have it: previously - 818 - SQL 2000 allows all logins access to the system
before tempdb comes online. Well, we are a web-based company. We are running
an active/active SQL cluster on a Win2K3 server ent ed cluster with HT
enabled. So, I'm concerned to hear your comment about this option. Now,
yesterday we see odd behavior on the system. Specifically the following
error:
> Transaction (Process ID 350) was deadlocked on lock | communication
buffer resources with another process and has been chosen as the deadlock
victim. Rerun the transaction..
> Sure, we've had deadlocks before but, not this type "communication
buffer".
> Another thing we've noticed is that if a process wants to go parallel,
we've seen it go to 49 degrees of parallelism. You can imagine all of our
CPUs are then spiking (2 servers x 8 CPUs each x HT), which in turn doesn't
make the rest of the processes happy.
> We only have SQL Server running on these servers. All web servers (over
40) can hit this cluster at any given time.
> Would love to have a discussion with you. Microsoft told us that we are
only the second company that reported needing the 910 patch. So, I'm
expecting you are the other company. Are you web-based? Or, have lots of web
server activity against your database servers?
> We've seen some other odd behavior as well. But, this e-mail is getting
lengthy.
> I see you are in the UK. We are in the USA.
> Your reply is appreciated,
> Doug
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...
Clustering and Hyperthreading
Hi,
We had a problem with a clustered sql box a month or so ago and contacted MS product support. Anyway, we got a patch which appears to have fixed our problem. However, one thing was curious. I didn't speak to Moft but the person who did said MS said NOT to
turn hyperthreading on SQL clusters on! Now that shocked me. Does anyone know why? We turned it off to see whether it was reponsible for some performance issues and results were inconclusive. So we were going to turn it back on. We were strongly advised
not to do so. So does anyone know why or could point me in the right direction? I've never heard this mentioned before.
Thanks
DaveK
http://www.sqlporn.co.uk
The only time you turn it off, as far as I know of, is when you have the max
number of processors installed already.
Example: Windows XP support only 2 processors, if you have two already, turn
off Hyperthreading.
Example: Windows Enterprise supports 8 processors, if you have 8 already,
turn off Hyperthreading.
So, how many processors are in your nodes?
Cheers,
Rod
"DaveK" <anonymous@.discussions.microsoft.com> wrote in message
news:1AF8D235-E366-4CF0-8F9F-23FBBE1D25F4@.microsoft.com...
> Hi,
> We had a problem with a clustered sql box a month or so ago and contacted
MS product support. Anyway, we got a patch which appears to have fixed our
problem. However, one thing was curious. I didn't speak to Moft but the
person who did said MS said NOT to turn hyperthreading on SQL clusters on!
Now that shocked me. Does anyone know why? We turned it off to see whether
it was reponsible for some performance issues and results were inconclusive.
So we were going to turn it back on. We were strongly advised not to do so.
So does anyone know why or could point me in the right direction? I've never
heard this mentioned before.
> Thanks
> DaveK
> http://www.sqlporn.co.uk
|||Not exactly.
I have a cluster with 8-way Hyperthreaded hosts. SQL handles the 16 virtual
processors just fine. I believe that Service Pack 2 contained the code to
fix the virtual/physical processor count issue. Build 816 and 910 (post SP3
hotfixes) contain some code to improve performance on Hyperthreaded systems.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23PHgs2%23REHA.3344@.TK2MSFTNGP12.phx.gbl...
> The only time you turn it off, as far as I know of, is when you have the
max
> number of processors installed already.
> Example: Windows XP support only 2 processors, if you have two already,
turn[vbcol=seagreen]
> off Hyperthreading.
> Example: Windows Enterprise supports 8 processors, if you have 8 already,
> turn off Hyperthreading.
> So, how many processors are in your nodes?
> Cheers,
> Rod
> "DaveK" <anonymous@.discussions.microsoft.com> wrote in message
> news:1AF8D235-E366-4CF0-8F9F-23FBBE1D25F4@.microsoft.com...
contacted
> MS product support. Anyway, we got a patch which appears to have fixed our
> problem. However, one thing was curious. I didn't speak to Moft but the
> person who did said MS said NOT to turn hyperthreading on SQL clusters on!
> Now that shocked me. Does anyone know why? We turned it off to see whether
> it was reponsible for some performance issues and results were
inconclusive.
> So we were going to turn it back on. We were strongly advised not to do
so.
> So does anyone know why or could point me in the right direction? I've
never
> heard this mentioned before.
>
|||Thanks for the replies. The nodes are Dual Xeon's. So at the moment I'm running it as a dual. This is on Windows 2000 Advanced server. It's SQL 2k sp3 (8.00.919).
Thanks
DaveK
http://www.sqlporn.co.uk
|||HP recommends to turn it off on XP if you have two processors. I don't have
time to lookup the article right now. With it on or off on XP, I did not see
a difference.
Cheers,
Rod
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> Not exactly.
> I have a cluster with 8-way Hyperthreaded hosts. SQL handles the 16
virtual
> processors just fine. I believe that Service Pack 2 contained the code to
> fix the virtual/physical processor count issue. Build 816 and 910 (post
SP3
> hotfixes) contain some code to improve performance on Hyperthreaded
systems.[vbcol=seagreen]
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%23PHgs2%23REHA.3344@.TK2MSFTNGP12.phx.gbl...
> max
> turn
already,[vbcol=seagreen]
> contacted
our[vbcol=seagreen]
on![vbcol=seagreen]
whether
> inconclusive.
> so.
> never
>
|||I agree with the XP recommendation. For a dedicated SQL server, I see a
significant difference between off and on. (Unisys ES7000 8x2.8GHz) Average
CPU 26% on, 40% off.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> HP recommends to turn it off on XP if you have two processors. I don't
have
> time to lookup the article right now. With it on or off on XP, I did not
see[vbcol=seagreen]
> a difference.
> Cheers,
> Rod
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> virtual
to[vbcol=seagreen]
> SP3
> systems.
the[vbcol=seagreen]
already,[vbcol=seagreen]
> already,
> our
the[vbcol=seagreen]
> on!
> whether
do
>
|||Sweet, I know I turn it on with only 2 procs, have not run into an 8 way
with it on or off. Great info, thanks!
Cheers,
Rod
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eQtgTU$REHA.3300@.TK2MSFTNGP09.phx.gbl...
> I agree with the XP recommendation. For a dedicated SQL server, I see a
> significant difference between off and on. (Unisys ES7000 8x2.8GHz)
Average[vbcol=seagreen]
> CPU 26% on, 40% off.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> have
> see
code[vbcol=seagreen]
> to
(post[vbcol=seagreen]
> the
> already,
fixed[vbcol=seagreen]
> the
clusters[vbcol=seagreen]
> do
I've
>
|||Ok thanks. I have penned an email to the guy who spoke to MS to get some more information on why they are recommending this. I will pass on if it proves useful.
Thanks again
DaveK
http://www.sqlporn.co.uk
|||Hopefully your not trying to run a cluster on WinXP anyway<g>.
Andrew J. Kelly
SQL Server MVP
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> HP recommends to turn it off on XP if you have two processors. I don't
have
> time to lookup the article right now. With it on or off on XP, I did not
see[vbcol=seagreen]
> a difference.
> Cheers,
> Rod
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> virtual
to[vbcol=seagreen]
> SP3
> systems.
the[vbcol=seagreen]
already,[vbcol=seagreen]
> already,
> our
the[vbcol=seagreen]
> on!
> whether
do
>
We had a problem with a clustered sql box a month or so ago and contacted MS product support. Anyway, we got a patch which appears to have fixed our problem. However, one thing was curious. I didn't speak to Moft but the person who did said MS said NOT to
turn hyperthreading on SQL clusters on! Now that shocked me. Does anyone know why? We turned it off to see whether it was reponsible for some performance issues and results were inconclusive. So we were going to turn it back on. We were strongly advised
not to do so. So does anyone know why or could point me in the right direction? I've never heard this mentioned before.
Thanks
DaveK
http://www.sqlporn.co.uk
The only time you turn it off, as far as I know of, is when you have the max
number of processors installed already.
Example: Windows XP support only 2 processors, if you have two already, turn
off Hyperthreading.
Example: Windows Enterprise supports 8 processors, if you have 8 already,
turn off Hyperthreading.
So, how many processors are in your nodes?
Cheers,
Rod
"DaveK" <anonymous@.discussions.microsoft.com> wrote in message
news:1AF8D235-E366-4CF0-8F9F-23FBBE1D25F4@.microsoft.com...
> Hi,
> We had a problem with a clustered sql box a month or so ago and contacted
MS product support. Anyway, we got a patch which appears to have fixed our
problem. However, one thing was curious. I didn't speak to Moft but the
person who did said MS said NOT to turn hyperthreading on SQL clusters on!
Now that shocked me. Does anyone know why? We turned it off to see whether
it was reponsible for some performance issues and results were inconclusive.
So we were going to turn it back on. We were strongly advised not to do so.
So does anyone know why or could point me in the right direction? I've never
heard this mentioned before.
> Thanks
> DaveK
> http://www.sqlporn.co.uk
|||Not exactly.
I have a cluster with 8-way Hyperthreaded hosts. SQL handles the 16 virtual
processors just fine. I believe that Service Pack 2 contained the code to
fix the virtual/physical processor count issue. Build 816 and 910 (post SP3
hotfixes) contain some code to improve performance on Hyperthreaded systems.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23PHgs2%23REHA.3344@.TK2MSFTNGP12.phx.gbl...
> The only time you turn it off, as far as I know of, is when you have the
max
> number of processors installed already.
> Example: Windows XP support only 2 processors, if you have two already,
turn[vbcol=seagreen]
> off Hyperthreading.
> Example: Windows Enterprise supports 8 processors, if you have 8 already,
> turn off Hyperthreading.
> So, how many processors are in your nodes?
> Cheers,
> Rod
> "DaveK" <anonymous@.discussions.microsoft.com> wrote in message
> news:1AF8D235-E366-4CF0-8F9F-23FBBE1D25F4@.microsoft.com...
contacted
> MS product support. Anyway, we got a patch which appears to have fixed our
> problem. However, one thing was curious. I didn't speak to Moft but the
> person who did said MS said NOT to turn hyperthreading on SQL clusters on!
> Now that shocked me. Does anyone know why? We turned it off to see whether
> it was reponsible for some performance issues and results were
inconclusive.
> So we were going to turn it back on. We were strongly advised not to do
so.
> So does anyone know why or could point me in the right direction? I've
never
> heard this mentioned before.
>
|||Thanks for the replies. The nodes are Dual Xeon's. So at the moment I'm running it as a dual. This is on Windows 2000 Advanced server. It's SQL 2k sp3 (8.00.919).
Thanks
DaveK
http://www.sqlporn.co.uk
|||HP recommends to turn it off on XP if you have two processors. I don't have
time to lookup the article right now. With it on or off on XP, I did not see
a difference.
Cheers,
Rod
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> Not exactly.
> I have a cluster with 8-way Hyperthreaded hosts. SQL handles the 16
virtual
> processors just fine. I believe that Service Pack 2 contained the code to
> fix the virtual/physical processor count issue. Build 816 and 910 (post
SP3
> hotfixes) contain some code to improve performance on Hyperthreaded
systems.[vbcol=seagreen]
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%23PHgs2%23REHA.3344@.TK2MSFTNGP12.phx.gbl...
> max
> turn
already,[vbcol=seagreen]
> contacted
our[vbcol=seagreen]
on![vbcol=seagreen]
whether
> inconclusive.
> so.
> never
>
|||I agree with the XP recommendation. For a dedicated SQL server, I see a
significant difference between off and on. (Unisys ES7000 8x2.8GHz) Average
CPU 26% on, 40% off.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> HP recommends to turn it off on XP if you have two processors. I don't
have
> time to lookup the article right now. With it on or off on XP, I did not
see[vbcol=seagreen]
> a difference.
> Cheers,
> Rod
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> virtual
to[vbcol=seagreen]
> SP3
> systems.
the[vbcol=seagreen]
already,[vbcol=seagreen]
> already,
> our
the[vbcol=seagreen]
> on!
> whether
do
>
|||Sweet, I know I turn it on with only 2 procs, have not run into an 8 way
with it on or off. Great info, thanks!
Cheers,
Rod
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eQtgTU$REHA.3300@.TK2MSFTNGP09.phx.gbl...
> I agree with the XP recommendation. For a dedicated SQL server, I see a
> significant difference between off and on. (Unisys ES7000 8x2.8GHz)
Average[vbcol=seagreen]
> CPU 26% on, 40% off.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> have
> see
code[vbcol=seagreen]
> to
(post[vbcol=seagreen]
> the
> already,
fixed[vbcol=seagreen]
> the
clusters[vbcol=seagreen]
> do
I've
>
|||Ok thanks. I have penned an email to the guy who spoke to MS to get some more information on why they are recommending this. I will pass on if it proves useful.
Thanks again
DaveK
http://www.sqlporn.co.uk
|||Hopefully your not trying to run a cluster on WinXP anyway<g>.
Andrew J. Kelly
SQL Server MVP
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> HP recommends to turn it off on XP if you have two processors. I don't
have
> time to lookup the article right now. With it on or off on XP, I did not
see[vbcol=seagreen]
> a difference.
> Cheers,
> Rod
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> virtual
to[vbcol=seagreen]
> SP3
> systems.
the[vbcol=seagreen]
already,[vbcol=seagreen]
> already,
> our
the[vbcol=seagreen]
> on!
> whether
do
>
Clustering and Hyperthreading
Hi,
We had a problem with a clustered sql box a month or so ago and contacted MS
product support. Anyway, we got a patch which appears to have fixed our pro
blem. However, one thing was curious. I didn't speak to Moft but the person
who did said MS said NOT to
turn hyperthreading on SQL clusters on! Now that shocked me. Does anyone kno
w why? We turned it off to see whether it was reponsible for some performanc
e issues and results were inconclusive. So we were going to turn it back on.
We were strongly advised
not to do so. So does anyone know why or could point me in the right directi
on? I've never heard this mentioned before.
Thanks
DaveK
http://www.sqlporn.co.ukThe only time you turn it off, as far as I know of, is when you have the max
number of processors installed already.
Example: Windows XP support only 2 processors, if you have two already, turn
off Hyperthreading.
Example: Windows Enterprise supports 8 processors, if you have 8 already,
turn off Hyperthreading.
So, how many processors are in your nodes?
Cheers,
Rod
"DaveK" <anonymous@.discussions.microsoft.com> wrote in message
news:1AF8D235-E366-4CF0-8F9F-23FBBE1D25F4@.microsoft.com...
> Hi,
> We had a problem with a clustered sql box a month or so ago and contacted
MS product support. Anyway, we got a patch which appears to have fixed our
problem. However, one thing was curious. I didn't speak to Moft but the
person who did said MS said NOT to turn hyperthreading on SQL clusters on!
Now that shocked me. Does anyone know why? We turned it off to see whether
it was reponsible for some performance issues and results were inconclusive.
So we were going to turn it back on. We were strongly advised not to do so.
So does anyone know why or could point me in the right direction? I've never
heard this mentioned before.
> Thanks
> DaveK
> http://www.sqlporn.co.uk|||Not exactly.
I have a cluster with 8-way Hyperthreaded hosts. SQL handles the 16 virtual
processors just fine. I believe that Service Pack 2 contained the code to
fix the virtual/physical processor count issue. Build 816 and 910 (post SP3
hotfixes) contain some code to improve performance on Hyperthreaded systems.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23PHgs2%23REHA.3344@.TK2MSFTNGP12.phx.gbl...
> The only time you turn it off, as far as I know of, is when you have the
max
> number of processors installed already.
> Example: Windows XP support only 2 processors, if you have two already,
turn
> off Hyperthreading.
> Example: Windows Enterprise supports 8 processors, if you have 8 already,
> turn off Hyperthreading.
> So, how many processors are in your nodes?
> Cheers,
> Rod
> "DaveK" <anonymous@.discussions.microsoft.com> wrote in message
> news:1AF8D235-E366-4CF0-8F9F-23FBBE1D25F4@.microsoft.com...
contacted[vbcol=seagreen]
> MS product support. Anyway, we got a patch which appears to have fixed our
> problem. However, one thing was curious. I didn't speak to Moft but the
> person who did said MS said NOT to turn hyperthreading on SQL clusters on!
> Now that shocked me. Does anyone know why? We turned it off to see whether
> it was reponsible for some performance issues and results were
inconclusive.
> So we were going to turn it back on. We were strongly advised not to do
so.
> So does anyone know why or could point me in the right direction? I've
never
> heard this mentioned before.
>|||Thanks for the replies. The nodes are Dual Xeon's. So at the moment I'm runn
ing it as a dual. This is on Windows 2000 Advanced server. It's SQL 2k sp3 (
8.00.919).
Thanks
DaveK
http://www.sqlporn.co.uk|||HP recommends to turn it off on XP if you have two processors. I don't have
time to lookup the article right now. With it on or off on XP, I did not see
a difference.
Cheers,
Rod
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> Not exactly.
> I have a cluster with 8-way Hyperthreaded hosts. SQL handles the 16
virtual
> processors just fine. I believe that Service Pack 2 contained the code to
> fix the virtual/physical processor count issue. Build 816 and 910 (post
SP3
> hotfixes) contain some code to improve performance on Hyperthreaded
systems.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%23PHgs2%23REHA.3344@.TK2MSFTNGP12.phx.gbl...
> max
> turn
already,[vbcol=seagreen]
> contacted
our[vbcol=seagreen]
on![vbcol=seagreen]
whether[vbcol=seagreen]
> inconclusive.
> so.
> never
>|||I agree with the XP recommendation. For a dedicated SQL server, I see a
significant difference between off and on. (Unisys ES7000 8x2.8GHz) Average
CPU 26% on, 40% off.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> HP recommends to turn it off on XP if you have two processors. I don't
have
> time to lookup the article right now. With it on or off on XP, I did not
see
> a difference.
> Cheers,
> Rod
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> virtual
to[vbcol=seagreen]
> SP3
> systems.
the[vbcol=seagreen]
already,[vbcol=seagreen]
> already,
> our
the[vbcol=seagreen]
> on!
> whether
do[vbcol=seagreen]
>|||Sweet, I know I turn it on with only 2 procs, have not run into an 8 way
with it on or off. Great info, thanks!
Cheers,
Rod
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eQtgTU$REHA.3300@.TK2MSFTNGP09.phx.gbl...
> I agree with the XP recommendation. For a dedicated SQL server, I see a
> significant difference between off and on. (Unisys ES7000 8x2.8GHz)
Average
> CPU 26% on, 40% off.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> have
> see
code[vbcol=seagreen]
> to
(post[vbcol=seagreen]
> the
> already,
fixed[vbcol=seagreen]
> the
clusters[vbcol=seagreen]
> do
I've[vbcol=seagreen]
>|||Ok thanks. I have penned an email to the guy who spoke to MS to get some mor
e information on why they are recommending this. I will pass on if it proves
useful.
Thanks again
DaveK
http://www.sqlporn.co.uk|||Hopefully your not trying to run a cluster on WinXP anyway<g>.
Andrew J. Kelly
SQL Server MVP
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> HP recommends to turn it off on XP if you have two processors. I don't
have
> time to lookup the article right now. With it on or off on XP, I did not
see
> a difference.
> Cheers,
> Rod
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> virtual
to[vbcol=seagreen]
> SP3
> systems.
the[vbcol=seagreen]
already,[vbcol=seagreen]
> already,
> our
the[vbcol=seagreen]
> on!
> whether
do[vbcol=seagreen]
>
We had a problem with a clustered sql box a month or so ago and contacted MS
product support. Anyway, we got a patch which appears to have fixed our pro
blem. However, one thing was curious. I didn't speak to Moft but the person
who did said MS said NOT to
turn hyperthreading on SQL clusters on! Now that shocked me. Does anyone kno
w why? We turned it off to see whether it was reponsible for some performanc
e issues and results were inconclusive. So we were going to turn it back on.
We were strongly advised
not to do so. So does anyone know why or could point me in the right directi
on? I've never heard this mentioned before.
Thanks
DaveK
http://www.sqlporn.co.ukThe only time you turn it off, as far as I know of, is when you have the max
number of processors installed already.
Example: Windows XP support only 2 processors, if you have two already, turn
off Hyperthreading.
Example: Windows Enterprise supports 8 processors, if you have 8 already,
turn off Hyperthreading.
So, how many processors are in your nodes?
Cheers,
Rod
"DaveK" <anonymous@.discussions.microsoft.com> wrote in message
news:1AF8D235-E366-4CF0-8F9F-23FBBE1D25F4@.microsoft.com...
> Hi,
> We had a problem with a clustered sql box a month or so ago and contacted
MS product support. Anyway, we got a patch which appears to have fixed our
problem. However, one thing was curious. I didn't speak to Moft but the
person who did said MS said NOT to turn hyperthreading on SQL clusters on!
Now that shocked me. Does anyone know why? We turned it off to see whether
it was reponsible for some performance issues and results were inconclusive.
So we were going to turn it back on. We were strongly advised not to do so.
So does anyone know why or could point me in the right direction? I've never
heard this mentioned before.
> Thanks
> DaveK
> http://www.sqlporn.co.uk|||Not exactly.
I have a cluster with 8-way Hyperthreaded hosts. SQL handles the 16 virtual
processors just fine. I believe that Service Pack 2 contained the code to
fix the virtual/physical processor count issue. Build 816 and 910 (post SP3
hotfixes) contain some code to improve performance on Hyperthreaded systems.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23PHgs2%23REHA.3344@.TK2MSFTNGP12.phx.gbl...
> The only time you turn it off, as far as I know of, is when you have the
max
> number of processors installed already.
> Example: Windows XP support only 2 processors, if you have two already,
turn
> off Hyperthreading.
> Example: Windows Enterprise supports 8 processors, if you have 8 already,
> turn off Hyperthreading.
> So, how many processors are in your nodes?
> Cheers,
> Rod
> "DaveK" <anonymous@.discussions.microsoft.com> wrote in message
> news:1AF8D235-E366-4CF0-8F9F-23FBBE1D25F4@.microsoft.com...
contacted[vbcol=seagreen]
> MS product support. Anyway, we got a patch which appears to have fixed our
> problem. However, one thing was curious. I didn't speak to Moft but the
> person who did said MS said NOT to turn hyperthreading on SQL clusters on!
> Now that shocked me. Does anyone know why? We turned it off to see whether
> it was reponsible for some performance issues and results were
inconclusive.
> So we were going to turn it back on. We were strongly advised not to do
so.
> So does anyone know why or could point me in the right direction? I've
never
> heard this mentioned before.
>|||Thanks for the replies. The nodes are Dual Xeon's. So at the moment I'm runn
ing it as a dual. This is on Windows 2000 Advanced server. It's SQL 2k sp3 (
8.00.919).
Thanks
DaveK
http://www.sqlporn.co.uk|||HP recommends to turn it off on XP if you have two processors. I don't have
time to lookup the article right now. With it on or off on XP, I did not see
a difference.
Cheers,
Rod
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> Not exactly.
> I have a cluster with 8-way Hyperthreaded hosts. SQL handles the 16
virtual
> processors just fine. I believe that Service Pack 2 contained the code to
> fix the virtual/physical processor count issue. Build 816 and 910 (post
SP3
> hotfixes) contain some code to improve performance on Hyperthreaded
systems.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%23PHgs2%23REHA.3344@.TK2MSFTNGP12.phx.gbl...
> max
> turn
already,[vbcol=seagreen]
> contacted
our[vbcol=seagreen]
on![vbcol=seagreen]
whether[vbcol=seagreen]
> inconclusive.
> so.
> never
>|||I agree with the XP recommendation. For a dedicated SQL server, I see a
significant difference between off and on. (Unisys ES7000 8x2.8GHz) Average
CPU 26% on, 40% off.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> HP recommends to turn it off on XP if you have two processors. I don't
have
> time to lookup the article right now. With it on or off on XP, I did not
see
> a difference.
> Cheers,
> Rod
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> virtual
to[vbcol=seagreen]
> SP3
> systems.
the[vbcol=seagreen]
already,[vbcol=seagreen]
> already,
> our
the[vbcol=seagreen]
> on!
> whether
do[vbcol=seagreen]
>|||Sweet, I know I turn it on with only 2 procs, have not run into an 8 way
with it on or off. Great info, thanks!
Cheers,
Rod
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eQtgTU$REHA.3300@.TK2MSFTNGP09.phx.gbl...
> I agree with the XP recommendation. For a dedicated SQL server, I see a
> significant difference between off and on. (Unisys ES7000 8x2.8GHz)
Average
> CPU 26% on, 40% off.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> have
> see
code[vbcol=seagreen]
> to
(post[vbcol=seagreen]
> the
> already,
fixed[vbcol=seagreen]
> the
clusters[vbcol=seagreen]
> do
I've[vbcol=seagreen]
>|||Ok thanks. I have penned an email to the guy who spoke to MS to get some mor
e information on why they are recommending this. I will pass on if it proves
useful.
Thanks again
DaveK
http://www.sqlporn.co.uk|||Hopefully your not trying to run a cluster on WinXP anyway<g>.
Andrew J. Kelly
SQL Server MVP
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O6nr$E$REHA.3504@.TK2MSFTNGP09.phx.gbl...
> HP recommends to turn it off on XP if you have two processors. I don't
have
> time to lookup the article right now. With it on or off on XP, I did not
see
> a difference.
> Cheers,
> Rod
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eKGGZ6%23REHA.1312@.TK2MSFTNGP12.phx.gbl...
> virtual
to[vbcol=seagreen]
> SP3
> systems.
the[vbcol=seagreen]
already,[vbcol=seagreen]
> already,
> our
the[vbcol=seagreen]
> on!
> whether
do[vbcol=seagreen]
>
Subscribe to:
Posts (Atom)