dbTalk Databases Forums  

Active/Active 2005 Slowness

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Active/Active 2005 Slowness in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kevin A
 
Posts: n/a

Default Active/Active 2005 Slowness - 06-12-2008 , 11:04 AM






Anyone have any ideas why a SQL 2005 active/active configuration, would be
noticibly slower than if I move one of the active nodes to the other and run
on the same node?

It doesn't matter which node I put them on, when I run them on 2 different
nodes, SLOW, when I move them both to the same node, faster. Each node has
the same config, and it doesn't matter which instance is on which node.
They are both slow by themselves.

Anything from a SQL or configuration standpoint?



Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Active/Active 2005 Slowness - 06-13-2008 , 11:00 AM






What is your storage system?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Kevin A" <kevina (AT) cqlcorp (DOT) com> wrote

Quote:
Anyone have any ideas why a SQL 2005 active/active configuration, would be
noticibly slower than if I move one of the active nodes to the other and
run on the same node?

It doesn't matter which node I put them on, when I run them on 2 different
nodes, SLOW, when I move them both to the same node, faster. Each node
has the same config, and it doesn't matter which instance is on which
node. They are both slow by themselves.

Anything from a SQL or configuration standpoint?



Reply With Quote
  #3  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Active/Active 2005 Slowness - 06-13-2008 , 11:00 AM



What is your storage system?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Kevin A" <kevina (AT) cqlcorp (DOT) com> wrote

Quote:
Anyone have any ideas why a SQL 2005 active/active configuration, would be
noticibly slower than if I move one of the active nodes to the other and
run on the same node?

It doesn't matter which node I put them on, when I run them on 2 different
nodes, SLOW, when I move them both to the same node, faster. Each node
has the same config, and it doesn't matter which instance is on which
node. They are both slow by themselves.

Anything from a SQL or configuration standpoint?



Reply With Quote
  #4  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Active/Active 2005 Slowness - 06-13-2008 , 11:00 AM



What is your storage system?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Kevin A" <kevina (AT) cqlcorp (DOT) com> wrote

Quote:
Anyone have any ideas why a SQL 2005 active/active configuration, would be
noticibly slower than if I move one of the active nodes to the other and
run on the same node?

It doesn't matter which node I put them on, when I run them on 2 different
nodes, SLOW, when I move them both to the same node, faster. Each node
has the same config, and it doesn't matter which instance is on which
node. They are both slow by themselves.

Anything from a SQL or configuration standpoint?



Reply With Quote
  #5  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Active/Active 2005 Slowness - 06-13-2008 , 11:00 AM



What is your storage system?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Kevin A" <kevina (AT) cqlcorp (DOT) com> wrote

Quote:
Anyone have any ideas why a SQL 2005 active/active configuration, would be
noticibly slower than if I move one of the active nodes to the other and
run on the same node?

It doesn't matter which node I put them on, when I run them on 2 different
nodes, SLOW, when I move them both to the same node, faster. Each node
has the same config, and it doesn't matter which instance is on which
node. They are both slow by themselves.

Anything from a SQL or configuration standpoint?



Reply With Quote
  #6  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Active/Active 2005 Slowness - 06-13-2008 , 11:00 AM



What is your storage system?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Kevin A" <kevina (AT) cqlcorp (DOT) com> wrote

Quote:
Anyone have any ideas why a SQL 2005 active/active configuration, would be
noticibly slower than if I move one of the active nodes to the other and
run on the same node?

It doesn't matter which node I put them on, when I run them on 2 different
nodes, SLOW, when I move them both to the same node, faster. Each node
has the same config, and it doesn't matter which instance is on which
node. They are both slow by themselves.

Anything from a SQL or configuration standpoint?



Reply With Quote
  #7  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Active/Active 2005 Slowness - 06-13-2008 , 11:00 AM



What is your storage system?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Kevin A" <kevina (AT) cqlcorp (DOT) com> wrote

Quote:
Anyone have any ideas why a SQL 2005 active/active configuration, would be
noticibly slower than if I move one of the active nodes to the other and
run on the same node?

It doesn't matter which node I put them on, when I run them on 2 different
nodes, SLOW, when I move them both to the same node, faster. Each node
has the same config, and it doesn't matter which instance is on which
node. They are both slow by themselves.

Anything from a SQL or configuration standpoint?



Reply With Quote
  #8  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Active/Active 2005 Slowness - 06-13-2008 , 11:00 AM



What is your storage system?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Kevin A" <kevina (AT) cqlcorp (DOT) com> wrote

Quote:
Anyone have any ideas why a SQL 2005 active/active configuration, would be
noticibly slower than if I move one of the active nodes to the other and
run on the same node?

It doesn't matter which node I put them on, when I run them on 2 different
nodes, SLOW, when I move them both to the same node, faster. Each node
has the same config, and it doesn't matter which instance is on which
node. They are both slow by themselves.

Anything from a SQL or configuration standpoint?



Reply With Quote
  #9  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Active/Active 2005 Slowness - 06-13-2008 , 11:00 AM



What is your storage system?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Kevin A" <kevina (AT) cqlcorp (DOT) com> wrote

Quote:
Anyone have any ideas why a SQL 2005 active/active configuration, would be
noticibly slower than if I move one of the active nodes to the other and
run on the same node?

It doesn't matter which node I put them on, when I run them on 2 different
nodes, SLOW, when I move them both to the same node, faster. Each node
has the same config, and it doesn't matter which instance is on which
node. They are both slow by themselves.

Anything from a SQL or configuration standpoint?



Reply With Quote
  #10  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Active/Active 2005 Slowness - 06-13-2008 , 11:00 AM



What is your storage system?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Kevin A" <kevina (AT) cqlcorp (DOT) com> wrote

Quote:
Anyone have any ideas why a SQL 2005 active/active configuration, would be
noticibly slower than if I move one of the active nodes to the other and
run on the same node?

It doesn't matter which node I put them on, when I run them on 2 different
nodes, SLOW, when I move them both to the same node, faster. Each node
has the same config, and it doesn't matter which instance is on which
node. They are both slow by themselves.

Anything from a SQL or configuration standpoint?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.