dbTalk Databases Forums  

Performance discrepancy between two boxes on an active/active?

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


Discuss Performance discrepancy between two boxes on an active/active? in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
M Bourgon
 
Posts: n/a

Default Performance discrepancy between two boxes on an active/active? - 03-23-2008 , 08:46 PM






Howdy. I'm running an Active/Active cluster on a SQL Server 2005
cluster. Both have identical hardware, and obviously the same disks.
One really odd thing I'm seeing, though: the first Active node,
running on the first box, sucks. When trying to connect, list SPs,
"wait 2 minutes to view a job",etc. However, when we recently ran
both instances on the second box, the performance seems much snappier.

Where should I be looking to try and figure out what's causing this?
Neither node is running extra software the other isn't. But
something's going on.

Thanks.

Reply With Quote
  #2  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Performance discrepancy between two boxes on an active/active? - 03-23-2008 , 08:58 PM






Just a shot in the dark here. Are you using AWE on a 32-bit box? If so,
could you check the BOOT.INI file on each box and ensure that /PAE is in
both?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"M Bourgon" <bourgon (AT) gmail (DOT) com> wrote

Howdy. I'm running an Active/Active cluster on a SQL Server 2005
cluster. Both have identical hardware, and obviously the same disks.
One really odd thing I'm seeing, though: the first Active node,
running on the first box, sucks. When trying to connect, list SPs,
"wait 2 minutes to view a job",etc. However, when we recently ran
both instances on the second box, the performance seems much snappier.

Where should I be looking to try and figure out what's causing this?
Neither node is running extra software the other isn't. But
something's going on.

Thanks.


Reply With Quote
  #3  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Performance discrepancy between two boxes on an active/active? - 03-23-2008 , 08:58 PM



Just a shot in the dark here. Are you using AWE on a 32-bit box? If so,
could you check the BOOT.INI file on each box and ensure that /PAE is in
both?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"M Bourgon" <bourgon (AT) gmail (DOT) com> wrote

Howdy. I'm running an Active/Active cluster on a SQL Server 2005
cluster. Both have identical hardware, and obviously the same disks.
One really odd thing I'm seeing, though: the first Active node,
running on the first box, sucks. When trying to connect, list SPs,
"wait 2 minutes to view a job",etc. However, when we recently ran
both instances on the second box, the performance seems much snappier.

Where should I be looking to try and figure out what's causing this?
Neither node is running extra software the other isn't. But
something's going on.

Thanks.


Reply With Quote
  #4  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Performance discrepancy between two boxes on an active/active? - 03-23-2008 , 08:58 PM



Just a shot in the dark here. Are you using AWE on a 32-bit box? If so,
could you check the BOOT.INI file on each box and ensure that /PAE is in
both?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"M Bourgon" <bourgon (AT) gmail (DOT) com> wrote

Howdy. I'm running an Active/Active cluster on a SQL Server 2005
cluster. Both have identical hardware, and obviously the same disks.
One really odd thing I'm seeing, though: the first Active node,
running on the first box, sucks. When trying to connect, list SPs,
"wait 2 minutes to view a job",etc. However, when we recently ran
both instances on the second box, the performance seems much snappier.

Where should I be looking to try and figure out what's causing this?
Neither node is running extra software the other isn't. But
something's going on.

Thanks.


Reply With Quote
  #5  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Performance discrepancy between two boxes on an active/active? - 03-23-2008 , 08:58 PM



Just a shot in the dark here. Are you using AWE on a 32-bit box? If so,
could you check the BOOT.INI file on each box and ensure that /PAE is in
both?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"M Bourgon" <bourgon (AT) gmail (DOT) com> wrote

Howdy. I'm running an Active/Active cluster on a SQL Server 2005
cluster. Both have identical hardware, and obviously the same disks.
One really odd thing I'm seeing, though: the first Active node,
running on the first box, sucks. When trying to connect, list SPs,
"wait 2 minutes to view a job",etc. However, when we recently ran
both instances on the second box, the performance seems much snappier.

Where should I be looking to try and figure out what's causing this?
Neither node is running extra software the other isn't. But
something's going on.

Thanks.


Reply With Quote
  #6  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Performance discrepancy between two boxes on an active/active? - 03-23-2008 , 08:58 PM



Just a shot in the dark here. Are you using AWE on a 32-bit box? If so,
could you check the BOOT.INI file on each box and ensure that /PAE is in
both?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"M Bourgon" <bourgon (AT) gmail (DOT) com> wrote

Howdy. I'm running an Active/Active cluster on a SQL Server 2005
cluster. Both have identical hardware, and obviously the same disks.
One really odd thing I'm seeing, though: the first Active node,
running on the first box, sucks. When trying to connect, list SPs,
"wait 2 minutes to view a job",etc. However, when we recently ran
both instances on the second box, the performance seems much snappier.

Where should I be looking to try and figure out what's causing this?
Neither node is running extra software the other isn't. But
something's going on.

Thanks.


Reply With Quote
  #7  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Performance discrepancy between two boxes on an active/active? - 03-23-2008 , 08:58 PM



Just a shot in the dark here. Are you using AWE on a 32-bit box? If so,
could you check the BOOT.INI file on each box and ensure that /PAE is in
both?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"M Bourgon" <bourgon (AT) gmail (DOT) com> wrote

Howdy. I'm running an Active/Active cluster on a SQL Server 2005
cluster. Both have identical hardware, and obviously the same disks.
One really odd thing I'm seeing, though: the first Active node,
running on the first box, sucks. When trying to connect, list SPs,
"wait 2 minutes to view a job",etc. However, when we recently ran
both instances on the second box, the performance seems much snappier.

Where should I be looking to try and figure out what's causing this?
Neither node is running extra software the other isn't. But
something's going on.

Thanks.


Reply With Quote
  #8  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Performance discrepancy between two boxes on an active/active? - 03-23-2008 , 08:58 PM



Just a shot in the dark here. Are you using AWE on a 32-bit box? If so,
could you check the BOOT.INI file on each box and ensure that /PAE is in
both?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"M Bourgon" <bourgon (AT) gmail (DOT) com> wrote

Howdy. I'm running an Active/Active cluster on a SQL Server 2005
cluster. Both have identical hardware, and obviously the same disks.
One really odd thing I'm seeing, though: the first Active node,
running on the first box, sucks. When trying to connect, list SPs,
"wait 2 minutes to view a job",etc. However, when we recently ran
both instances on the second box, the performance seems much snappier.

Where should I be looking to try and figure out what's causing this?
Neither node is running extra software the other isn't. But
something's going on.

Thanks.


Reply With Quote
  #9  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Performance discrepancy between two boxes on an active/active? - 03-23-2008 , 08:58 PM



Just a shot in the dark here. Are you using AWE on a 32-bit box? If so,
could you check the BOOT.INI file on each box and ensure that /PAE is in
both?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"M Bourgon" <bourgon (AT) gmail (DOT) com> wrote

Howdy. I'm running an Active/Active cluster on a SQL Server 2005
cluster. Both have identical hardware, and obviously the same disks.
One really odd thing I'm seeing, though: the first Active node,
running on the first box, sucks. When trying to connect, list SPs,
"wait 2 minutes to view a job",etc. However, when we recently ran
both instances on the second box, the performance seems much snappier.

Where should I be looking to try and figure out what's causing this?
Neither node is running extra software the other isn't. But
something's going on.

Thanks.


Reply With Quote
  #10  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Performance discrepancy between two boxes on an active/active? - 03-23-2008 , 08:58 PM



Just a shot in the dark here. Are you using AWE on a 32-bit box? If so,
could you check the BOOT.INI file on each box and ensure that /PAE is in
both?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"M Bourgon" <bourgon (AT) gmail (DOT) com> wrote

Howdy. I'm running an Active/Active cluster on a SQL Server 2005
cluster. Both have identical hardware, and obviously the same disks.
One really odd thing I'm seeing, though: the first Active node,
running on the first box, sucks. When trying to connect, list SPs,
"wait 2 minutes to view a job",etc. However, when we recently ran
both instances on the second box, the performance seems much snappier.

Where should I be looking to try and figure out what's causing this?
Neither node is running extra software the other isn't. But
something's going on.

Thanks.


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.